Upgrade to gallery 2.3.1.30 and mysql-database conversion error ?

radahann

Joined: 2006-04-17
Posts: 17
Posted: Sat, 2009-01-31 12:49

Hi,

I tried to migrate my gallery 2.2.1 from my webspace to a local webserver.
During the upgrade process the mysql-database is converted to UTF-8.
But after date the values g_description and g_title are corrupted in that way
that the words are truncated at the German Umlaut (ö,ä,ü, ....).
Any idea how to solve this issue ?

Here is my System report

Quote:
Gallery URL = http://192.168.0.3/gallery/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.5 apache2handler
Webserver = Apache/2.2.8 (Linux/SUSE)
Database = mysqli 5.0.51a, lock.system=flock
Toolkits = Exif, Gd, LinkItemToolkit
Acceleration = none, none
Operating system = Linux WebserverP4 2.6.25.5-1.1-pae #1 SMP 2008-06-07 01:55:22 +0200 i686
Default theme = matrix
gettext = disabled
Locale = de_DE
Browser = Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0; InfoPath.2; .NET CLR 3.5.21022)
Rows in GalleryAccessMap table = 38
Rows in GalleryAccessSubscriberMap table = 6233
Rows in GalleryUser table = 2
Rows in GalleryItem table = 6233
Rows in GalleryAlbumItem table = 51
Rows in GalleryCacheMap table = 0