Conversion and accents

[coglate]

Gallery Version: 1.0.5
phpBB Version: 3.0.8
Gallery-Link: http://www.familia.paula.nom.br/forum

PHP Version: 5.2.9
Database Version: 5.0.91-community


Error message:

Code: Select all

SQL ERROR [ mysqli ]

Incorrect string value: '\xF5es do...' for column 'image_name' at row 1 [1366]

SQL

INSERT INTO phpbb_gallery_images (image_id, image_filename, image_thumbnail, image_name, image_name_clean, image_desc, image_desc_uid, image_desc_bitfield, image_user_id, image_username, image_username_clean, image_user_colour, image_user_ip, image_time, image_album_id, image_view_count, image_status, image_reported, image_exif_data) VALUES ('7', '5a083dc67ac976da289b73cc7fdc9e33.jpg', '5a083dc67ac976da289b73cc7fdc9e33.jpg', 'Anfitri�es do I Encontro', 'anfitri�es do i encontro', 'Anfitri�es: Jo�ozinho e Lina.', '', '', '14', 'Luiz Paulo', 'luiz paulo', '', '201.14.98.80', '1114714095', '2', '77', '1', 0, '')

Error description and message
I'm trying to convert from a Album-mod gallery and I'm getting the following error in entries with accents.

What can I do about it?

[nickvergessen]

Seems like your database screwed up the utf8 characters.
Can you try to remove the characters causing this and than retry the conversion?

[coglate]

Seems like your database screwed up the utf8 characters.
Can you try to remove the characters causing this and than retry the conversion?

Yeah it works if I remove the characters, but there's a lot of entries

Isn't there another to fix it?

[nickvergessen]

You should have selected the uft8 option while uploading the database

[coglate]

You should have selected the uft8 option while uploading the database

When should I do that? When installing the gallery I didn't see any option to change de encoding...

[nickvergessen]

You're converting from smartors album mod?
if so, please try
install/install_convert.php
find:

Code: Select all

                  'image_name'         => $row['pic_title'],
                  'image_name_clean'      => utf8_clean_string($row['pic_title']),

replace with:

Code: Select all

                  'image_name'         => utf8_normalize_nfc($row['pic_title']),
                  'image_name_clean'      => utf8_clean_string(utf8_normalize_nfc($row['pic_title'])),

[coglate]

Oh thank you but I got it fixed by downloading all the old database in sql format and then uploading it again setting the enconding as utf8. Go figure, after that the conversion worked!


Thank you very much!