After upgrading to MySQL 8 some of my queries went all over the place. Some i’ve managed to fix but there is 1 that is giving me a very hard time and i don’t know how or what to do to find out what is wrong.
The query gives over and over again the error " Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near WHERE id = xxxx "
And the query is
mysqli_query($GLOBALS["___mysqli_ston"], “UPDATE articles SET " . join(”,", $updateset) . " WHERE id = " . sqlesc($articleid)) or sqlerr(FILE, LINE);
Since its a join thing i’ve looked at the codes that are required for this but cant find anything out of place. I can only assume that the data it tries to update is corrupted somehow.