Deletes are not allowed unless they contain a "where" or "like" clause. - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11) +--- Thread: Deletes are not allowed unless they contain a "where" or "like" clause. (/showthread.php?tid=75760) |
Deletes are not allowed unless they contain a "where" or "like" clause. - pippuccio76 - 03-13-2020 HI , this is my code : Code: $this->db->from('eventi_partecipanti_accompagnatori'); But i have this error : Code: Deletes are not allowed unless they contain a "where" or "like" clause. How can i solve it ? RE: Deletes are not allowed unless they contain a "where" or "like" clause. - neuron - 03-13-2020 I see it is hard coded in the system QB, you can either implement your custom QB and override delete method or implement your own method, or you can add dummy where $this->db->where('1=1', NULL, FALSE); Do little research on how to extend query builder, there are must be examples. Because it is also requires to extend the Loader library This rule is implemented for safety reason, you may unintentionally delete all the records in the table which may cause more headache for you. RE: Deletes are not allowed unless they contain a "where" or "like" clause. - pippuccio76 - 03-13-2020 (03-13-2020, 06:09 AM)neuron Wrote: I see it is hard coded in the system QB, you can either implement your custom QB and override delete method or implement your own method,But there are two where , join but there are... RE: Deletes are not allowed unless they contain a "where" or "like" clause. - neuron - 03-13-2020 I am sorry , I don't why I did not have look to your code, before answering. I never did delete with using QB, so I am not sure your code produces the right SQL code. try running Code: echo $this->db->get_compiled_delete('eventi_partecipanti_accompagnatori'); (03-13-2020, 06:53 AM)neuron Wrote: I am sorry , I don't why I did not have look to your code, before answering. Also I see you can remove 'left' arguments from you joins, as where clause will eventually filter those NULL fields. RE: Deletes are not allowed unless they contain a "where" or "like" clause. - pippuccio76 - 03-13-2020 (03-13-2020, 06:53 AM)neuron Wrote: I am sorry , I don't why I did not have look to your code, before answering. I insert the query without QB and the query it'ok run on adminer ( similar to phpmyadmin) Code: $sql = "DELETE eventi_partecipanti_accompagnatori but same problems... RE: Deletes are not allowed unless they contain a "where" or "like" clause. - pippuccio76 - 03-18-2020 (03-13-2020, 10:14 AM)pippuccio76 Wrote:(03-13-2020, 06:53 AM)neuron Wrote: I am sorry , I don't why I did not have look to your code, before answering. Sorry the file isn't uploaded , the query work fine. |