Upgrade CPG database from mysql4 to mysql5 Upgrade CPG database from mysql4 to mysql5
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Upgrade CPG database from mysql4 to mysql5

Started by mainpower, December 31, 2006, 03:30:14 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

mainpower

Did anyone do an upgrade of their DB to MYSQL 5 ???

By default MYSQL is using utf8 and I did a import of the MYSQL4 export with phpmyadmin (latest version).
The database looks okay .. only now I have some strange characters like:

Pic015-Völkerschlachtdenkmal (Battle of the Nations Memorial).jpg (this is the output)
Pic015-Völkerschlachtdenkmal_(Battle_of_the_Nations_Memorial).jpg (this is in the database)

Therefor the picture is not displayed...

mainpower

Solved .. you have 'of course' change the "Character encoding" settings in the config ...  ::)