1. prototype
  2. RO CSVI
  3. Monday, 11 January 2021
  4.  Subscribe via email
i use
rocsvi
7.19.1
and
virtuemart 3.4.2

and when i try to export the category path i get the error
Error in retrieving category - Unknown column 'c.category_parent_id' in 'field list'

I do note want to upgrade this time the vm because maybe there is a conflict with my current theme.

Is there any way to resolve it?
Accepted Answer Pending Moderation
Hello,
Do you have your RO CSVI VirtueMart addon updated to 7.19.1 version? This error was fixed with RO CSVI 7.18.0 version and the fix would support both VirtueMart old and new versions.
Kind regards,

Tharuna

=========================
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
Accepted Answer Pending Moderation
Yes the rocsvi vm plugin is in 7.19.1 version.

The log is tthe following


Details
Date 2021-01-11 09:14:01 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 68 lines
2021-01-11 09:14:01 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2021-01-11 09:14:02 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2021-01-11 09:14:02 0 [DEBUG] RO CSVI Version: 7.19.1
2021-01-11 09:14:02 0 [DEBUG] Joomla! version: 3.9.23
2021-01-11 09:14:02 0 [DEBUG] PHP version: 7.1.33
2021-01-11 09:14:02 0 [DEBUG] =========================
2021-01-11 09:14:02 0 [DEBUG] action: export
2021-01-11 09:14:02 0 [DEBUG] component: com_virtuemart
2021-01-11 09:14:02 0 [DEBUG] operation: category
2021-01-11 09:14:02 0 [DEBUG] override:
2021-01-11 09:14:02 0 [DEBUG] 0: todownload
2021-01-11 09:14:02 0 [DEBUG] output_empty_file: Yes
2021-01-11 09:14:02 0 [DEBUG] localpath: /home4/repairme/public_html/portal
2021-01-11 09:14:02 0 [DEBUG] ftphost:
2021-01-11 09:14:02 0 [DEBUG] ftpport:
2021-01-11 09:14:02 0 [DEBUG] sftp: No
2021-01-11 09:14:02 0 [DEBUG] ftproot:
2021-01-11 09:14:02 0 [DEBUG] ftpfile:
2021-01-11 09:14:02 0 [DEBUG] export_email_subject:
2021-01-11 09:14:02 0 [DEBUG] export_email_body:
2021-01-11 09:14:02 0 [DEBUG] database_username:
2021-01-11 09:14:02 0 [DEBUG] database_host:
2021-01-11 09:14:02 0 [DEBUG] database_portno:
2021-01-11 09:14:02 0 [DEBUG] database_name:
2021-01-11 09:14:02 0 [DEBUG] database_table:
2021-01-11 09:14:02 0 [DEBUG] primary_key_source: category_path
2021-01-11 09:14:02 0 [DEBUG] primary_key_target: id
2021-01-11 09:14:02 0 [DEBUG] create_new_columns: Yes
2021-01-11 09:14:02 0 [DEBUG] clientid:
2021-01-11 09:14:02 0 [DEBUG] clientsecret:
2021-01-11 09:14:02 0 [DEBUG] accesstoken:
2021-01-11 09:14:02 0 [DEBUG] fulltoken:
2021-01-11 09:14:02 0 [DEBUG] spreadsheetid:
2021-01-11 09:14:02 0 [DEBUG] sheetname:
2021-01-11 09:14:02 0 [DEBUG] range_from:
2021-01-11 09:14:02 0 [DEBUG] range_to:
2021-01-11 09:14:02 0 [DEBUG] valueInputOption: RAW
2021-01-11 09:14:02 0 [DEBUG] export_filename: export-ctegories.csv
2021-01-11 09:14:02 0 [DEBUG] export_file: csv
2021-01-11 09:14:02 0 [DEBUG] field_delimiter: $
2021-01-11 09:14:02 0 [DEBUG] text_enclosure: "
2021-01-11 09:14:02 0 [DEBUG] include_column_headers: Yes
2021-01-11 09:14:02 0 [DEBUG] include_empty_nodes: Yes
2021-01-11 09:14:02 0 [DEBUG] signature: No
2021-01-11 09:14:02 0 [DEBUG] publish_state:
2021-01-11 09:14:02 0 [DEBUG] recordstart:
2021-01-11 09:14:02 0 [DEBUG] recordend:
2021-01-11 09:14:02 0 [DEBUG] export_date_format: d/m/Y H:i:s
2021-01-11 09:14:02 0 [DEBUG] export_price_format_decimal: 2
2021-01-11 09:14:02 0 [DEBUG] export_price_format_decsep: ,
2021-01-11 09:14:02 0 [DEBUG] export_price_format_thousep:
2021-01-11 09:14:02 0 [DEBUG] header:
2021-01-11 09:14:02 0 [DEBUG] body:
2021-01-11 09:14:02 0 [DEBUG] footer:
2021-01-11 09:14:02 0 [DEBUG] language: el-GR
2021-01-11 09:14:02 0 [DEBUG] target_language: el-GR
2021-01-11 09:14:02 0 [DEBUG] category_separator: /
2021-01-11 09:14:02 0 [DEBUG] groupbyfields:
2021-01-11 09:14:02 0 [DEBUG] sortfields:
2021-01-11 09:14:02 0 [DEBUG] use_system_limits: No
2021-01-11 09:14:02 0 [DEBUG] max_execution_time:
2021-01-11 09:14:02 0 [DEBUG] memory_limit:
2021-01-11 09:14:02 0 [DEBUG] csvi_template_id: 30
2021-01-11 09:14:02 0 [DEBUG] tags:
2021-01-11 09:14:02 0 [DEBUG] =========================
2021-01-11 09:14:02 0 [DEBUG] Export field: category_path_trans
2021-01-11 09:14:02 0 [DEBUG] Export file export-ctegories.csv has been downloaded
2021-01-11 09:14:02 0 [QUERY] INSERT INTO `y8hy5_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (329,0,'Unknown column \'c.category_parent_id\' in \'field list\'','Failure','Incorrect','Categories')
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Yes the rocsvi vm plugin is in 7.19.1 version.

The error Unknown column 'c.category_parent_id' in 'field list with c.category_parent_id shows that you are using old version of RO CSVI VirtueMart addon extension. With latest RO CSVI VirtueMart 7.19.1 version the query should be x.category_parent_id. So to check on that go to Joomla Extension manager >> Manage >> Manage, click on Search tools button in the Select type filter list select Plugin and in the search box enter csvi(See attached screenshot). That would list all installed RO CSVI extensions. In that list look for RO CSVI - VirtueMart and check the Version. Please post a screenshot on the installed version.
Attachments (1)
Kind regards,

Tharuna

=========================
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. # 3
Accepted Answer Pending Moderation
Please see the screenshot in the following link
https://drive.google.com/file/d/1l7m1-LF-_oG-LtCKSPuJvTOLOe5kXmoE/view?usp=sharing
Thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
That is really strange. Please load the attached patch file and then run the export. I have created a patch file from RO CSVI VirtueMart 7.19.1 version file so to check if it fixes the error on export.

Let me know on how that goes.
Attachments (1)
Kind regards,

Tharuna

=========================
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. # 5
Accepted Answer Pending Moderation
Still the same
category_path_trans
Error in retrieving category - Unknown column 'c.category_parent_id' in 'field list'
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Please load the attached patch file and try the export. Let me know if it fixes the export error.
Attachments (1)
Kind regards,

Tharuna

=========================
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. # 7
Accepted Answer Pending Moderation
Yes it works!
Thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


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