Categories
View Replies (4)

Resolved Fout Unknown column 'f.table_name' in 'field list'

  1. ETjdideal
    ETjdideal
  2. RO CSVI
  3. Wednesday, 07 March 2018
  4.  Subscribe via email
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.
0
Responses (4)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
ETjdideal
ETjdideal
Accepted Answer Pending Moderation
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'
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
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
  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!