Resolved Virtuemart fields missing

Hello,
You need to download and install the CSVI VirtueMart addon from the Download section under CSVI Extensions, after that you can see VirtueMart in the drop down list.

Also i see that you have installed the old version of CSVI as the current version is CSVI 6.6.2, it is recommended you install the latest version.

I had a working CSI template which was used to process an XML file. I updated Joomla and the PHP version and got some error:
Fatal error: Cannot use 'String' as class name as it is reserved in...
So I decided to update CSVI to the latest 6.6.3 version and of course the VM plugin too. The error message is gone but I also can't import the new products, data is missing from language related tables. There ara a lot of "Language Missing id 72972" type messages in the product list.
The XML is imported via cron.
I checked the template fields, there are all of them in the list: http://imgur.com/a/LBYBP
But if I try to open the product_name field, "field name" is empty and I can't find "product_name": http://imgur.com/a/vVchL
I tried to reset tasks and update available fields but they still missing.
The log file is here:
https://dl.dropboxusercontent.com/u/11777283/csvi/com_csvi.log.2994.zip
Could you help me please with this?

Hello,

In CSVI go to Available fields and click Update. After that check your fields and all should be good.

Hi rolandd,
Of course this was the first thing I tried but product_name is still missing.

Minor notice: I open Availagble fields menu item, select Virtuemart component and the third filter is empty.

Hello,

In that case it is better to follow the documentation Missing fields in CSVI as this also explains how to reset the tasks. The tasks is the third filter that is empty, which in turn also means why you don't see the fields. Give that a try.

I tried that too as I mentioned originally
I also checked some random fields from plugins/csviaddon/virtuemart/com_virtuemart/install/templates.xml and there were a lot of missing fields when checked in #__csvi_availablefields
So I tried to import plugins/csviaddon/virtuemart/com_virtuemart/install/availablefields.sql manually which did the trick, I got the missing fields and my new products.

Hello,

I tried that too as I mentioned originally

Yes you did, apologies, I misread that.

I still wonder why the SQL files don't get loaded when you run the update of the available fields. You don't get any errors running the update?

no problem at all

You're right I missed an error message:

Duplicate entry 'szám-product-com_virtuemart-import' for key 'component_name_table' SQL=INSERT INTO `#__csvi_availablefields`
(`csvi_name`,`component_name`,`component_table`,`component`,`action`) VALUES
('Szín','Szín','product','com_virtuemart','import'),('Szín','Szín','product','com_virtuemart','export'),('Tejlesítmény','Tejlesítmény','product','com_virtuemart','import'),('Tejlesítmény','Tejlesítmény','product','com_virtuemart','export'),('Teljesítmény','Teljesítmény','product','com_virtuemart','import'),('Teljesítmény','Teljesítmény','product','com_virtuemart','export'),('Logó Típus','Logó Típus','product','com_virtuemart','import'),('Logó Típus','Logó Típus','product','com_virtuemart','export'),('Szám','Szám','product','com_virtuemart','import'),('Szám','Szám','product','com_virtuemart','export'),('Minta','Minta','product','com_virtuemart','import'),('Minta','Minta','product','com_virtuemart','export'),('Méret','Méret','product','com_virtuemart','import'),('Méret','Méret','product','com_virtuemart','export'),('Méretek','Méretek','product','com_virtuemart','import'),('Méretek','Méretek','product','com_virtuemart','export'),('Állatfigurák','Állatfigurák','product','com_virtuemart','import'),('Állatfigurák','Állatfigurák','product','com_virtuemart','export'),('','','product','com_virtuemart','import'),('','','product','com_virtuemart','export'),('Típus','Típus','product','com_virtuemart','import'),('Típus','Típus','product','com_virtuemart','export'),('szám','szám','product','com_virtuemart','import'),('szám','szám','product','com_virtuemart','export'),('Név','Név','product','com_virtuemart','import'),('Név','Név','product','com_virtuemart','export'),('teszt4','teszt4','product','com_virtuemart','import'),('teszt4','teszt4','product','com_virtuemart','export')


I'm not sure where it comes from, I don't have any customfields with this name. Btw "szám" means "number" in Hungarian

Hello,

That is indeed the reason why it won't load. The custom fields come from the virtuemart_custom table and there are 2 custom fields with the same name but one has an uppercase letter and the other a lowercase letter. So that will need to be cleaned up. You would be able to see these fields in Custom fields in VirtueMart I guess.

you're right, thanks