Categories
View Replies (13)

Resolved Unknown column 'custom_price' in 'field list' SQL=

  1. alexr451
    alexr451
  2. RO CSVI
  3. Saturday, 30 May 2015
  4.  Subscribe via email
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!
0
Responses (13)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
alexr451
alexr451
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 2
ites0444
ites0444
Accepted Answer Pending Moderation
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!
  1. more than a month ago
  2. RO CSVI
  3. # 3
alexr451
alexr451
Accepted Answer Pending Moderation
Thanks ites0444, are you suggesting that as a fix or is that just problem you are also having?
  1. more than a month ago
  2. RO CSVI
  3. # 4
ites0444
ites0444
Accepted Answer Pending Moderation
ОК, эту ошибку исправил - добавил папки 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`;

- это ошибка? или все ок?
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
alexr451
alexr451
Accepted Answer Pending Moderation
Hello Roland,

Never mind I just saw your response, sorry about that!
  1. more than a month ago
  2. RO CSVI
  3. # 7
alexr451
alexr451
Accepted Answer Pending Moderation
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.
Attachments (1)
com_csvi.log.1433277272.zip
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 9
alexr451
alexr451
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 10
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 11
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 12
alexr451
alexr451
Accepted Answer Pending Moderation
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!
  1. more than a month ago
  2. RO CSVI
  3. # 13
  • Page :
  • 1


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