Article items -> translate button -> Error „Duplicate entry“

More
7 years 1 month ago - 7 years 1 month ago #70367 by pabro
Hi,

if i try to translate some items via „translate“ button on backend, and there is already an associations for this item, i get the error

1062 Duplicate entry 'com_content.item-1471' for key 'PRIMARY'

I need to association more than two languages to an item. Is this a bug?

Joomla! 3.7.5
FLEXIcontent 3.2.1.7


Thank you
Paul
Last edit: 7 years 1 month ago by pabro.

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #70369 by ggppdk
Hello

it looks like some MyISAM (mysql) table(s) have index corruption

try performing "Fix" for all table via phpmyadmin or similar tool


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #70372 by pabro
To fix table does not have any effect.

I deleted all copied items and try again to translate/copy. First translation/copy work. The second translation for third language get same error again. If i skipp the item id in error message, the next item id also does not work. The item related to error has copied (only this) , but without associations.

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #70374 by ggppdk
Hello

i see,

i ll test it tomorrow


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago - 7 years 1 month ago #70383 by ggppdk
Hello

Fix will be in next release

to get fix now , in file

administrator/components/com_flexicontent/models/items.php

replace (about line 1937)
Code:
flexicontent_db::saveAssociations($row, $_data, $context); // Save associations, adding the new item
with
Code:
flexicontent_db::saveAssociations($item, $_data, $context); // Save associations, adding the new item


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...
Last edit: 7 years 1 month ago by ggppdk.

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #70415 by pabro
Great support, ggppdk. Thank you! (:

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.506 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline