[SOLVED] Delete Unused Language in DataBase

[PoOoOoZ]

Hello, i have deleted 3 language (3,4 & 5) in the database (table ps_lang), because i was unable to make it in the backend (nothing when i tried to delete language). The associate lines for differents lang are still in the database, how can i tell to prestashop to refresh and remove all these lines ? (in ps_attachment_lang a ps_product_lang for exemple where there are 5 lines for every item)

Can someone know this problem and can help me ?

Thank You very much.

[Mike Kranzler]

Hi PoOoOoZ,

Have you already tried to delete them in your Back Office under Tools > Languages? When you do that, it should delete all related translations in your database as well.

 

-Mike

[PoOoOoZ]

I was unable to delete them via Tools / Language, i have deleted them manually in ps_lang, and all other *_lang

Thank You.

[Mike Kranzler]

Great, I'm glad you were able to handle this, although I am confused why you were unable to do this through the Back Office. I'll go ahead and mark this solved as you, but did you receive any error message when you tried to delete them?

 

-Mike

[PoOoOoZ]

No message, only a "refresh" of the page after the confirmation of deleting language.

Video (after creating a new language & desactivate it) :

http://imageshack.us...eos/15/xce.mp4/

(same thing if i select the language via the checkbox then delete)

[Mike Kranzler]

Hi PoOoOoZ,

Thanks for that video, it is strange that you had this issue but I'm glad you were able to find a workaround in the end

 

-Mike

[mailebalmos37]

Hello , I am having the same issues, cannot delete a language in admin (Localization > Languages) I am using the latest 1.5.0.17 version. All files are CHMOD 777 and ownership is set correctly , still i cannot delete it. There is a message at top saying your htaccess must be writeable , i assume this is not connected to this, but this as well is set to CHMOD 777.

 

Any suggestions ?

[akulahpathub]

Same issue with clean install PrestaShop 1.5.2.0

Ownership is set correctly.

 

Should I open new thread ?

[taoufiqaitali]

anyone who still have this issue

easy way to delete unused languages from database

 

1- run this query to get lang tables

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.tables 
WHERE TABLE_SCHEMA='database_name' and TABLE_NAME LIKE '%_lang'; 

change database_name with your database name

2- copy tables name and do bulk edit via text editor like sublime text

each table name in a line

ada to the beginning of the line Delete from 

add to the end of line where id_lang=1

change 1 with the id of the lang you want to delete

so you will get something like this 

delete from ps_risk_lang where id_lang = 1;

delete from ps_stock_mvt_reason_lang where id_lang = 1;

delete from ps_supplier_lang where id_lang = 1;

delete from ps_supply_order_state_lang where id_lang = 1;

delete from ps_tab_lang where id_lang = 1;

delete from ps_tax_lang where id_lang = 1; 

3- copy past queries in phpmyadmin

 

that's it, it will delete all related unused translates from database