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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19652
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19652
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19652
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. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.