1. porscha
  2. RO CSVI
  3. Tuesday, 24 January 2023
  4.  Subscribe via email
Hello,
I am trying to make a Category export from VM with category_name and category_path, but what I have received is an export with the following info:

category_name
COM_CSVI_ERROR_RETRIEVING_DATA

Please point me where is the problem. For your info i can tell that, when I am exporting products with product_syu, product_name, category_path, and many custom fields columns, there is NO problem with the export. So there is a problem in connection with CSV and VM tables that responsible for categories maybe...

CSV 7.14.0
Joomla! 3.10.8
VirtueMart 3.6.8

Have a great evening!
Hrissy
Attachments (1)
Accepted Answer
Accepted Answer Pending Moderation
Hello Hrissy,
The error "Column 'category_parent_id' in field list is ambiguous" is why you see COM_CSVI_ERROR_RETRIEVING_DATA error on export.

Since you are using old RO CSVI version you can solve this error by editing file plugins/csviaddon/virtuemart/com_virtuemart/model/export/category.php on line 52 change


$this->db->quoteName('c.category_parent_id', 'pid')


to


$this->db->quoteName('x.category_parent_id', 'pid')


Let me know if that helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.