Upgrade to 1.11.9 fails with (sql) ERROR: unterminated ...

[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.

[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:"\\

[calguy1000]

postgres is unsupported.

[takku]

It sure was supported when I installed it but obviously not any more.
How can one switch to mysql without new clean install?

[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

[takku]

So practically there is no working mechanism to merge from postgres to mysql. Thanks for the reply.