Help! How do I change language in database?

Yesterday I logged into my admin and added Swedish as language, and enabled that and disabled English and after that I could not go to my page or log in to admin anymore. I downloaded Swedish language files and uploaded into my server and I can access my page but I still cannot enter the adminpage.

I can get help but they need to know exactly where they should go in my database to change so that the English language is enabled again, I hope this will help so I can access admin again.

So can someone tell me exactly how I change the language in my database?

Thank you!

Open up the setting table and in there you should see a record where the "key" = "config_language" and where "group"="config"

So open that, and then change the "value" to "en"

Cheers

Jem

Thank you, I checked that and it seems to be "en" already. But What can be wrong then? All I changed yesterday was what I have written above, and then admin was unable to access. What can else can I try to change to fix this?

Thank you!

I get this message when I try to go to admin page:
Notice: Error: Could not load language swedish! in /hsphere/local/home/josignart/josign.se/vqmod/vqcache/vq2-system_library_language.php on line 41
So I guess that means that Swedish should be enabled but in the database it says that the only language is English.

What i recomend is that you disable all vqmods and try again... (even if you don't think it will work just try it)... I have found that a similar error has been created by a vqmod before... so what you should do is rename the "xml" folder to "xml-orig" and create a new folder called "xml" and copy the file "vqmod_opencart.xml" into the "xml" folder and then try log into admin

Let me know how you get on.

Cheers

jem

I have the same problem with Danish, I used the method as Josign descriped, it helps , and save a lot of work so thanks.

LarsV wrote:I have the same problem with Danish, I used the method as Josign descriped, it helps , and save a lot of work so thanks.

Which method?... lol, was that the method that I recomended... lol...

Nope not yours recommendation this time )

Can you please let me know what "Josign's" recomendation was, it appears to me that he is only asking questions on here... just out of interest.

Sorry my man, it's your answer I used , and it works

Lol, Thats algood... haha... just checking i wasn't going insane... lol

I have similar problem and I tried to change the language to EN, but it didn't helped. I can login to admin panel, but can't see the menu. I also get error message:
"Warning: sprintf(): Too few arguments in /var/www/vhosts/mydomain.com/admin/controller/common/header.php on line 111"

Any suggestions what could I do to fix this?