Hi when I try an export of virtuemart products I get this error:
error
Unknown column 'f.table_name' in 'field list'
Also fields are not added at all to the template.
administrator/index.php?option=com_csvi&view=templatefields
When I click save I see a success message that the field is saved but the fields are not added to any list. There is no list like on:
https://csvimproved.com/support/tutorials/239-virtuemart/1521-virtuemart-products#export
I repaired the database with the fix button, but it didn't help.
using csvi pro 7.4.1
Joomla versie, 3.8.5.
Hello,
Run the below query and check if error is gone and you can also see the list of template fields you added. To run the query 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 `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
I ran the aforementioned MySQL query and I got the following result.
Code:
SQL query:
ALTER TABLE zenenik3_csvi_templatefields ADD COLUMN table_name VARCHAR(255) NOT NULL COMMENT 'Table name for custom export' AFTER field_name
MySQL said: Documentation
#1060 - Duplicate column name 'table_name'
Now I see this error:
Unknown column 'f.field_date_format' in 'field list'
Hello,
MySQL said: Documentation
#1060 - Duplicate column name 'table_name'
This error says that column table_name is already in your #__csvi_templatefields table.
Now I see this error:
Unknown column 'f.field_date_format' in 'field list'
Can you run the below query and check if this error is gone?
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
Hello,
You can also have a look at the sticky post about installation problems we made with details on how to fix these errors.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.