Database error - unknown column

13.01.2017 23:37
#1
zalupa2
Joomshopping forum user no avatar
Name: Zalupa
04.11.2015
Posts: 2
Quote
Database error - unknown column

Hi there.
How to solve this problem:
1054 - Unknown column 'prod.min_count_product' in 'field list' SQL=SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.min_count_product FROM `#__jshopping_products` AS prod LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id) WHERE pr_cat.category_id=1 AND prod.product_publish=1 AND prod.access IN (1,1,5) ORDER BY name ASC


Joomla: 3.6.5
JoomShopping: 4.15.1
PHP: php 7
MySQL: mysql 5.6
 
14.01.2017 13:07
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 17805
Quote
Aw: Database error - unknown column

Problem in addon / plugin.

addon / plugin installed?

 
27.01.2017 18:55
#3
jmperkins
Joomshopping forum user no avatar
Name: Jason
04.02.2015
Posts: 3
Quote
Aw: Database error - unknown column

I am having the same type of error:
Error: 1054 - Unknown column 'category_id' in 'field list' SQL=INSERT INTO `#__jshopping_order_item` (`order_id`,`product_id`,`product_ean`,`product_name`,`product_quantity`,`product_item_price`,`product_tax`,`product_attributes`,`product_freeattributes`,`attributes`,`freeattributes`,`extra_fields`,`files`,`weight`,`thumb_image`,`manufacturer`,`delivery_times_id`,`vendor_id`,`category_id`) VALUES ('37','19','','Perspective grids Set of 8','1','24.95','19.00','','','a:0:{}','a:0:{}','','a:0:{}','0.0000','thumb_normalpersp2.jpg','','0','1','2')

I updated the addon to test database structure.

Any help would be appreciated.


Joomla: 3.6.5
JoomShopping: 4.15.1
PHP: 7
MySQL: 5.6.35
Website Url: http://www.glasshousegraphics.com
 
27.01.2017 19:38
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 17805
Quote
Aw: Database error - unknown column

Update need STEP to STEP!

inastal Component Update 4.14.3 -> 4.15.0

 
27.01.2017 20:37
#5
jmperkins
Joomshopping forum user no avatar
Name: Jason
04.02.2015
Posts: 3
Quote
Aw: Database error - unknown column

That worked!

Thank you so much.

 
15.06.2017 22:36
#6
dewebmeester
User dewebmeester
Name: Meindert
27.05.2013
Posts: 17
Quote
Aw: Database error - unknown column

Hi there, have a simular problem after updating from 4.6.0 - think I took all the update steps till 4.16.2 but maybe I skipped a step - can not figure out which one. Error: 1054 Unknown column 'scriptname' in 'field list'.
Should I go back to a backup and start all over or do you have a more simple solution?
Thanks,
kind regards,
Meindert


Joomla: 3.7
JoomShopping: 4.16.2
PHP: 7
Website Url: epgsystems.eu
 
15.06.2017 22:55
#7
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 17805
Quote
Aw: Database error - unknown column

Simple - Add filter in database

Use phpMyAdmin
add
fileld scriptname

 
16.06.2017 08:51
#8
dewebmeester
User dewebmeester
Name: Meindert
27.05.2013
Posts: 17
Quote
Aw: Database error - unknown column

Ok, thanks. But to which table should I add field scriptname? Which datatype?

 
16.06.2017 10:20
#9
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 17805
Quote
Aw: Database error - unknown column

Search in Update
https://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/updates.html

Example
Component Update 4.14.3 -> 4.15.0

update.sql

alter table `#__jshopping_order_item` add column `category_id` int(11) NOT NULL;

 
16.06.2017 11:40
#10
dewebmeester
User dewebmeester
Name: Meindert
27.05.2013
Posts: 17
Quote
Aw: Database error - unknown column

Thanks again for your quick reply but sorry, it is not that clear. Error is:
Error: 1054 Unknown column 'scriptname' in 'field list'. I asked if I should redo the complete update process (from 4.6.0 - step by step - as I have done) or if there is a more simple solution.
You replied I should add a filter or field (?) 'scriptname' - my question was: to which table. After this you adviced me to go through the list of updates (throught the complete list from 4.6.0 ?) and seek for 'scriptname' in de update.sql file? This would mean: download the complete list of updates from 4.6.0 - unzip and open all update.sql and seek for 'scriptname'? And: should I install this update if I find 'scripname or should I just import or run the update.sql. Isn't it easier to re-run the complete update process? Or did I totally misunderstand your advice?
Hope to hear from you,
kind regards


Letzte Änderung: 16.06.2017 11:41
 
16.06.2017 12:06
#11
dewebmeester
User dewebmeester
Name: Meindert
27.05.2013
Posts: 17
Quote
Aw: Database error - unknown column

Went through complete list and searched in update.sql (not in all archives present) and could not find any 'scriptname'.

 
16.06.2017 12:16
#12
dewebmeester
User dewebmeester
Name: Meindert
27.05.2013
Posts: 17
Quote
Aw: Database error - unknown column

Ok, think I solved it - found solution in the install.sql - not in the update.sql - in install.sql I found:
"CREATE TABLE IF NOT EXISTS `#__jshopping_payment_method` (
`payment_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`payment_code` VARCHAR(32) NOT NULL ,
`payment_class` VARCHAR(100) NOT NULL,
`scriptname` VARCHAR(100) NOT NULL,\
......
"
So manually added filed `scriptname` after `payment_class` with data type VARCHAR in table #__jshopping_payment_method and the orders are back. Hope this will help someone else.
Kind regards,
Meindert

 
Copyrights MAXXmarketing GmbH. All Rights Reserved
Deutsch (DE-CH-AT)English (United Kingdom)