Admin section different charset - Page 3

Chuck S · June 1st, 2007, 02:49 PM

So your saying vbulletin stores it just like it is printed on the page that makes no sense though

Username: Testčšžđć
User title: Začetnik

Because quite frankly if it was stored as it is displayed then classifieds should display it fine since all we are doing is showing what is in the database

I will search if there is anything to help you but a normal mysql classifieds install works as I have shown. I do not know much about mysqli to help alot here

tomzl · June 1st, 2007, 03:18 PM

That is what I have been saying all along. My vBulletin tables store the data exactly like I enter it (Testčšžđć). Classifieds store these same characters differently.

Classifieds Admin panel shows the categories with special characters exactly how they are stored in the Classifieds tables but on the main page they show them correctly.

Example
Classifieds table: TestÄ?????Ä‘Ä‡
Admin panel: TestÄ?????Ä‘Ä‡
Main Classifieds page: Testčšžđć

What I find strange is that Classifieds store the data the same in MySQL and MySQLi. The problem is that when Classifieds read the data from the vBulletin MySQLi tables, it somehow gets distorted into Test?????.

Example
vBulletin table: Testčšžđć
Classifieds main page: Test?????

When user Testčšžđć posts an ad his username is stored into the Classifieds "products" table as "test?žš??" So basically letters ž and š are carried correctly over from vBulletin but other letters turn into question marks. However on the main Classifieds page even letters ž and š are displayed as question marks and Test????? is displayed as user.

tomzl · June 3rd, 2007, 08:28 AM

Can you please reply what file I need to edit so that categories are displayed correctly in the admin panel? I have changed all instances of charset to be utf-8 in the Classiffieds files beforehand so there is nothing more to change.

On the main page the category is displayed as: ČŠŽĐĆ
In admin panel when I click edit categories: Ä?Å Å½Ä?Ä?
Stored in the database as: Ä?Å Å½Ä?Ä?
Edit subcats view in admin panel: ČŠŽĐĆ

Admin panel has utf-8 meta tags in its code on all the admin pages so I don't know where else to change it.

When I click Sort subcats in Edit categories, the categories are shown correctly like on the main page. Is this a bug since on one admin page Classifieds show the categories incorrectly and on another admin page they show them correctly? Both pages have utf-8 meta tags. In fact, when I go to edit the category, it manages to show the category name correctly and incorrectly on the same page (screenshot enclosed).

I have included screenshots for easier understanding.

Chuck S · June 3rd, 2007, 10:13 AM

Line 4142 of adm-misc.php change from this

Code:

Content visible to verified customers only.

to this

Code:

Content visible to verified customers only.

tomzl · June 3rd, 2007, 10:46 AM

Did it and the problem remains on the Edit Categories page (first attachment in my previous post). It did fix the second attachment though...

Chuck S · June 3rd, 2007, 04:09 PM

I am not sure where your talking about exactly here whether its main screen edit screen etc but you can try redownloading the build and reuploading adm-inc.php adm-misc.php where I have made the corrections I noted myself

tomzl · June 3rd, 2007, 04:46 PM

I redownloaded the latest build like you suggested in the other thread and made a clean install. I only changed all the charset instances to utf-8.

The problem is now a little different (look at the 3 attachments below).

On the main page both news and categories are displayed correctly.

Code:

Content visible to verified customers only.

In admin panel under Edit Categories the text is shown incorrectly but different than before you made the changes to the build.

Code:

Content visible to verified customers only.

Also, news settings have a problem. The news title is shown correctly but the News text is shown incorrectly. You may also notice that the text in the box for the news is indented to the right. This is present in all builds and I guess is another bug.

Code:

Content visible to verified customers only.

Chuck S · June 3rd, 2007, 05:19 PM

Okay one more try now

tomzl · June 3rd, 2007, 05:29 PM

While you're making corrections. When you choose all options in the admin panel, there is some text missing (the explanation) for GMT Offset and WorldPay Installation ID. Explanations end in the middle of the sentence.

tomzl · June 3rd, 2007, 06:07 PM

Can you tell me which files have been changed so I don't have to reinstall the whole thing again?

Chuck S · June 3rd, 2007, 06:33 PM

same ones in post 46

tomzl · June 3rd, 2007, 06:39 PM

OK, now the announcement text is correct (although still indented?).

In Edit Categories the names of the categories are still not shown correctly.

Chuck S · June 3rd, 2007, 06:42 PM

Okay try once again

tomzl · June 3rd, 2007, 06:47 PM

Downloaded the 5:42 PM build and uploaded both files and no change.

Chuck S · June 3rd, 2007, 08:08 PM

should definately be a change the only difference in that file is the one line we noted in this discussion earlier where you said it fixed it

tomzl · June 4th, 2007, 05:00 AM

The characters are still shown like this in Edit Categories.

Code:

Content visible to verified customers only.

I uploaded both files again to be sure but it didn't fix it.

Chuck S · June 4th, 2007, 10:06 AM

Try searching in the adm-misc.php file and remove the UTF line that we added earlier in this discussion and see how it displays.

I have no idea why you say it works earlier in this thread but not now.

tomzl · June 4th, 2007, 12:35 PM

Quote:

Originally Posted by Chuck S

Try searching in the adm-misc.php file and remove the UTF line that we added earlier in this discussion and see how it displays.

I have no idea why you say it works earlier in this thread but not now.

No, you misunderstood. The problem was present in several places and the fixes you made took care of most locations except the text in admin panel when you click Edit Categories.

In Edit categories the categories first looked like this http://www.photopost.com/forum/attac...6&d=1180873597 and when you told me to redownload the build, it changed to http://www.photopost.com/forum/attac...1&d=1180903511 and then after a few more fixes it went back to http://www.photopost.com/forum/attac...6&d=1180873597.

It was never fixed, it was just wrong in a different way for some time.

tomzl · June 4th, 2007, 12:40 PM

I also reversed the change mentioned in post #44 of this thread and it didn't fix the remaining problem but just made the problem reappear on the Edit page of the Edit Categories page..

Chuck S · June 4th, 2007, 01:25 PM

Have you uploaded the new files I noted adm-inc.php and adm-misc.php