Sql query error on prestashop 1.5.6.2

[levviking]

Hello,

 

i have this error when i acces Localization > Countries:

 

• Bad SQL query
  Unknown column 'call_prefix' in 'field list'
•  

[moraira]

Mine Ps 1.5.6.2 goes well in Localization - Countries.

 

check you have call_prefix in table ps_country, it is int(10)

[levviking]

thank you,

i don't have the call_prefix in table ps_country.

It's missing.

[moraira]

you can check update sql directory in install directory of a new prestashop douwload. I have found the creation of call_prefix in update file 1.4.0.2.sql

 

maybe you have delete it for error, because it is an very old update.

 

 

this is the update line for the table

ALTER TABLE `PREFIX_country` ADD `call_prefix` int(10) NOT NULL default '0' AFTER `iso_code`;

[levviking]

Thank you @moraira , i don't understand.

This is a command in phpMyAdmin? 

[J.Sahu]

Yes this is the command you should run on your database.

[levviking]

Thank you. I will search on google, where to add this line.

[levviking]

Thank you very much.

I found the solution:

I run a query with your code, only change is PREFIX to my database prefix.