Page 1 of 1

Afterwards: conversion database to UTF-8

PostPosted: 1:06pm, Fri 04 Apr, 2014
by jmeyer123
Hello!

During upgrade from phplist 2.x to 3.0.5 some errors occured. So some of the database tables are still in LATIN and not in UTF-8.
Admin-panel shows: "Your database version: 3.0.5" so there is no upgrade possible.

Is there any chance to restart the database-migration afterwards manually?

Best regards, Jens

Re: Afterwards: conversion database to UTF-8

PostPosted: 1:20pm, Fri 11 Apr, 2014
by jmeyer123
I tried update/migration again with an old backup of the database.
Unfortunately there were warnings regarding disk space and some errors during process again. Is there any chance to perform the migration to UTF-8 manually?

Error-messages/Logoutput is:
-->
Converting DB to use UTF-8, please wait
Database error 1064 while doing query 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 '-infosql3' at line 1
Upgrading table phplist_admin
Upgrading table phplist_admin_attribute
[...]
Upgrading column status
Upgrading column item
Database error 1109 while doing query Unknown table 'phplist_config' in information_schema
Database error 1109 while doing query Unknown table 'phplist_config' in information_schema
Database error 1109 while doing query Unknown table 'phplist_config' in information_schema

All Done
<--
Best regards, Jens

Re: Afterwards: conversion database to UTF-8

PostPosted: 1:42am, Sat 12 Apr, 2014
by danwaterloo
Hi Jens... you need to mark the database as 'unconverted' and then run the conversion again...

if you can get to the database, use this to mark it as unconverted:

"delete from phplist_config where item = 'UTF8converted'"

you can re-run converttoutf8 from the command line:
php ./index.php -c [config] -pconverttoutf8 -f