G
G
Greg Plitt2017-02-08 15:45:19
MySQL
Greg Plitt, 2017-02-08 15:45:19

There were errors in the database when exchanging from 1s to the site, from where? What to do?

Log:

bitrix/modules/catalog/mysql/product.php
Line: 44
MySQL Query Error: INSERT INTO b_catalog_product(`BUNDLE`, `AVAILABLE`, `TYPE`, `HEIGHT`, `LENGTH`, `WIDTH`, `SUBSCRIBE`, `QUANTITY_RESERVED` `BARCODE_MULTI` `NEGATIVE_AMOUNT_TRACE` `CAN_BUY_ZERO` `VAT_INCLUDED` `, `QUANTITY_TRACE`, `QUANTITY`, `ID`) VALUES('N', 'Y', '1', '0', '0', '0', 'D', '0', 'N ', 'D', 'D', 'N', '0', 'Y', 'N', NULL , 'D', '0', 'S', '25000', 'D', '0 ', '40810')[Duplicate entry '40810' for key 'PRIMARY']

No one can help, as a result, the goods do not really come (prices do not go away, properties are not all).
The exchange itself always worked well, the problem happened when a new nomenclature was connected to download for the site. Where to dig?..

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Abdula Magomedov, 2017-02-08
@Avarskiy

[Duplicate entry '40810' for key 'PRIMARY']

2 entities with the same id
And yet, delete the file, and do not expose the debug information to the public

G
Greg Plitt, 2017-02-09
@bit24yes

The errors disappeared, after I restored a fresh backup on the test domain and during the installation process, the database was restored.
Through the regular functionality of Bitrix (from the cloud)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question