1064 Error upgrading from 5.4.2.2 to 5.5
Permalink 1 user found helpful
Im using a windows server and IIS and am getting this error when trying to upgrade. Any ideas?
An Unexpected Error occurred while upgrading: mysql error: [1064: 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 '' at line 1] in EXECUTE("update Pages set cPendingAction = null, cPendingActionUID = null, cPendingActionDatetime = null where cID = ")
An Unexpected Error occurred while upgrading: mysql error: [1064: 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 '' at line 1] in EXECUTE("update Pages set cPendingAction = null, cPendingActionUID = null, cPendingActionDatetime = null where cID = ")
It relates to this thread
http://www.concrete5.org/developers/bugs/5-5-0/sql-error-in-clearpe...
I found this line in concrete/models/page.php (this is in the folder in updates where you are going to upgrade not the root concrete folder)
$q = "update Pages set cPendingAction = null, cPendingActionUID = null, cPendingActionDatetime = null where cID = {$cID}";
and replaced it with
$q = "update Pages set cPendingAction = null, cPendingActionUID = null, cPendingActionDatetime = 0 where cID = 15";