Resolved Update Available Fields fails - Duplicate entry for key 'component_name_table'

Hello Ralph,
If you are not running the latest CSVI 7.6.2 version please update to this version and see if the error is gone.

Hi Tharuna,

Sorry, but I'm already running latest CSVI 7.6.2.
Problems started after upgraded from CSVI 7.4.1

Kind regards,

Ralph

Hello Ralph,
Did you also update your CSVI VirtueMart addon to 7.6.2 version?

Hi Tharuna,

Yes, I did.

Regards, Ralph

Hello Ralph,
Before running the available fields update, CSVI deletes the available fields table and does a fresh import of fields. In your case this is not happening and so you are seeing a duplicate entry error. Not sure how you get that to happen. Can you go to CSVI About page and click on Verify Database button? This will solve any conflicts with CSVI tables. Now try running available field update and see if error is solved.

Hi Tharuna,

That didn't fix the problem.

I also tried truncating the available fields table, but that didn't work either.
Besides, I noticed in the logs that during the update the table gets deleted and recreated, so that seems to work.
It just stops after 'query 5'.

Log:
Regel Actie Resultaat Bericht
0 Verwijder Available fields table deleted
0 Added Available fields table created
1 Toegevoegd Geslaagd Custom available fields for Joomla Categories have been added. Query number 1.
2 Toegevoegd Geslaagd Custom available fields for Joomla Contact have been added. Query number 1.
3 Toegevoegd Geslaagd Custom available fields for Joomla Content have been added. Query number 1.
4 Toegevoegd Geslaagd Custom available fields for Joomla Custom fields have been added. Query number 1.
5 Toegevoegd Geslaagd Custom available fields for Joomla Menus have been added. Query number 1.
6 Toegevoegd Geslaagd Custom available fields for Joomla Modules have been added. Query number 1.
7 Toegevoegd Geslaagd Custom available fields for Joomla Users have been added. Query number 1.
8 Toegevoegd Geslaagd Custom available fields for VirtueMart have been added. Query number 1.
8 Toegevoegd Geslaagd Custom available fields for VirtueMart have been added. Query number 2.
8 Toegevoegd Geslaagd Custom available fields for VirtueMart have been added. Query number 3.
8 Toegevoegd Geslaagd Custom available fields for VirtueMart have been added. Query number 4.
8 Toegevoegd Geslaagd Custom available fields for VirtueMart have been added. Query number 5.
8 Fout Duplicate entry 'custom_param_nl_nl-product-com_virtuemart-import' for key 'component_name_table'

Kind regards, Ralph

Hello Ralph,
Can you load the attached patch file and see if error is gone on update available fields?

patch_vm_2018_05_12.zip

Hi Tharuna,

No, sorry, error is not gone.

Regards, Ralph

Hi again,

Just a quick thought: I'm currently using VirtueMart version 3.2.6 on this site, not the latest (3.2.14).
Could this be of any influence?

Regards, Ralph

Hello Ralph,
I don't think VirtueMart version could be a problem. Can you email me the MySql dump of your VirtueMart tables? I will check what is causing this error. My email is tharuna@csvimproved.com.

Hi Tharuna,

E-mail has been sent.

Thank you,

Ralph

Hello Ralph,
Thank you for sending the email but the dump file has no records and just the structure of the tables. Please make sure that structure and data option is selected when creating the dump file. Can you send the dump file again with records?

Hi,

Re-sent, incl. data.

Regards, Ralph

Hello Ralph,
Yes, the MySQL dump file looks good now. I will take a look and update on what i find.

Hello Ralph,
Found the cause for the issue, you have same language code set in VirtueMart config and so you were seeing duplicate error. Please load the attached patch file and check if the error is gone.

patch_vm_2018_05_15.zip

Hi Tharuna,

YES! It is working now. Thank you very much!

So, as far as I understand, there is a problem in my VirtueMart config?
I'm not sure what you mean by 'you have same language code set in VirtueMart config'.
I understand this has nothing to do with your component, but can you please point me into the right direction?

Thank you,

Kind regards,

Ralph

Hello Ralph,

YES! It is working now. Thank you very much!

Thank you for confirming that patch is working.

So, as far as I understand, there is a problem in my VirtueMart config?
I'm not sure what you mean by 'you have same language code set in VirtueMart config'.
I understand this has nothing to do with your component, but can you please point me into the right direction?

When i checked your VirtueMart configuration in database for languages it was duplicated like active_languages=["nl_nl","nl-NL"] but the configuration from Backend VirtueMart configuration page was looking good. Not sure how you got in language code for same language twice in your database table.

Thanks, I will look into that!

Kind regards, Ralph