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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25857
Quote
Aw: Images are not displayed after upgrade

Use
Component Upgrade 3.18.1 -> 4.6.0


Last change: 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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25857
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25857
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25857
Quote
Aw: Images are not displayed after upgrade

I do not understand 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.