Page 1 of 1
Upgrade to 1.11.9 fails with (sql) ERROR: unterminated ...
Posted: Wed Oct 02, 2013 7:39 am
by takku
I had an installation of version 1.9.4.3. When I tried to upgrade it to 1.11.9, everything went without problems untin phase 6 resulted in an SQL error:
Code: Select all
INSERT INTO cms_routes (term,key1,key2,key3,data,created) VALUES ('/[nN]ews\\/(?P[0-9]+)\\/(?P[0-9]+)\\/(?P.*?)\\/d,(?P.*?)$/','News',NULL,NULL,'O:8:"CmsRoute":2:{s:15:"\\CmsRoute\\_data";a:4:{s:4:"term";s:97:"/[nN]ews\\/(?P[0-9]+)\\/(?P[0-9]+)\\/(?P.*?)\\/d,(?P.*?)$/";s:8:"absolute";b:0;s:4:"key1";s:4:"News";s:4:"key2";N;}s:18:"\\CmsRoute\\_results";N;}',NOW()) -- ERROR: unterminated quoted string at or near "'O:8:"CmsRoute":2:{s:15:"\\" LINE 1: ...)\\/d,(?P.*?)$/','News',NULL,NULL,'O:8:"CmsR... ^
I tried to see the directory "upgrades" and only occurrence of the routes-table was at "upgrade.35.to.36.php". However, I failed to realize what I should fix and thus I have currently a non working site. Naturally I followed the upgrade process and do have the backups.
Any help would be highly appreciated.
Re: Upgrade to 1.11.9 fails with (sql) ERROR: unterminated .
Posted: Wed Oct 02, 2013 8:57 am
by takku
Also a few lines from postgres log, which might be useful.
Code: Select all
STATEMENT: INSERT INTO cms_routes (term,key1,key2,key3,data,created) VALUES ('/[nN]ews\\/(?P<articleid>[0-9]+)\\/(?P<returnid>[0-9]+)\\/(?P<junk>.*?)\\/d,(?P<detailtemplate>.*?)$/','News',NULL,NULL,'O:8:"CmsRoute":2:{s:15:"\\
WARNING: nonstandard use of \\ in a string literal at character 67
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 188
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR: unterminated quoted string at or near "'O:8:"CmsRoute":2:{s:15:"\\" at character 188
STATEMENT: INSERT INTO cms_routes (term,key1,key2,key3,data,created) VALUES ('/[nN]ews\\/(?P<articleid>[0-9]+)\\/(?P<returnid>[0-9]+)\\/(?P<junk>.*?)\\/d,(?P<detailtemplate>.*?)$/','News',NULL,NULL,'O:8:"CmsRoute":2:{s:15:"\\
Re: Upgrade to 1.11.9 fails with (sql) ERROR: unterminated .
Posted: Wed Oct 02, 2013 1:40 pm
by calguy1000
postgres is unsupported.
Re: Upgrade to 1.11.9 fails with (sql) ERROR: unterminated .
Posted: Wed Oct 02, 2013 2:39 pm
by takku
It sure was supported when I installed it but obviously not any more.
How can one switch to mysql without new clean install?
Re: Upgrade to 1.11.9 fails with (sql) ERROR: unterminated .
Posted: Wed Oct 02, 2013 3:57 pm
by calguy1000
A poll was done in December 2011, and support for postgres was dropped as of CMSMS 1.11.
If you want to convert from postgres to mysql you will need to convert your 1.9.4.3 install from postgres to mysql before you upgrade to 1.11.x
a: export the database in a mysql compatible sql file
b: create a new mysql database
c: massage the .sql file as needed (I have no clue what may be needed).
d: import the sql file into the new mysql database
e: modify your config.php appropriately
f: test. if there are problems
f1: drop the mysql database
f2: go to step b.
g: backup your new, working mysql database, and all files
h: proceed with upgrading in the standard way, as documented on
docs.cmsmadesimple.org
(WONT FIX) Upgrade to 1.11.9 fails with (postgres) ERROR
Posted: Wed Oct 02, 2013 4:33 pm
by takku
So practically there is no working mechanism to merge from postgres to mysql. Thanks for the reply.