Update OMP and OJS database using tools/update.php

Dulip_Withanage · December 12, 2019, 9:26am

My update script retunrs error

ERROR: Upgrade failed: DB: Incorrect string value:

One reason for the error is that your database encoding is not properly configured.

Please check your database encoding and collation.

SELECT @@character_set_database, @@collation_database;

SELECT character_set_name FROM information_schema.columns WHERE table_schema='omp_master ' AND table_name='email_templates_default_data' AND column_name='subject';

SELECT default_character_set_name FROM information_schema.SCHEMATA  WHERE schema_name = "omp_master";

If the answer is not utf-8 , you can run a conversion of the database and the tables using the following script.

PLEASE BACKUP YOUR DATABASE BEFORE RUNNING THIS SCRIPT, CAUSE WE CANNOT TAKE ANY RESPONSIBILTY FOR DATA LOSS.

github.com

withanage/scripts/blob/master/mysql2utf8.php

<?php
/**SEE LICENSE


/**
 * Check if mysqli is installed and wait 10 seconds
 */
if (!extension_loaded('mysqli')) {
	exit("install mysqli");
} else {
	echo ('Hope you did a backup of the mysql database, if not you can stop the script  within 10 seconds');
	echo ('Nice documentation on utf8: https://mathiasbynens.be/notes/mysql-utf8mb4');
	sleep(10);
}


// define variables
$mysql_db = 'omp_master';
$mysql_user = 'user';
$mysql_password = 'password';

This file has been truncated. show original

primozs · December 12, 2019, 5:06pm

Hi @Dulip_Withanage,

Please add info from which version and to which version you tried to upgrade.

Regards, Primož

Dulip_Withanage · December 12, 2019, 5:34pm

Hi @primozs
This is a general solution if you encounter update problems due to non utf 8 databases and is not restricted to a particular version.