Categories
View Replies (5)

Resolved Error: 1054 Unknown column "customfield_value"

  1. Alezo
    Alezo
  2. RO CSVI
  3. Tuesday, 14 October 2014
  4.  Subscribe via email
Hello RolandD!

It seems we have an issue with custom fields import. Here's the full text of the error: "1054 Unknown column 'customfield_value' in 'field list' SQL=SELECT `customfield_value` FROM `n5zqw_virtuemart_customs` WHERE `virtuemart_custom_id`=41" (screenshot attached).

I would also like to add that our hosting provider updated MySQL server to version 5.6 (we had another issue with export: http://www.csvimproved.com/forum?view=topic&catid=44&id=31892). Maybe that might be useful.

We would really appreciate your help. Thank you!

Required Information:
1.Virtuemart 2.9.9e
2. CSVI Pro 5.19
3. Joomla 3.3.6
4. Import file: custom_fields_import.zip (attached)
5. Debug Log: com_csvi.log.1413284321.zip (attached)
6. Error screenshot: error.png (attached)

custom_fields_import.zip

com_csvi.log.1413284321.zip

error.png
0
Responses (5)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Alezo,

Thank you for the very detailed bug report. Though it was tricky to find, I do believe the issue has been found and fixed in the attached patch file. It has all to do with the new version of VM not being stable yet. A column change was made that is not there. The attached patch fixes that.

Please apply the patch via the Maintenance menu and let me know how it goes.
Attachments (1)
patch_custom_20141016.zip
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
Alezo
Alezo
Accepted Answer Pending Moderation
RolandD, thank you very much for the time you put into this!
We tried the patch, but the process terminates with the same error. Is there anything we forgot to do?
I've attached the latest debug log just in case.

com_csvi.log.1413470062.zip
Attachments (1)
com_csvi.log.1413470062.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
You still get the error about the customfield_value? If so, are you sure the patch is applied correctly? You can also unpack the zipfile and upload the file manually to the folder corresponding in the zipfile.

The debug log looks OK, just what I see is this 
SELECT custom_parent_id, virtuemart_custom_id FROM n5zqw_virtuemart_customs WHERE `custom_title` = 'Подвой:'
This says
No custom field ID found
So it means that this custom title doesn't seem to exist in the virtuemart_customs table. So that is why it is not being processed.
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
Alezo
Alezo
Accepted Answer Pending Moderation
We've tried manually applying the patch too, but it didn't help I'm afraid. The titles are also in the database.
Maybe we could send you required access details so you can have a look?
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

We've tried manually applying the patch too, but it didn't help I'm afraid
I am unclear about what you see now, do you still get the popup error? I do think the patch worked but that just no data is found.

The titles are also in the database.
Do you get anything when you run 
SELECT custom_parent_id, virtuemart_custom_id FROM n5zqw_virtuemart_customs WHERE `custom_title` = 'Подвой:'
that on the database, for example with PhpMyAdmin?
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
  • Page :
  • 1


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