Cannot upgrade from 5.3.1.1 to 5.x.x.x
PermalinkI'm doing my head in here trying to upgrade from 5.3.1.1 to anything higher (at present 5.3.2.0) but I keep getting the error below:
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 'UNSIGNED' at line 1] in EXECUTE("ALTER TABLE btCollections MODIFY COLUMN categoryFilter VARCHAR(225) UNSIGNED")
I have searched through every file to try and track down the code responsible for this error but I cannot find it, nor am I able to fine anyone who has had/solved this issue, every answer for similar issues result in zero success...
I've tried this upgrade on 3 different servers now and I'm having no luck getting this to work, I have full control over the development environment so if a setting needs changing thats no problem... Please help, I used this CMS for one project thinking the upgrade process would be easy (I use eZPublish and I can upgrade that, that's probably the hardest CMS to upgrade) but this just seems to be impossible...
If I could figure out where this error is being generated from I'd have no problem, but the lack of any proper debug information makes that task practically impossible.
Maybe one of the core developers would know where to look?
Cheers
Nathan.
If I cannot get past this error I will have to move the site to a new CMS, I'm not going to trust c5 ever again if this issue can't be resolved!
Cheers
this article might help you out:
http://www.concrete5.org/documentation/how-tos/developers/update-ve...