Cannot upgrade from 5.3.1.1 to 5.x.x.x
Permalink
Hi All,
I'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...
I'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...
Thanks for the link PFC, I have actually already read this article and this is the procedure I am trying to get working. Unfortunately this article doesn't explain what to do in the case of MySQL syntax errors in the upgrade scripts...
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 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.
Can anyone please help point out where to look for this error?
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
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...