Post by Zviadi » Fri Sep 26, 2008 9:52 pm

i need to give the product  a name  in georgian language, but when i try to do this from admin panel,   it displays this ? ? ? ? ?   in home page. can anyone help ?
Last edited by Zviadi on Sat Sep 27, 2008 2:44 am, edited 1 time in total.

New member

Posts

Joined
Sun Sep 14, 2008 7:11 pm

Post by bruce » Sat Sep 27, 2008 10:20 am

It will be cyrillic text so your database needs to be UTF-8.

Start by checking the database values with phpmyadmin to ensure that the data in the database is good. If not, paste the values directly into the database and see if it displays correctly on the catalog pages.

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by Zviadi » Sat Sep 27, 2008 3:09 pm

I inserted the  product names from phpMyadmin and it worked, Thanks.

New member

Posts

Joined
Sun Sep 14, 2008 7:11 pm

Post by Zviadi » Sat Sep 27, 2008 4:15 pm

sorry, the error i wrote there,

Notice: unserialize() [function.unserialize]: Error at offset 1166 of 4952 bytes in /usr/home/schirnho/public_html/upload/library/cart/order.php on line 56

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/schirnho/public_html/upload/library/cart/order.php:56) in /usr/home/schirnho/public_html/upload/library/environment/response.php on line 23

was actually caused by translating  the product name, what can i do now?
Last edited by Zviadi on Sat Sep 27, 2008 4:21 pm, edited 1 time in total.

New member

Posts

Joined
Sun Sep 14, 2008 7:11 pm

Post by bruce » Sat Sep 27, 2008 5:10 pm

What other changes were made before the error occurred?

For example, did you delete a language?

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by Zviadi » Sat Sep 27, 2008 5:24 pm

nothing more absolutely, just typed the name in my language in:  product description->product name

by the way, this error is not the first time, first it appeared when i tried to translate in catalog/language/english/extension/calculate/total.php



total value with translated word


it had to change the encoding from ascci to utf8 and i believe that was the main reason

so any ideas ?

New member

Posts

Joined
Sun Sep 14, 2008 7:11 pm

Post by bruce » Sun Sep 28, 2008 4:39 pm

You definitely must ensure that the text files you create for translations are saved as utf-8.

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by Zviadi » Tue Sep 30, 2008 6:43 pm

thanks, i solved it, the problem was that, i had mysql charset UTF-8 Unicode (utf8)  and Mysql connection collation  utf8-general-ci,  i changed collation to utf8-unicode-ci and it worked, the products names changed and it did not cause any errors during checkout procedures.

New member

Posts

Joined
Sun Sep 14, 2008 7:11 pm
Who is online

Users browsing this forum: No registered users and 1 guest