Resolved Update available fields stops with error

Hi Sigrid,

That is really weird. I cannot reproduce it in anyway I try. Removing that line from the database doesn't help because we already empty the table before it starts. Could you post the login details for the site and (S)FTP access please? I will take a look to see what is going on.

hm, I uploaded the patch,
but still get the same error...

Hi Sigrid,
With attached patch file we removed duplicate entry of orderitem field in J2Commerce. That is the same file Roland told you to edit. Please load the attached patch file and run the update of available fields. Check if that solves the error.

Hi Sigrid,

Can I remove entries manually from the table?

Yes remove entries from the table and edit the file Roland mentioned in his reply and run the update of available fields again. See if that solves the error.

this is my table (part of it)

no, it is still not workting.
error:
An error occurred running the query ALTER TABLE `t2cap_csvi_availabletables` ADD unique INDEX `type_name` (`task_name`,`template_table`,`component`,`action`);. This generates the error Duplicate entry 'orderitem-j2store_orderitemattributes-com_j2store-import' for key 'type_name'

Can I remove entries manually from the table?

Hi Sigrid,

The error happens because the update tries to insert a second entry into the csvi_availabletables table. The entry is where task name is orderitem, template_table is j2store_orderitemattributes, component is com_j2store, and action is import.

Now I looked and see there is a duplicate entry in the file plugins/csviaddon/j2store/com_j2store/install/tasks.sql. If you edit that file and remove the line 47 and save the file. After that you should be able to update the list of available fields again.

Let us know how it goes.