Hello,
I use Joomla 3.4.3, Virtuemart 3.0.9 and CSVO 6.0.1. It seems the "Example Templates" don't work properly on my site. I get this error message (image 1): Fout
Unknown column 'skip' in 'field list' SQL=SELECT kls_virtuemart_products.virtuemart_product_id, kls_virtuemart_products.product_parent_id, product_sku, skip, kls_virtuemart_products.published, product_in_stock FROM kls_virtuemart_products LEFT JOIN kls_virtuemart_product_prices ON kls_virtuemart_products.virtuemart_product_id = kls_virtuemart_product_prices.virtuemart_product_id LEFT JOIN kls_virtuemart_product_manufacturers ON kls_virtuemart_products.virtuemart_product_id = kls_virtuemart_product_manufacturers.virtuemart_product_id LEFT JOIN kls_virtuemart_manufacturers ON kls_virtuemart_product_manufacturers.virtuemart_manufacturer_id = kls_virtuemart_manufacturers.virtuemart_manufacturer_id LEFT JOIN kls_virtuemart_product_categories ON kls_virtuemart_products.virtuemart_product_id = kls_virtuemart_product_categories.virtuemart_product_id LEFT JOIN kls_virtuemart_currencies ON kls_virtuemart_currencies.virtuemart_currency_id = kls_virtuemart_product_prices.product_currency LEFT JOIN kls_virtuemart_product_shoppergroups ON kls_virtuemart_product_shoppergroups.virtuemart_product_id = kls_virtuemart_products.virtuemart_product_id WHERE kls_virtuemart_products.published = 1
When I make a Template with Products it seems to work, but with Prices (image 2 and 3) is no Table with Fields to select (image 4)???
Already deinstallation 6.0.1, installation 5.21.2 and upgrade 6.0.1. All csvi_tables deleted and a new Installation CSVI 6.0.1 with restore Templates virtuemart 6.0.0 and installation plugin csviaddon virtuemart.
What can I do to solve this Issue?
Hello,
Looking at the last image, it seems your template has no fields associated and the VirtueMart addon was installed later. So here is what you can do. Go to Maintenance -> Tasks -> Reset and confirm. After that go to Maintenance -> Available Fields and click Update.
Go to Templates -> Template fields and select your template and see if you get any fields.
You can also restore the example templates again if you want. You may want to delete the old example templates first otherwise you get duplicates.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD,
Thanks for your Response.
I have the Tasks Reset and the Available Fields updated. There were No Fields in the Database. All deinstalled , the DB with csvi_* deleted. A new and clean Installation with com_csvi_6.0.1_pro.zip and the plg for Virtuemart. No Templates restored.
A new Template (Export VM price) made and the Results was OK. A new Template (Export VM product) was the error:
Fout
Unknown column 'skip' in 'field list' SQL=SELECT kls_virtuemart_products.virtuemart_product_id, kls_virtuemart_products.product_parent_id, product_sku, product_in_stock, skip, product_params FROM kls_virtuemart_products LEFT JOIN kls_virtuemart_product_prices ON kls_virtuemart_products.virtuemart_product_id = kls_virtuemart_product_prices.virtuemart_product_id LEFT JOIN kls_virtuemart_product_manufacturers ON kls_virtuemart_products.virtuemart_product_id = kls_virtuemart_product_manufacturers.virtuemart_product_id LEFT JOIN kls_virtuemart_manufacturers ON kls_virtuemart_product_manufacturers.virtuemart_manufacturer_id = kls_virtuemart_manufacturers.virtuemart_manufacturer_id LEFT JOIN kls_virtuemart_product_categories ON kls_virtuemart_products.virtuemart_product_id = kls_virtuemart_product_categories.virtuemart_product_id LEFT JOIN kls_virtuemart_currencies ON kls_virtuemart_currencies.virtuemart_currency_id = kls_virtuemart_product_prices.product_currency LEFT JOIN kls_virtuemart_product_shoppergroups ON kls_virtuemart_product_shoppergroups.virtuemart_product_id = kls_virtuemart_products.virtuemart_product_id WHERE kls_virtuemart_products.published = 1 ORDER BY product_sku
What can I do to resolve this Issue?
Hi Roland,
The Template is working without an Error when I deleted some fields. When I a Field add gives the Export this Error. When I change the Field it go's well and sometimes an Error. (It seems that the Query don't working well)!
With kind Regards,
Marcel Mathijssen
Hello Marcel,
What can I do to resolve this Issue?
Update to version 6.1.0 released today and the message will be gone. However it does mean that any field not recognized is not being exported. The debug log will contain which field(s) is/are skipped. So it will be interesting to see which field that it concerns.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello!
I have same problem with similar error output when defined price_with_tax for export:
Unknown column 'skip' in 'field list' SQL=SELECT......
As i understand price_with_tax this is custom CSVI Case , so i found administrator/components/com_csvi/helper/exportfields.php line: 38
$data->field_name = 'skip';
..but have no clue, by hacking this line will fix my query.
All prices in export xml have to appear price_with_tax = product_price * 1.21
Please help me on this!
Hello,
Make sure you have version 6.1.0 of CSVI and the VirtueMart add-on, this error has been fixed and line 38 says something different.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.