Jump to content

Help require to interpret error message


Recommended Posts

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. }
Link to comment
Share on other sites

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')
Link to comment
Share on other sites

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!

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...