Hi everyone.
my gallery mostly English but some visitors reply and add comment in Arabic, but the words don't appear correctly. i have tried to use other character set than Unicode-UTF 8 but its worse!!
can anyone help please? as the comments are so important.
Comments
1. Your gallery characterset is UTF-8.
2. All your database tables and fields are UTF-8
3. You are on an up-to-date version of Zenphoto.
#2 may be an issue if you have migrated from one of the earlier versions of Zenphoto. In that case the database fields are left at whatever they were set to, most likely a version of Ansi. We do not convert them to UTF-8 because if there are actually Ansi accented characters or other multi-byte characters stored, they would get garbaged.
If you know that there are none of the above characters, just change the encoding of the database table. If there are such characters you will have to migrate the data.
my gallery is new and its version zenphoto version 1.2.3 [3483]
1. my gallery charactersset is UTF-8
2. i donno about the database table! it has been automaticly created when i setup the gallery
3. i think the version im using is quite new
i dont think i migrated anything because i installed this version and never updated since then..
here is some info about the database:
Server version: 5.0.67.d7-ourdelta-log
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation:utf8_unicode_ci
and here Installation information
* Zenphoto version 1.2.3 [3483] (Official Build)
* Current gallery theme: default
* PHP version: 4.3.11
* PHP memory limit: (Note: Your server might allocate less!)
* MySQL version: 5.0.18
* Database name: ---------
* Table prefix: zp_
* Spam filter: none
* Captcha generator: zenphoto
Active plugins:
* class-video
* filter-zenphoto_seo
* flowplayer
* image_album_statistics
* rating
Active filters:
* seoFriendlyURL
o 10: filter-zenphoto_seo.php => filterAccentedCharacters
how could i check the setup warnings?
Do you mean you can write Arabic on some client PCs and not others or on some Server PCs and not others. If it is the Server PC, setup may show you the warnings. If it is the client PCs, it would be a configuration of the browser.
on some the arabic is good
on some others is not even i change the configuration. i've tried all of them but no chance
i have another up problem. over the sudden, RSS is not working! please check the RSS link
http://www.khaled-alsibai.com/gallery/rss.php?lang=en_US
on IE it gives me an error "This feed contains code errors."
but anyway its ok now..
i dont upload the zip file because i donno how to unpack it on the server
’s “
I tried to fix this problem using the following query in SQL:
UPDATE zp_albums SET desc = REPLACE(desc, '“', '“');
UPDATE zp_albums SET desc = REPLACE(desc, 'â€', '”');
UPDATE zp_albums SET desc = REPLACE(desc, '’', '’');
UPDATE zp_albums SET desc = REPLACE(desc, '‘', '‘');
UPDATE zp_albums SET desc = REPLACE(desc, '—', '–');
UPDATE zp_albums SET desc = REPLACE(desc, '–', '—');
UPDATE zp_albums SET desc = REPLACE(desc, '•', '-');
UPDATE zp_albums SET desc = REPLACE(desc, '…', '…');
However I am getting this error:
SQL query:
UPDATE zp_albums SET DESC = REPLACE( DESC , '“', '“' ) ;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc = REPLACE(desc, '“', '“')' at line 1
"DESC" is a reserved keyword in MySQL so you need to place it in back ticks on the SET call.