Resolved Cant export products

Hello,

As the error states,you are missing a table. This name aqct2_virtuemart_vendors_ should actually be aqct2_virtuemart_vendors_hu_hu. Go to the configuration in VirtueMart and set the language to use to Hungarian and save the configuration. This should create the missing tables.

I tried to set language Hungarian and now I see these tables:

aqct2_virtuemart_vendors Tartalom Tartalom Szerkezet Szerkezet Keresés Keresés Beszúrás Beszúrás Kiürítés Kiürítés Eldobás Eldobás 1 MyISAM utf8_general_ci 5.1 KB -
aqct2_virtuemart_vendors_hu_hu Tartalom Tartalom Szerkezet Szerkezet Keresés Keresés Beszúrás Beszúrás Kiürítés Kiürítés Eldobás Eldobás 1 MyISAM utf8_general_ci 8.1 KB -
aqct2_virtuemart_vendor_medias Tartalom Tartalom Szerkezet Szerkezet Keresés Keresés Beszúrás Beszúrás Kiürítés Kiürítés Eldobás Eldobás 0 MyISAM utf8_general_ci 1 KB -
aqct2_virtuemart_vendor_users

Is there a problem with the "_"?
I have "aqct2_virtuemart_vendors" but you wrote "aqct2_virtuemart_vendors_"

Is there a problem with the "_"?
I have "aqct2_virtuemart_vendors" but you wrote "aqct2_virtuemart_vendors_"

I wrote you need aqct2_virtuemart_vendors_hu_hu. Now you have that table so you should be good to import.

I see the same problem.

I use (always) my own export template, I had no problems earlier with other CSVI (free) versions with other VM versions.

I tried to use the sample templates, but I get error message: (It is not a problem to me.)
"Table 'petrimis_xXe3xx.aqct2_virtuemart_categories_en_gb' doesn't exist SQL=SELECT x.category_parent_id AS parent_id, x.category_child_id AS id, l.category_name AS catname FROM aqct2_virtuemart_categories c LEFT JOIN aqct2_virtuemart_category_categories x ON c.virtuemart_category_id = x.category_child_id LEFT JOIN aqct2_virtuemart_categories_en_gb l ON l.virtuemart_category_id = c.virtuemart_category_id"

Hello,

I see the same problem.

It is not the same You are talking about other tables. You have used the sample templates but not adjusted them to your system. So you can either choose the correct language on the Options tab or convert your site to use en-GB as the main language

I have similar problem to the original question here, but it is not corrected with language solution mentioned.

Using sample virtuemart product export, I get this error to csv (within the html code):
1146 Table 'foodynor_db.jos_virtuemart_vendors_' doesn't exist SQL=SELECT `jos_virtuemart_vendors`.* ,`jos_virtuemart_vendors_`.* FROM `jos_virtuemart_vendors` INNER JOIN `jos_virtuemart_vendors_` using (`virtuemart_vendor_id`) WHERE `jos_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

I was using only english, and just to be on safe side I deleted all other languages from Joomla too, and also other language tables through phpMyAdmin. I also cehecked that the table
jos_virtuemart_vendors_en_gb
was still there. Would you have any other ideas where to look about this?

Thanks in advance!

Hello Seppo,

Would you have any other ideas where to look about this?

The problem is that there is no language set in the template it seems.

1146 Table 'foodynor_db.jos_virtuemart_vendors_' doesn't exist

Notice there is nothing after vendors_, the en_gb is supposed to be there so it looks like vendors_en_gb. Check your template if English is selected there and save it again, see what the export does after that.

I checked the joomla template, and it was set for all languages. Anyway, I resaved it, no help. I tried to unpublish system language selection plugin too, no help there either. I also made sure in virtuemart settings there is only english in the first tab multilanguage field. I also tried it with different computer just to be sure nothing comes from cache, and also emptying site/admin cache. Nothing helped.

It seems odd since I am even not trying to export vendor information. In one of the previous problems the issues came from plugin vmVendor, which was still unpublished. Just to try out I republished it, with no help here though.

It seems somehow csvi is not understanding there is english in use, even all other parts do see it. And I see it in CSVI settings anyway in options/primary language, but when exporting that message comes to csv file. Where does it read that from, somewhere from database? If so I can check if there is some wrong value somehow there.

Hello,

Which version of CSVI Pro are you using? It is actually not a problem from CSVI I see, I needed to jog my memory, but it is from VirtueMart. This is triggered by CSVI when it tries to retrieve the prices for a product.

If you are not using the last version 5.21.1. please do an update first and check if that works for you. If it doesn't, let me know what you are exporting and which versions of Joomla, VM and CSVI you are using.

I had version 5.20 of CSVI Pro but updating to 5.21.1 solved the problem. I had missed there was an update, thank you for help, this is solved now for me