Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Upgrade CPG database from mysql4 to mysql5  (Read 2176 times)

0 Members and 1 Guest are viewing this topic.

mainpower

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 30
    • Photo album of ... (with CPG)
Upgrade CPG database from mysql4 to mysql5
« on: December 31, 2006, 03:30:14 pm »

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...
« Last Edit: December 31, 2006, 04:35:35 pm by Nibbler »
Logged

mainpower

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 30
    • Photo album of ... (with CPG)
Re: Upgrade CPG database from mysql4 to mysql5
« Reply #1 on: December 31, 2006, 04:00:15 pm »

Solved .. you have 'of course' change the "Character encoding" settings in the config ...  ::)
Logged
Pages: [1]   Go Up
 

Page created in 0.013 seconds with 19 queries.