coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: proft on April 24, 2005, 06:03:41 AM

Title: cpg1.3.3 upgrade corrupts international characters in comments
Post by: proft on April 24, 2005, 06:03:41 AM
The upgrade procedure going from cpg 1.3.2 to 1.3.3 corrupted international characters which existed in photo comments.

For example, the following comments were posted using Czech iso-8859-2 character set and are now corrupt:

Old: Je to krásná
New: Je to krásná

The problem appears to be that the msg_body contents in the cpg132_comments database table have been altered improperly by the upgrade.

Unfortunately I didn't heed the advice to back up the database tables prior to upgrade, so I've now completely destroyed my gallery...very disappointing.
Title: Re: cpg1.3.3 upgrade corrupts international characters in comments
Post by: Tranz on April 24, 2005, 08:43:53 AM
It looks like this was double/cross posted. Please do not do that. I had to split your other post, move it, and edit it, and reply to it. As you can see, that results in extraneous work. I am removing the duplicate, which is more time and work.
Title: Re: cpg1.3.3 upgrade corrupts international characters in comments
Post by: Nibbler on April 24, 2005, 04:51:08 PM
The update doesn't touch that data.