Resolved template fields missing virtuemart import

Hello,

What can i do next?

As it turns out on some sites there is an inconsistency in the database. You can try to execute this query using PhpMyAdmin for example

ALTER TABLE `jos_csvi_availablefields`

	DROP INDEX `component_name_table`,

	ADD UNIQUE INDEX `component_name_table` (`component_name`, `component_table`, `component`, `action`);

and replace jos_ with your own prefix. After that you can update the list of available fields and you should see all.

Hai
Thank you for your reply
I logged in my phpadmin, found the table
but I have never made any changes in a database before , don't know/understand what to do
Could you please explain how to do what you described, If possible in dutch?
Leontine

Hello Leontine,

When you are in PhpMyAdmin, click on the csvi_availablefields table in the left column. This will give you the details of your table. In the main part of the screen, you have a menu at the top. One of the items is called SQL. Click on that and you will see an input area. It already has something there but that can be removed. Now copy the query I posted earlier into that box, change the prefix jos_ to your own prefix and click on the Go button. You are done.

Now you can run the update of the fields and you can see if all fields are there.

Ok thank you!!
I think it works now