Categories
View Replies (6)

Resolved Cannnot export from example templates

  1. mathm00
    mathm00
  2. RO CSVI
  3. Friday, 14 August 2015
  4.  Subscribe via email
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?
0
Responses (6)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
mathm00
mathm00
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 2
mathm00
mathm00
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
uudis
uudis
Accepted Answer Pending Moderation
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!
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!