Forum Language Messed Up After Upgrade

[Pericolosogr]

Hello,
yesterday i upgraded to 3.7.0 RC1 and after the upgrade i had a small surprise!

The one and only language in the forum was greek, i had it in utf8, the thing is that now everything appears as a qusetion mark!

I uploaded tools.php, tried to reset everything to default but nothin happens, when i try to upload the default language as a new one, i get a message "rebuilding language" and then i still have the same messed up and no new/extra language!

Same thing happens with styles...


When i did upgrade from 3.6.7 to 3.6.8 LP i made a mistake by uploading a language file of a product in my main language, they had diferrent encodings (mgc chatbox) so things were pretty much like this! Back then i had a support ticket and the guys in vb made things pretty much like it used to be, even though there were at some parts of the forum words of this style ---> "???????"

Did somebody have a similar problem?
My forums are down and i need some help since vbulletin cant do anything now that RC1 is unsupported(even though i dont get it...)

[Steve Machol]

What's the URL to your forums? Does the English language work?

[Pericolosogr]

https://www.clubmercedes.gr/forum

No there was only the greek language after i made the upgrade...i tried to upload the english but didnt work out...it keeps on saying "rebuilding language"

[Steve Machol]

Sorry but I don't know what happened to cause that or how to fix it. What charset do you have set for the English Language? Have you checked the forum, thread and post tables themselves to see if they are showing the correct characters or are all ?????

[Pericolosogr]

Yes, everything in the Forums is shown like this!

In the admin panel tha same...

In both languages charset is set to utf-8 from scratch and have been like that till now...

[Steve Machol]

If that info in the database is like that, then I'm afraid the database is ruined. Your only option is to restore a backup of the database from prior to this problem starting.

[Pericolosogr]

When i first had that problem some months ago, you run a query in my database and deleted everything (as far as you told me) that the products language had caused!

I am ok if somebody can figure out this for me...and i can try it!

There is a problem with my backups so i just have to find how to do it!

[Steve Machol]

I don't recall that. And of course I have handled thousands of threads and tickets since then. Do you have the thread?

[Pericolosogr]

I'll try to search within my emails...i recall that i did ask you which query you used and you told me...

[Pericolosogr]

Unfortunately i couldnt find it...

Because it is urgent...does anybody know where i can find a coder to take a look on problem!
Knowing some stuff abotu vbulletin and sql would be perfect!
Thank you

if you have something contact me via PM

[Pericolosogr]

If i convert to IPB will i still have the same problem?

[Jerz]

>_> Well you probably would have trouble importing a corrupted database...

[Steve Machol]

I have responded to your support ticket. This is a problem with your third-party language pack.

[Pericolosogr]

>_> Well you probably would have trouble importing a corrupted database...

Nope, right now i can type in greek and everything appears to be ok!

The thing is that after uploading and overwriting my english language with the one from mgc chatbox product, everything got this way...when i say everything i mean every greek letter in the forum became a "?"!

If i edit the message and retype it, it wil be ok!

I dont have a backup, so i need something like a command to run on my database and fix it!

I have responded to your support ticket. This is a problem with your third-party language pack.

Yes, i am waiting for your reply

As i said before there is no third party language right now on my forums, everything was set to default (tools.php) and right now i've just created a language named greek and i will translate it from A - Z!

But First of all i have to fix the appearance of the previous posts/forum titles/every greek symbol

[Pericolosogr]

here is a link