How can we help you today?
* SQLSTATE[23000]: Integrity constraint violation: 1062
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.
Rafael Dittrich
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