* SQLSTATE[23000]: Integrity constraint violation: 1062 :

R

Rafael Dittrich

started a topic almost 4 years ago

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

Alexey Maisuradze

said almost 4 years ago

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.

Alexey Maisuradze

said almost 4 years ago

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.

Alexey Maisuradze

said almost 4 years ago

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.

How can we help you today?