Error 1054

17.02.2016 15:30
#1
Colorme
Joomshopping forum user no avatar
Name: Treichel
07.11.2009
Posts: 7
Quote
Error 1054

Hallo,
folgende Fehlermeldung habe ich nachdem ich das Update 3.20 - 4.8 installiert habe:

1054 Unknown column 'pr.image' in 'field list' SQL=SELECT pr.product_id, pr.product_publish, pr.`name_en-GB` as name, pr.`short_description_en-GB` as short_description, man.`name_en-GB` as man_name, GROUP_CONCAT(cat.`name_en-GB` SEPARATOR '<br>') AS namescats, pr.product_ean as ean, pr.product_quantity as qty, pr.image as image, pr.product_price, pr.currency_id, pr.hits, pr.unlimited, pr.product_date_added, pr.label_id FROM `jos_jshopping_products` AS pr LEFT JOIN `jos_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `jos_jshopping_categories` AS cat ON pr_cat.category_id=cat.category_id LEFT JOIN `jos_jshopping_manufacturers` AS man ON pr.product_manufacturer_id=man.manufacturer_id WHERE pr.parent_id=0 GROUP BY pr.product_id order by pr.product_id asc LIMIT 0, 20

Wie kann ich das Problem lösen?
Vielen Dank.


Joomla: 3.4.8
JoomShopping: 4.8.0
PHP: 5.4
 
17.02.2016 16:08
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: Error 1054

https://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/updates.html?lang=en

Component Upgrade 3.20.0 -> 4.8.0 (Before update joomla 2.5-3.0)

Your skip query


ALTER TABLE `#__jshopping_products` ADD `image` VARCHAR( 255 ) NOT NULL;

UPDATE `#__jshopping_products` SET `image` = `product_name_image`;

 
17.02.2016 19:48
#3
Colorme
Joomshopping forum user no avatar
Name: Treichel
07.11.2009
Posts: 7
Quote
Aw: Error 1054

Thank you for your reply. But I've already installed Joomla 3. So I'll have to install the site complete :(

 
17.02.2016 20:18
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: Error 1054

Need execute query

ALTER TABLE `#__jshopping_products` ADD `image` VARCHAR( 255 ) NOT NULL;

UPDATE `#__jshopping_products` SET `image` = `product_name_image`;

(Use phpmyadmin)
#_ - your table prefix

 
22.03.2016 12:41
#5
aremso
Joomshopping forum user no avatar
Name: Inese
15.08.2014
Posts: 11
Quote
Aw: Error 1054

please help. Yesterday I was updated Joomshopping to version 4.12.3, but
Today I am updated Joomla to 3.5 and now I try to do as usualy XML feed eksport (with yours addon), but I see only error:
Обнаружена ошибка.

1054 Unknown column 'prod.product_name_image' in 'field list' SQL=SELECT prod.product_id, prod.currency_id, prod.product_ean, prod.product_quantity, prod.unlimited, prod.product_date_added, prod.product_price, tax.tax_value as tax, prod.product_name_image as image, prod.`name_lv-LV` as name, prod.`short_description_lv-LV` as short_description, prod.`description_lv-LV` as description, categ.category_id, man.`name_lv-LV` as man_name, cat.`name_lv-LV` as categ_name, cat.`category_parent_id` FROM `#__jshopping_products` AS prod LEFT JOIN `#__jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `#__jshopping_categories` as cat on cat.category_id=categ.category_id LEFT JOIN `#__jshopping_taxes` AS tax ON tax.tax_id = prod.product_tax_id LEFT JOIN `#__jshopping_manufacturers` AS man ON man.manufacturer_id = prod.product_manufacturer_id WHERE prod.product_publish = '1' AND cat.category_publish='1' GROUP BY prod.product_id

Help me please!! What I must to do.


Joomla: 3.5
JoomShopping: 4.12.3
PHP: 5.4
Website Url: www.chapchic.eu
 
22.03.2016 20:34
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: Error 1054

Fixed in
XML Feed export 1.4.1

 
23.03.2016 08:12
#7
aremso
Joomshopping forum user no avatar
Name: Inese
15.08.2014
Posts: 11
Quote
Aw: Error 1054

webdesigner - 22.03.2016 20:34
Fixed in
XML Feed export 1.4.1



Thank you!!

 
Copyrights MAXXmarketing GmbH. All Rights Reserved