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)
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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
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?
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
Log in to reply to this topic.