1. porscha
  2. RO CSVI
  3. Thursday, 16 July 2020
  4.  Subscribe via email
Hi all :)

RO CSVI 7.17.0
Joomla: 3.9.20
VirtueMart 3.6.10 10211

I have this error during the export

Unknown column 'c.category_parent_id' in 'field list'

I have category_path column from where the error comes, cause when delete category_path column from fields list of my template, there is no error. Please help :) I saw other topic with this error https://rolandd.com/support/ro-csvi/unknown-column-c-category-parent-id-in-field-list but it is password protected, so I could not read it.

Have a great day!
Chrissy
Accepted Answer
Accepted Answer Pending Moderation
Hello Chrissy,
VirtueMart 3.6.10 10211

In this version of VirtueMart the field category_parent_id is not there in #__virtuemart_categories table but this field is available from the next VirtueMart 3.6.11 version. This is the reason you are seeing the error with this VirtueMart version.

So basically if you are using RO CSV 7.17, you need to have VM version 3.8 or to remove 'c.' from 'c.category_parent_id' in line 796 in plugins/csviaddon/virtuemart/com_virtuemart/helper/com_virtuemart.php file. Is it better to update VM?

With RO CSVI 7.17.0 version we have added support for new fields which have been added for VirtueMart 3.8 version. So updating VirtueMart should not be an issue in terms of RO CSVI import and exports.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer Pending Moderation
Hello Chrissy,
Unknown column 'c.category_parent_id' in 'field list'

The fix for this issue has been included in RO CSVI 7.17.0 version. Did you also update RO CSVI VirtueMart addon to 7.17.0 version?

If you have updated your RO CSVI VirtueMart addon and you still have this error, can you tell me which export you are running?

Please help :) I saw other topic with this error https://rolandd.com/support/ro-csvi/unknown-column-c-category-parent-id-in-field-list but it is password protected, so I could not read it.

If you login into the site you should be able to read the post.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Yes, the VM addon was updated before the error. I run a Product Export. I can not see the post, although I am logged in the site, I think that the author had protected his post.

I have ROCSV on other site with version 7.16 and did not have this error.
  1. 3 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Here's the log file
Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Chrissy,
Yes, the VM addon was updated before the error. I run a Product Export.

I see you are using VirtueMart 3.6 version. Can you check two things?

1. Please check if there is category_parent_id column in #__virtuemart_categories table.
2. Go to file plugins/csviaddon/virtuemart/com_virtuemart/helper/com_virtuemart.php and on line 796 remove 'c.' from 'c.category_parent_id' so it is just 'category_parent_id', save the file and run the export. See if you still get the error.

I can not see the post, although I am logged in the site, I think that the author had protected his post.

That post is set to private as user had posted his site login details. That could be the reason you are not able to access it.

I have ROCSV on other site with version 7.16 and did not have this error.

That is because the fix for error Unknown column 'c.category_parent_id' in 'field list' was included in RO CSVI 7.17.0 version and was for VirtueMart 3.8 version. You must be using VirtueMart 3.6 in that site and so there is no error.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Tharuna,

1. Please check if there is category_parent_id column in #__virtuemart_categories table.
2. Go to file plugins/csviaddon/virtuemart/com_virtuemart/helper/com_virtuemart.php and on line 796 remove 'c.' from 'c.category_parent_id' so it is just 'category_parent_id', save the file and run the export. See if you still get the error.


This did the work.

On the other site, where RO CSV is version 7.16, the VM version is 3.6.

So basically if you are using RO CSV 7.17, you need to have VM version 3.8 or to remove 'c.' from 'c.category_parent_id' in line 796 in plugins/csviaddon/virtuemart/com_virtuemart/helper/com_virtuemart.php file. Is it better to update VM?
  1. 3 weeks ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Thank you Tharuna! You are in great help as always :)
  1. 3 weeks 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!