[solved] Authentication - Unknown column 'id_lang' in 'field list'

[cmaloux]

I have version 1.5.4.1

 

Whenever I try to create a new customer the debug mode shows this:

 

========

 

 

[PrestaShopDatabaseException]

 

Unknown column 'id_lang' in 'field list'

 

INSERT INTO `ps_customer` (`secure_key`, `lastname`, `firstname`, `email`, `passwd`, `last_passwd_gen`, `id_gender`, `birthday`, `newsletter`, `newsletter_date_add`, `ip_registration_newsletter`, `optin`, `website`, `company`, `siret`, `ape`, `outstanding_allow_amount`, `show_public_prices`, `id_risk`, `max_payment_days`, `active`, `deleted`, `note`, `is_guest`, `id_shop`, `id_shop_group`, `id_default_group`, `id_lang`, `date_add`, `date_upd`) VALUES ('38777867199b6bac9102686dea9769e9', 'XXXX', 'XXXX', '[email protected]', '0a520d50a75bc07ca9c490ef8fba05d1', '2013-05-15 16:26:09', '1', '0000-00-00', '1', '2013-05-15 22:26:09', '90.183.7.182', '0', NULL, NULL, NULL, NULL, '0', '0', '0', '0', '1', '0', NULL, '0', '1', '1', '3', '1', '2013-05-15 22:26:09', '2013-05-15 22:26:09')

 

at line 607 in file classes/db/Db.php

 

 

601. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

602. }

603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

604. {

605. if ($sql)

[color=#F20000][b]606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');[/b][/color]

607. throw new PrestaShopDatabaseException($this->getMsgError());

608. }

609. }

610.

611. /**[/font][/color]

• ========
  

 

So id_lang doesn't exist in the DB... ? And now what ?

Edited May 16, 2013 by vekia (see edit history)

[vekia]

Have you got an ability to use database manager like PHPMyAdmin ?

if so, use it.

open ps_customer table and check table fields for "id_lang"

 

if it doesn't exist - try to create new field:

 

id_lang

specification: INT unsigned NULL

[cmaloux]

Have you got an ability to use database manager like PHPMyAdmin ?

if so, use it.

open ps_customer table and check table fields for "id_lang"

 

if it doesn't exist - try to create new field:

 

id_lang

specification: INT unsigned NULL

 

I was reluctant to do this but it worked. Thanks!

 

I guess I did an upgrade from 1.4 to 1.5 and forgot to update the DB somehow somewhere.... Anybody know how I could do a full validation of my DB schema?

[vekia]

hello

 

thanks for the information. I marked this thread as solved. I suggest you to create new thread with your new question, I think it will help you get the answer very quickly