17.02.2016 15:30
|
|
Colorme
Name: Treichel
07.11.2009
Сообщения: 7
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25938
|
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
|
|
Colorme
Name: Treichel
07.11.2009
Сообщения: 7
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25938
|
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
|
|
aremso
Name: Inese
15.08.2014
Сообщения: 11
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25938
|
Aw: Error 1054
Fixed in
XML Feed export 1.4.1
|
|
23.03.2016 08:12
|
|
aremso
Name: Inese
15.08.2014
Сообщения: 11
|
Aw: Error 1054
webdesigner - 22.03.2016 20:34
Fixed in
XML Feed export 1.4.1
Thank you!!
|
|