1. Norbert-Wache
  2. RO CSVI
  3. Tuesday, 27 February 2018
  4.  Subscribe via email
Joomla!-Version 3.8.5
VirtueMart 3.0.18

Hello,
I've done an upgrade to CSVI Pro 7.4.1 . But now (and before) I get this Export Error Unknown column 'f.table_name' in 'field list' with old an new templates.

Greatings
Norbert
Accepted Answer Pending Moderation
Hello Norbert,
Your #__csvi_templatefields table is missing a field and that is the error you see on export. Go to CSVI About page and click on Fix database button to see if the error is gone. If not, copy the below query in SQL tab in your PhpMyAdmin and run it to add the missing field.

ALTER TABLE `#__csvi_templatefields`
ADD COLUMN `table_name` VARCHAR(255) NOT NULL COMMENT 'Table name for custom export' AFTER `field_name`;
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
Hello.

I did that. Now I get this error message:

Unknown column 'f.field_date_format' in 'field list'

Regards

Norbert
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Nobert,
Can you also run the below query and see if it fixes the error?

ALTER TABLE `#__csvi_templatefields`
ADD COLUMN `field_date_format` VARCHAR(25) NOT NULL COMMENT 'Date format for the export field' AFTER `default_value`;
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
  • Page :
  • 1


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