1. Kubushosting
  2. RO CSVI
  3. Thursday, 04 December 2014
  4.  Subscribe via email
Hello,

I have a problem with importing a file with custom fields.

I get the following error:
An error has occurred.
1054 Unknown column 'customfield_value' in 'field list' SQL=SELECT customfield_value FROM `hxtz4_virtuemart_customs` WHERE `virtuemart_custom_id`=22

Attachments:
Screenshot of error with firebug
Debug log in a txt file

Thx in advance
Accepted Answer Pending Moderation
Hello,

Which VirtueMart version are you using? Give CSVI 5.20 a try in case you are using VirtueMart 2.9.x or 3.x.
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. # 1
Accepted Answer Pending Moderation
I am on 3.3.6
Virtuemart 3
and now on 5.20 csvi

I'm getting after the update a different error.

An error has occurred.

1054 Unknown column 'customfield_value' in 'field list' SQL=SELECT customfield_value FROM `hxtz4_virtuemart_customs` WHERE `virtuemart_custom_id`=30


File that I use, perhaps is that wrong?
This works on other website perfectly
http://kerckhoeve.org/images/product.rar
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

I believe you have found one place were VirtueMart didn't change the column name but I did change the code.

Attached is a patch file which you can load via the maintenance page. After that run your import and all should be OK.
Attachments (1)
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. # 3
Accepted Answer Pending Moderation
After applying the patch, it gives the same error.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
My bad, I missed a spot. Hereby the updated patch, please give it a go and let me know how it goes.
Attachments (1)
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. # 5
Accepted Answer Pending Moderation
That did the job, thx :woohoo:
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Rolandd,

I tried to download the above patch but I keep on getting directed to a 404 page?

Could you please email it to me

Thanks

Rick
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Rick,

The patch is actually there but there is a conflict between Kunena and the multi-language system. Something I will need to figure out. The patch has been emailed to you.
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. # 8
Accepted Answer Pending Moderation
Thanks Rolandd,
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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