Joomla Templates Club 406,261 posts

[ibrahimbdawy Friend ibrahimbdawyJoin date: November 2008Posts: 55Downloads:0Uploads:1 Thanks: 58 Thanked: 18 times in 2 posts]

#333723

<em>@klmklm 166303 wrote:</em><blockquote>Hi,

I have installed the Arabic language pack on the template but still have ?????? as the Arabic text. I did not follow on the previous post (ibrahimbdawy)what needed to be don. Is there a way for someone to explain what to do.

Many thanks in advance. :-*</blockquote>

Hi,klmklm

It’s not related to Arabic Language Pack
This error occurs as a result the database tables for quick start is not Encoding supporting the Arabic language
open the database tables in Phpmyadmin (c-panel)
Then follow the steps photos

I explained to you in Arabic if you want:)

[klmklm Friend klmklmJoin date: March 2008Posts: 155Downloads:0Uploads:12 Thanks: 11]

#333724

Hi,

I have done that but still no joy, by all means if you can send the explanation in Arabic would be great but the benefit of all you can leave it in English.

It is not working as I have followed your instructions what I’ve done looking at the previous post is went to Collation then Operations then changed it from latin1_swedish_ci to utf8_general_ci but this did not resolve the issue

Many thanks in advance. :-*

[ibrahimbdawy Friend ibrahimbdawyJoin date: November 2008Posts: 55Downloads:0Uploads:1 Thanks: 58 Thanked: 18 times in 2 posts]

#333725

<em>@klmklm 166307 wrote:</em><blockquote>Hi,

I have done that but still no joy, by all means if you can send the explanation in Arabic would be great but the benefit of all you can leave it in English.

It is not working as I have followed your instructions what I’ve done looking at the previous post is went to Collation then Operations then changed it from latin1_swedish_ci to utf8_general_ci but this did not resolve the issue

Many thanks in advance. :-*</blockquote>

I am now abroad, I will explain you the photo will solve the problem
I understand your problem completely;)
Please, wait during the 3 hours at the most.

thanks

[klmklm Friend klmklmJoin date: March 2008Posts: 155Downloads:0Uploads:12 Thanks: 11]

#333726

You are worth the wait.

I look forward to hearing from you soon. :-*

[metamar Friend metamarJoin date: January 2009Posts: 117Downloads:0Uploads:0 Thanks: 33 Thanked: 9 times in 1 posts]

#333730

What is the template name you are using? KLMKLM
Joomlart tried helping me at first but ultimatly told me this was a joomla problem.
If you get this resolved, post it! 🙂

I look forward to hear from you soon too!

[ibrahimbdawy Friend ibrahimbdawyJoin date: November 2008Posts: 55Downloads:0Uploads:1 Thanks: 58 Thanked: 18 times in 2 posts]

#333731

<em>@klmklm 166310 wrote:</em><blockquote>You are worth the wait.

I look forward to hearing from you soon. :-*</blockquote>

hi klmklm

The first step

The second step

The third step

Thus, in the other tables
Is a long way
However, fully guaranteed

I hope it helped

4 users say Thank You to ibrahimbdawy for this useful post

1. metamar
2. klmklm
3. JA Developer
4. brovazzz

[metamar Friend metamarJoin date: January 2009Posts: 117Downloads:0Uploads:0 Thanks: 33 Thanked: 9 times in 1 posts]

#333732

I have tried that using SqlMaestro which converted all my tables but still didn’t fix…I will try this way!

[metamar Friend metamarJoin date: January 2009Posts: 117Downloads:0Uploads:0 Thanks: 33 Thanked: 9 times in 1 posts]

#333733

yes this fixed it for me
Joomlart should award you many points!
And joomlart should have all their templates fixed to have their sample data all in unicode.
Thank you dearly IbrahimDawy

Alhamdullilah

1 user says Thank You to metamar for this useful post

1. ibrahimbdawy

[ibrahimbdawy Friend ibrahimbdawyJoin date: November 2008Posts: 55Downloads:0Uploads:1 Thanks: 58 Thanked: 18 times in 2 posts]

#333734

<em>@metamar 166322 wrote:</em><blockquote>yes this fixed it for me
Joomlart should award you many points!
And joomlart should have all their templates fixed to have their sample data all in unicode.
Thank you dearly IbrahimDawy

Alhamdullilah</blockquote>

I am happy to resolve your problem 😀 😀

1 user says Thank You to ibrahimbdawy for this useful post

1. metamar

[klmklm Friend klmklmJoin date: March 2008Posts: 155Downloads:0Uploads:12 Thanks: 11]

#333744

it is a template issue and a Joomla issue as I have run other templates which has Arabic support on and no issues. I am jusing the JA_lime

Hope to get this sorted soon :-*

[metamar Friend metamarJoin date: January 2009Posts: 117Downloads:0Uploads:0 Thanks: 33 Thanked: 9 times in 1 posts]

#333745

The problem is that when they created the template they should have used Unicode for their database tables. Because they used Latin collation it gives us the burden of changing the tables one by one. I do hope Joomlart decide to announce that they will fix this issue and update their templates. seems a simple job to do now. If they fix it once then we won’t all have to fix it individually.

[klmklm Friend klmklmJoin date: March 2008Posts: 155Downloads:0Uploads:12 Thanks: 11]

#333747

Hi ibrahimbdawy

hope you had a good trip….

I will try this later on tonight and see what happened…

Many thanks for what you’ve done, you are fantastic. :-*

[klmklm Friend klmklmJoin date: March 2008Posts: 155Downloads:0Uploads:12 Thanks: 11]

#333770

You are a star ibrahimbdawy

I’ve seen other tables with the wrong collation, do I need to change them as well. It is working now, and I can see the Arabic text but seen the other tables and wondering if I should.

Many Thanks in advance and Salam to you ibrahimbdawy….

[creative_cow Friend creative_cowJoin date: March 2007Posts: 45Downloads:2Uploads:10 Thanks: 4 Thanked: 2 times in 1 posts]

#334455

ibrahimbdawy you are great!! Yet i had to do also “ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;” for every table of the db. Now everything works (i use greek language)
Thank you a lot.

1 user says Thank You to creative_cow for this useful post

1. ibrahimbdawy

[ibrahimbdawy Friend ibrahimbdawyJoin date: November 2008Posts: 55Downloads:0Uploads:1 Thanks: 58 Thanked: 18 times in 2 posts]

#334495

<em>@creative_cow 167220 wrote:</em><blockquote>ibrahimbdawy you are great!! Yet i had to do also “ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;” for every table of the db. Now everything works (i use greek language)
Thank you a lot.</blockquote>

you are welcome

[Author]

Posts