1. kilombo
  2. RO CSVI
  3. Monday, 15 January 2018
  4.  Subscribe via email
Good evening,

When i try to export my virtuemart orders, it returns this error "Unknown column 'f.field_date_format' in 'field list'".
Joomla is latest version, CSVI is latest version, and Virtuemart is also latest version.
Help needed please.

Thanks in advance.
Accepted Answer Pending Moderation
Good evening,

When i try to export my virtuemart orders, it returns this error "Unknown column 'f.field_date_format' in 'field list'".
Joomla is latest version, CSVI is latest version, and Virtuemart is also latest version.
Help needed please.

Thanks in advance.


I just attached a printscreen, unfortunately there's no log. csvi.png
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
There is a missing database field in #__csvi_templatefields table and so you are getting this error. Go to CSVI About page and click on Fix database button to fix the missing field for CSVI table. Run the export after that.
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. # 2
Accepted Answer Pending Moderation
Good evening mate..

Unfortunately... it didn't worked out. Must be something more serious. I really need help on this.

Thanks,

NF
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Can you try to run the below query from your phpMyAdmin and check if error is gone? Go to your phpMyAdmin >> select your database >> on SQL tab, copy the below query and click Go. Don't forget to replace #__ with your table prefix.

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. # 4
  • Page :
  • 1


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