Start a new topic

* SQLSTATE[23000]: Integrity constraint violation: 1062

Hi Guys, a few days ago we started to have the error below, this happens when trying to place an order, save a page or any record in the database,


* SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8388607' for key 'PRIMARY', query was: INSERT INTO `searchanise_queue` (`data`, `action`, `store_id`) VALUES (?, ?, ?)


Can help us?


Sorry my english


Cheers from Brazil

Hello!


Thank you for contacting Searchanise.


We need to consult this issue with our developers. We will contact you as soon as we get any results.


Thank you.

Hello!


Thank you for your time and patience.


Please execute the following SQL query in your database:


TRUNCATE searchanise_queue


Then please click the Force re-indexation button on the Catalog > Searchanise page in admin panel of your store.


After that please check the issue again and let us know the result.


Thank you.

We apologize for incorrect instructions in our previous message. Below you can find correct ones.


Please execute the following SQL query in your database:


TRUNCATE TABLE searchanise_queue


Then please click the Force re-indexation button on the Catalog > Searchanise page in admin panel of your store.


After that please check the issue again and let us know the result.


Thank you.

Login or Signup to post a comment