Afterwards: conversion database to UTF-8

Questions & Problems about Installing or Upgrading with Version 3 phpList.
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Afterwards: conversion database to UTF-8

Postby jmeyer123 » 1:06pm, Fri 04 Apr, 2014

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
jmeyer123
phpList newbie
 
Posts: 2
Joined: 1:01pm, Fri 04 Apr, 2014

Re: Afterwards: conversion database to UTF-8

Postby jmeyer123 » 1:20pm, Fri 11 Apr, 2014

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
jmeyer123
phpList newbie
 
Posts: 2
Joined: 1:01pm, Fri 04 Apr, 2014

Re: Afterwards: conversion database to UTF-8

Postby danwaterloo » 1:42am, Sat 12 Apr, 2014

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
danwaterloo
PL Master
 
Posts: 276
Joined: 3:51am, Wed 30 Oct, 2013
Location: http://www.phplistsupport.com


Return to Installing and Upgrading

Who is online

Users browsing this forum: No registered users and 0 guests

cron