Help require to interpret error message

[tobyisabelle]

Hi! When i try to place an order on my website (www.shoprepublicmarket.com), I am not able to go beyond to go pass the personal information section. When  click on continue to go to the part where i fill up my address, nothing happens.
 
I've turned on Debug mode and the error message is "Out of range value for column 'id_customer' at row 1"

 

Below is the full error message. I don't know how to interpret what it means. Can someone help please? Thanks In advance! : )

 

[PrestaShopDatabaseException]

Out of range value for column 'id_customer' at row 1
 

INSERT INTO `ps8l_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`, `reset_password_token`, `reset_password_validity`) VALUES ('8ddfadc6699c19c6e83127b35ac52d5e', 'Jenner', 'Cheryl', '[email protected]', '$2y$10$M0So81q8j5u699hiiSTViuHHaxOKRyLwcvhrKWppByCu0v0s3ag6u', '2017-07-10 18:49:45', '0', '0000-00-00', '0', '0000-00-00', '', '0', '', '', '', '', '0', '0', '0', '0', '1', '0', '', '1', '1', '1', '2', '1', '2017-07-11 00:49:45', '2017-07-11 00:49:45', '', '0000-00-00')
at line 744 in file classes/db/Db.php

 

739. if ($webservice_call && $errno) {
740. $dbg = debug_backtrace();
741. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
742. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
743. if ($sql) {
744. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
745. }
746.
747. throw new PrestaShopDatabaseException($this->getMsgError());
748. }
749. }

• DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 716 - classes/db/Db.php] - [1 Arguments]
• DbCore->q - [line 467 - classes/db/Db.php] - [2 Arguments]
• DbCore->insert - [line 518 - classes/ObjectModel.php] - [3 Arguments]
• ObjectModelCore->add - [line 261 - classes/Customer.php] - [2 Arguments]
• CustomerCore->add - [line 476 - classes/ObjectModel.php] - [2 Arguments]
• ObjectModelCore->save - [line 189 - classes/form/CustomerPersister.php]
• CustomerPersisterCore->create - [line 61 - classes/form/CustomerPersister.php] - [2 Arguments]
• CustomerPersisterCore->save - [line 191 - classes/form/CustomerForm.php] - [3 Arguments]
• CustomerFormCore->submit - [line 65 - classes/checkout/CheckoutPersonalInformationStep.php]
• CheckoutPersonalInformationStepCore->handleRequest - [line 57 - classes/checkout/CheckoutProcess.php] - [1 Arguments]
• CheckoutProcessCore->handleRequest - [line 202 - controllers/front/OrderController.php] - [1 Arguments]
• OrderControllerCore->initContent - [line 205 - classes/controller/Controller.php]
• ControllerCore->run - [line 369 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

[Scully]

PrestaShop version could be helpful.

The last part of the SQL contains fields I have never heard from.

If i take this out from the SQL, it works on my database.

 

`reset_password_token`, `reset_password_validity`

 

Of course not only the field names but also the corresponding values.

INSERT INTO `pre_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 ('8ddfadc6699c19c6e83127b35ac52d5e', 'Jenner', 'Cheryl', '[email protected]', '$2y$10$M0So81q8j5u699hiiSTViuHHaxOKRyLwcvhrKWppByCu0v0s3ag6u', '2017-07-10 18:49:45', '0', '0000-00-00', '0', '0000-00-00', '', '0', '', '', '', '', '0', '0', '0', '0', '1', '0', '', '1', '1', '1', '2', '1', '2017-07-11 00:49:45', '2017-07-11 00:49:45')

[tobyisabelle]

Hi! Thanks for taking a look!

 

I'm using 1.7.1.1

[Scully]

Ok, I'm running 1.6. That might explain additional values.

Have you logged into your database and checked the autoincrement attribute is set for the customer table on field id_attribute?

[tobyisabelle]

HI! Your reply made me realise that it was a module that was causing the trouble! Thank you!

 

I used a Litextension module to migrate my shopify data over to prestashop and there was a conflict because of the difference between shopify and prestashop's customer ID format.

 

The solution was:

To reset the auto-increment ID of table customer, use the query: 
ALTER TABLE tablename AUTO_INCREMENT = value; 
example: ALTER TABLE ps_customer AUTO_INCREMENT = 1; 

 

Thank you once again Scully!