• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
WHERE condition has missed in query

#1
We faced an issue while updating a table record.

We have provided WHERE condition to update 1 record in table. But in query there is no WHERE condition (its missed) while updating for that table. So query has updated all the 20 k records in table.

Query:

$result = $this->update($id, TABLE_NAME);


In log:

UPDATE `TABLE_NAME` SET `status` = 1, `user_id` = 322, `updated_by` = 'system'

Expected:
UPDATE `TABLE_NAME` SET `status` = 1, `user_id` = 322, `updated_by` = 'system' WHERE `TABLE_NAME`.`id` =  '2454'


This logic is there from long time and it was working fine. At particular time the WHERE condition has broken and till now we are not able to replicate the issue.
Reply


Messages In This Thread
WHERE condition has missed in query - by Sangamesh - 07-01-2019, 09:34 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.