Problem When Upgrading from 1.6 to 1.7 "ps_currency_lang" doesn't exist in Db.php line 769

[Hawkz]

I got this error when upgrading using 1 click auto upgrade:

PrestashopInstallerException' not found LanguageList.php on line 100

[Hawkz]

[selectshop.at]

Which php-version and SQL-version are in use ?

Which currency is native and active ?

[selectshop.at]

The same error was already discussed here for earlier PS 1.7. versions.

Check, if this table "ps_currency_lang" is available on your database. If not, you can add it via phpmyadmin into your prestashop database manually with this query:

CREATE TABLE `ps_currency_lang` (
	`id_currency` INT(10) UNSIGNED NOT NULL,
	`id_lang` INT(10) UNSIGNED NOT NULL,
	`name` VARCHAR(255) NOT NULL,
	`symbol` VARCHAR(255) NOT NULL,
	PRIMARY KEY (`id_currency`, `id_lang`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

If you don't know how to do this, ask your provider, or some expert in phpmyadmin.

[Hawkz]

44 minutes ago, selectshop.at said:

The same error was already discussed here for earlier PS 1.7. versions.

Check, if this table "ps_currency_lang" is available on your database. If not, you can add it via phpmyadmin into your prestashop database manually with this query:

CREATE TABLE `ps_currency_lang` (
	`id_currency` INT(10) UNSIGNED NOT NULL,
	`id_lang` INT(10) UNSIGNED NOT NULL,
	`name` VARCHAR(255) NOT NULL,
	`symbol` VARCHAR(255) NOT NULL,
	PRIMARY KEY (`id_currency`, `id_lang`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

If you don't know how to do this, ask your provider, or some expert in phpmyadmin.

so this will actually fix the issue and the upgrade would finish??

[selectshop.at]

17 hours ago, Hawkz said:

so this will actually fix the issue and the upgrade would finish??

This will fix your problem ps_currency_lang doesn't exist problem. For other problems you may have, certainly they should be fixed as well. If an upgrade fails or not depends on several other factors:

18 hours ago, selectshop.at said:

Which php-version and SQL-version are in use ?

and if you are using own (non-native) theme and addons which you should deinstall before you upgrade.

[ChOmar]

On 1/15/2020 at 1:26 PM, selectshop.at said:

you can add it via phpmyadmin into your prestashop database manually with this query:

after i did it : Unknown locale code: en-US

Edited September 16, 2021 by ChOmar (see edit history)

[musicmaster]

On 9/16/2021 at 11:38 AM, ChOmar said:

after i did it : Unknown locale code: en-US

You should not only create the table but also add entries for every currency-language combination.