You have an error in your SQL syntax while upgrading

Started by iwcook, August 02, 2019, 05:18:33 AM

Previous topic - Next topic

iwcook

Hi,
I am upgrading smf v1.0 to v2.0.15
Had to upgrade because the old version had php version errors.
(link to php info if it helps is hxxp:www.kirbyfooty.com/phpinfo.php [nonactive]

Anyways, I have struck a problem while running upgrade.php

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 ' width = 691, height = 391 WHERE ID_ATTACH = 76 LIMIT 1' at line 3


The way I did the upgrade was simply downloading the smf_2-0-15_upgrade.zip, unpacking it, and then uploading to the existing forum folder on the server.
I then ran upgrade.php. It appeared to be working ok, but then the above error came up.
Not sure if that is the correct method..


Any ideas please?

Thanks in advance
Ian Cook

iwcook

Never mind.

I deleted the offending record (id_attach = 76) from the smf_attachments table.
The upgrade is proceeding ok now!
:) :)


Advertisement: