Images are not displayed after upgrade

24.10.2014 09:46
#1
razi
Joomshopping forum user no avatar
Name: raz
10.10.2014
Posts: 11
Quote
Images are not displayed after upgrade

I move my shop to local to do these operation,I upgrade my shop to 4.6 but Images are not displayed in frontend and backend,
my shop was 3.4.2 and at first I update using "Component Update FULL -> 3.18.1 (min. 3.2.0)"
but I get this error:



DB function failed with error number 1060
Duplicate column name 'ordering' SQL=alter table manrq_jshopping_categories add `ordering` int(3) NOT NULL;
DB function failed with error number 1054
Unknown column 'category_ordering' in 'field list' SQL=update manrq_jshopping_categories set ordering=category_ordering;
DB function failed with error number 1060
Duplicate column name 'product_list_show_product_code' SQL=alter table manrq_jshopping_config add `product_list_show_product_code` TINYINT(1) NOT NULL, add `radio_attr_value_vertical` TINYINT(1) NOT NULL, add `attr_display_addprice` TINYINT(1) NOT NULL, add `use_ssl` TINYINT(1) NOT NULL, add `product_list_show_price_description` TINYINT(1) NOT NULL, add `display_button_print` TINYINT(1) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'independent' SQL=alter table manrq_jshopping_attr add `independent` TINYINT( 1 ) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'weight' SQL=alter table manrq_jshopping_products_attr add `weight` DECIMAL(12,4) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'hide_shipping_step' SQL=alter table manrq_jshopping_config add `hide_shipping_step` TINYINT(1) NOT NULL, add `hide_payment_step` TINYINT(1) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'image_resize_type' SQL=alter table manrq_jshopping_config add `image_resize_type` TINYINT(1) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'access' SQL=ALTER TABLE `manrq_jshopping_categories` ADD COLUMN `access` int( 3 ) NOT NULL DEFAULT '1';
DB function failed with error number 1060
Duplicate column name 'parent_id' SQL=alter table `manrq_jshopping_products` add column `parent_id` int(11) NOT NULL, add column `currency_id` int(4) NOT NULL default '0', ADD COLUMN `access` int( 3 ) NOT NULL DEFAULT '1';
DB function failed with error number 1060
Duplicate column name 'name' SQL=alter table `manrq_jshopping_products_images` add column `name` varchar(255) NOT NULL default '', add column `ordering` TINYINT(4) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'product_show_manufacturer' SQL=ALTER TABLE `manrq_jshopping_config` ADD COLUMN `product_show_manufacturer` tinyint( 1 ) NOT NULL , ADD COLUMN `use_extend_attribute_data` tinyint( 1 ) NOT NULL , ADD COLUMN `product_list_show_price_default` tinyint( 1 ) NOT NULL , ADD COLUMN `product_list_show_qty_stock` tinyint( 1 ) NOT NULL , ADD COLUMN `product_show_qty_stock` tinyint( 1 ) NOT NULL , ADD COLUMN `displayprice` tinyint( 1 ) NOT NULL , ADD COLUMN `use_decimal_qty` tinyint( 1 ) NOT NULL , ADD COLUMN `ext_tax_rule_for` tinyint( 1 ) NOT NULL , ADD COLUMN `display_reviews_without_confirm` tinyint( 1 ) NOT NULL , ADD COLUMN `manufacturer_sorting` tinyint( 1 ) NOT NULL, ADD COLUMN `admin_show_units` TINYINT(1) NOT NULL, ADD COLUMN `main_unit_weight` TINYINT(3) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'home' SQL=alter table `manrq_jshopping_users` add column `home` VARCHAR( 20 ) NOT NULL, add column `apartment` VARCHAR( 20 ) NOT NULL, add column `d_home` VARCHAR( 20 ) NOT NULL, add column `d_apartment` VARCHAR( 20 ) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'image' SQL=alter table `manrq_jshopping_payment_method` add column `image` VARCHAR(255) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'published' SQL=alter table `manrq_jshopping_shipping_method` add column `published` tinyint(1) NOT NULL default '0', add column `payments` varchar(255) NOT NULL default '', add column `image` VARCHAR(255) NOT NULL, add column `ordering` int(6) NOT NULL default '0';
DB function failed with error number 1060
Duplicate column name 'params' SQL=alter table `manrq_jshopping_shipping_method_price` add column `params` text NOT NULL;
DB function failed with error number 1060
Duplicate column name 'thumb_image' SQL=alter table `manrq_jshopping_order_item` add column `thumb_image` varchar(255) NOT NULL default '';
DB function failed with error number 1060
Duplicate column name 'home' SQL=alter table `manrq_jshopping_orders` add column `home` VARCHAR( 20 ) NOT NULL, add column `apartment` VARCHAR( 20 ) NOT NULL, add column `d_home` VARCHAR( 20 ) NOT NULL, add column `d_apartment` VARCHAR( 20 ) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'old_price' SQL=ALTER TABLE `manrq_jshopping_products_attr` ADD COLUMN `old_price` decimal( 12, 2 ) NOT NULL , ADD COLUMN `ext_attribute_product_id` int( 11 ) NOT NULL ;
DB function failed with error number 1060
Duplicate column name 'type' SQL=ALTER TABLE `manrq_jshopping_products_extra_fields` ADD COLUMN `type` tinyint( 1 ) NOT NULL, ADD COLUMN `group` tinyint( 4 ) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'middlename' SQL=ALTER TABLE `manrq_jshopping_vendors` ADD COLUMN `middlename` varchar( 255 ) NOT NULL , ADD COLUMN `benef_bank_info` varchar( 64 ) NOT NULL , ADD COLUMN `benef_bic` varchar( 64 ) NOT NULL , ADD COLUMN `benef_conto` varchar( 64 ) NOT NULL , ADD COLUMN `benef_payee` varchar( 64 ) NOT NULL , ADD COLUMN `benef_iban` varchar( 64 ) NOT NULL , ADD COLUMN `benef_swift` varchar( 64 ) NOT NULL , ADD COLUMN `interm_name` varchar( 64 ) NOT NULL , ADD COLUMN `interm_swift` varchar( 64 ) NOT NULL , ADD COLUMN `identification_number` varchar( 64 ) NOT NULL , ADD COLUMN `tax_number` varchar( 64 ) NOT NULL , ADD COLUMN `additional_information` text NOT NULL , ADD COLUMN `main` tinyint( 1 ) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'type' SQL=ALTER TABLE `manrq_jshopping_free_attr` ADD COLUMN `type` tinyint( 3 ) NOT NULL;
DB function failed with error number 1062
Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `manrq_jshopping_shipping_ext_calc` (`id`, `name`, `alias`, `description`, `params`, `shipping_method`, `published`, `ordering`) VALUES (1, 'StandartWeight', 'sm_standart_weight', 'StandartWeight', '', '', 1, 1);
DB function failed with error number 1060
Duplicate column name 'add_price_unit_id' SQL=alter table `manrq_jshopping_products` ADD COLUMN `add_price_unit_id` int(3) NOT NULL default '0';
DB function failed with error number 1060
Duplicate column name 'create_alias_product_category_auto' SQL=alter table `manrq_jshopping_config` ADD COLUMN `create_alias_product_category_auto` TINYINT(1) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'allcats' SQL=alter table `manrq_jshopping_attr` ADD COLUMN `allcats` tinyint(1) NOT NULL default '1', ADD COLUMN `cats` text NOT NULL;
DB function failed with error number 1060
Duplicate column name 'other_config' SQL=alter table `manrq_jshopping_config` ADD COLUMN `other_config` TEXT NOT NULL;
DB function failed with error number 1060
Duplicate column name 'delivery_times_id' SQL=alter table `manrq_jshopping_order_item` ADD COLUMN `delivery_times_id` int(4) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'shipping_tax' SQL=alter table `manrq_jshopping_orders` ADD COLUMN `shipping_tax` DECIMAL(8,2) NOT NULL, ADD COLUMN `payment_tax` DECIMAL(8,2) NOT NULL, ADD COLUMN `delivery_times_id` int(11) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'name' SQL=alter table `manrq_jshopping_addons` ADD COLUMN `name` varchar(255) NOT NULL, ADD COLUMN `uninstall` varchar(255) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'delivery_times_id' SQL=alter table `manrq_jshopping_shipping_method_price` ADD COLUMN `delivery_times_id` int(11) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'cart_display_extra_fields' SQL=alter table `manrq_jshopping_config` ADD COLUMN `cart_display_extra_fields` TEXT NOT NULL;
DB function failed with error number 1060
Duplicate column name 'extra_fields' SQL=alter table `manrq_jshopping_order_item` ADD COLUMN `extra_fields` TEXT NOT NULL;
DB function failed with error number 1060
Duplicate column name 'days' SQL=alter table `manrq_jshopping_delivery_times` add column `days` DECIMAL(8,2) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'delivery_order_depends_delivery_product' SQL=alter table `manrq_jshopping_config` add column `delivery_order_depends_delivery_product` TINYINT(1) NOT NULL, add column `show_delivery_time_step5` TINYINT(1) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'delivery_time' SQL=alter table `manrq_jshopping_orders` add column `delivery_time` VARCHAR(100) NOT NULL, add column `coupon_id` int(11) NOT NULL;
DB function failed with error number 1060
Duplicate column name 'invoice_date' SQL=/* --- jshopping_orders --- */ alter table manrq_jshopping_orders add column `invoice_date` DATETIME NOT NULL;



but there wasn't any problm in images, but after upgrade to joomla 3 and joomshopping 4, images of product disappered.


Joomla: 2.5.24
JoomShopping: 2.4.2
PHP: 5.4.27
MySQL: 5.5.36
 
24.10.2014 10:14
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Images are not displayed after upgrade

Use
Component Upgrade 3.18.1 -> 4.6.0


Letzte Ă„nderung: 24.10.2014 10:14
 
24.10.2014 10:25
#3
razi
Joomshopping forum user no avatar
Name: raz
10.10.2014
Posts: 11
Quote
Aw: Images are not displayed after upgrade

I used "Component Upgrade 3.18.1 -> 4.6.0 " to upgrade, but images diappered

 
24.10.2014 11:12
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Images are not displayed after upgrade

Try again

 
24.10.2014 11:35
#5
razi
Joomshopping forum user no avatar
Name: raz
10.10.2014
Posts: 11
Quote
Aw: Images are not displayed after upgrade

I downloaded the upgrade package again,I tried it again
I got this error:

DB function failed with error number 1060
Duplicate column name 'image' SQL=ALTER TABLE `manrq_jshopping_products` ADD `image` VARCHAR( 255 ) NOT NULL;



and in about us I saw that the version is 4.2.2

 
24.10.2014 12:28
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Images are not displayed after upgrade

url?

 
24.10.2014 18:20
#7
razi
Joomshopping forum user no avatar
Name: raz
10.10.2014
Posts: 11
Quote
Aw: Images are not displayed after upgrade

I transfer my site to local to do upgrade,
I noticed that in new version joomshopping use image with thumb_org_ perfix, but in old version it uses
thumb_ perfix to access the image, and after upgrade it doesn't create thumbnail again.

 
24.10.2014 21:35
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Images are not displayed after upgrade

I do not understand you.

 
Copyrights MAXXmarketing GmbH. All Rights Reserved