I keep getting the deadlock error - Mysql error: Deadlock found when trying to get lock when updating products
.
I did not write the sql statement and to me it's a mess. Writing a new app but need to fix this until then. I added - INTERVAL 900 SECOND order by id. The deadlock doesn't appear but now it doesn't update the products. Can someone show a better solution or show me why it's not updating?
$sql = "UPDATE `"