Hello CSVI,
I am getting a strange SQL Error that stops my import.
" 1054 Unknown column 'custom_price' in 'field list' SQL=INSERT INTO sebrasho_virtuemart_product_custom_plg_customsforall (customsforall_value_id,virtuemart_product_id,custom_price,customfield_id) VALUES (1,35469,'0',6051),(2,35469,'0',6051),(3,35469,'0',6051),(4,35469,'0',6051)"
It seems to be getting caught up on some field called "custom_Price" but my CSV file doesn't have any field called 'custom_price' so I'm not sure how to fix it.
I am also using the Custom Fields For All plugin, which has successfully uploaded many items with custom fields so I don't know if that relate to it or not.
I went and looked at that table in the DB and sure enough there is no column called 'custom_price' so it seems that whatever script handles the import is adding that column in.
UPDATE:
I have spoken with the support for Custom Fields For all and they have confirmed that the column 'custom_price' is longer used on the current version of the plugin. So CSVI should not being trying to add that column in the SQL statement. So can you tell me which file contains the script that is using that SQL statement so that I can remove that column from the INSERT command?
Or please provide a patch so that it will work.
Thanks a lot for your help!
Hello,
they have confirmed that the column 'custom_price' is longer used
I am aware of that as they have informed me as well of this change. The change has also been implemented in CSVI 5.20 Pro.
So the question is which version of CSVI are you using? No need to start hacking CSVI ;)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Roland,
Thank you for your response, I just checked and I am using version 5.21.2 Pro.
Which I believe it has successfully uploaded some items that have custom fields, it seems that just half way through the CSV file this error started occurring. And I can't find anything unique about the items that should be effecting it.
Thanks for your thoughts on the matter.
Unknown column 'process' in 'field list' SQL=SELECT name AS text, id AS value, process FROM zu40r_csvi_template_settings ORDER BY name
Оформил подписку, установил на Joomla 3 + Virtuemart 3 и вот эта ошибка, help me!
Thanks ites0444, are you suggesting that as a fix or is that just problem you are also having?
ОК, эту ошибку исправил - добавил папки com_scvi and debug in ftp.
Теперь когда нажимаю fix database
Duplicate column name 'combine_char' SQL=ALTER TABLE zu40r_csvi_template_fields CHANGE combine combine_char VARCHAR(5) NOT NULL DEFAULT '' COMMENT 'The character(s) to combine the fields' AFTER process;
- это ошибка? или все ок?
Hello alex, strange you get the error with 5.21.2.
Hello ites, you will need to post your question in English.
@all: please post the information requested at the top under Looking for a useful answer I will need this to analyze what happens during the import. Thanks.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Roland,
Never mind I just saw your response, sorry about that!
Hello Roland, sorry I didnt see your last post for some reason. Here the additional requested information is. Hopefully this helps.
CSVI version: 5.21.2
Virtuemart version : here is the code I got from the version.php ** @var int Release Number */
static $RELEASE = '2.9.9e'; So it looks like it is version 2.9.9e I guess.
Error message: " 1054 Unknown column 'custom_price' in 'field list' SQL=INSERT INTO sebrasho_virtuemart_product_custom_plg_customsforall (customsforall_value_id,virtuemart_product_id,custom_price,customfield_id) VALUES (1,35469,'0',6051),(2,35469,'0',6051),(3,35469,'0',6051),(4,35469,'0',6051)"
Joomla! Version: Joomla! 3.3.6 Stable
Okay the debug is attached now
Update: I deleted a few lines and tried again and it upload a few hundred lines with custom fields, then the exact same error came up again, it almost seems random.
Hello,
I have been checking this further and I see this error happens because CSVI sees that your Custom Fields For All version is lower than 2.0. CSVI reads the version of CF4ALL from the database and I am going to guess that there is no entry for CF4ALL in the database or an outdated version. You can check this yourself by running this query in PhpMyAdmin:
select s.version_id
from jos_schemas as s
left join jos_extensions as e ON e.extension_id = s.extension_id
where type = 'plugin'
and element = 'customfieldsforall'
just make sure to change jos to your own prefix.
Let me know what you find.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Roland,
Thanks for checking on that, I ran the query but it returned version_id: 2.0.3 so if that is correct, it seems it is higher than 2.0 so I'm not sure what to do now, please let me know what else we can do to try to solve this issue.
Thank you for you continued efforts.
Hello Alex,
Please email or private message me the URL for the site and FTP including the login details and a sample file I can use for test import. I will check directly on the site what is going on.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hey Alex,
I have checked the issue and found in some circumstances the Custom Fields For All version is unknown, this causes the old code to run. I have fixed this on your site and the fix will be included in the next release.
@ites0444 you can add this code
$this->cf4allVersion();
after line 2047 in the file administrator\components\com_csvi\models\com_virtuemart\import\productimport.php. All should be good after that.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Okay, well it seems it be working now.
Thank you very much for your diligent effort in solving this issue. My review of your product will certainly reflect the quality of support I have received.
Thanks!
Log in to reply to this topic.