Index Rebuild Problem

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3/Flow, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
velo
Posts: 44
Joined: 20 Jun 2016, 06:58

Index Rebuild Problem

Post by velo » 22 Jul 2016, 07:56

Hey there,

we have the following Problem. When we rebuidl the index through the scheduler task I get a bunch of this errors:

Code: Select all

Executing statement "
			INSERT INTO "mshop_index_text" (
				"prodid", "siteid", "textid", "langid", "listtype", "type",
				"domain", "value", "mtime", "editor", "ctime"
			) VALUES (
				11, 1, '117', 'de', 'default', 'faqAnswer', 'attribute', 'Das ist die Antwort zur Frage', '2016-07-22 09:48:25', 'scheduler', '2016-07-22 09:48:25'
			)
		" failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '11-1-117-default' for key 'unq_msindte_p_s_tid_lt'
Even if I truncate the whole mshop_index_text table. I can't figure out whats the problem. The text element appears just one time in the mshop_text table

Thanks in advance
[pb]

User avatar
aimeos
Administrator
Posts: 3787
Joined: 01 Jan 1970, 00:00

Re: Index Rebuild Problem

Post by aimeos » 22 Jul 2016, 20:55

Check what's referenced in the mshop_product_list table of your product with ID 11. It's an attribute causing the error.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply