Error when updating from 4.16.2 - to 4.16.3

02.10.2017 10:29
#1
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Error when updating from 4.16.2 - to 4.16.3

Hi Joomshoping.

I have try to install the 4.16.3 file, but I get the following error:
Warning

JInstaller: :Install: Error SQL Duplicate column name 'manufacturer_code'
Extension Update: SQL error processing query: DB function failed with error number 1060
Duplicate column name 'manufacturer_code'
SQL =
ALTER TABLE `#__jshopping_products` ADD `manufacturer_code` VARCHAR(32) NOT NULL AFTER `product_ean`;


What can I do to change that?

Kind regards
Jacobsen

 
02.10.2017 13:29
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18088
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

You used the old type of update.

 
02.10.2017 13:49
#3
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

I use the file
https://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/JoomShopping-4.16.3.zip.html?lang=en

Kind regrards
Jacobsen

 
02.10.2017 14:04
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18088
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

Before (4.16.1...) - you used the old type of update.

 
02.10.2017 15:41
#5
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

Yes..... But what now ???


Kind regards
Jacobsen

 
02.10.2017 16:59
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18088
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

download JoomShopping-4.16.3.zip

unpack JoomShopping-4.16.3.zip

edit
admin\sql\updates\mysql\4.16.1.sql

delete
ALTER TABLE `#__jshopping_products` ADD `manufacturer_code` VARCHAR(32) NOT NULL AFTER `product_ean`;
ALTER TABLE `#__jshopping_order_item` ADD `manufacturer_code` VARCHAR(32) NOT NULL AFTER `product_ean`;
ALTER TABLE `#__jshopping_products_attr` ADD `manufacturer_code` VARCHAR(32) NOT NULL AFTER `ean`;

archive to JoomShopping-4.16.3_fix.zip


Letzte Änderung: 02.10.2017 16:59
 
02.10.2017 17:16
#7
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

Will it be a problem in the future?

can I used the next update, with no problem ?
Will there be a changes_4.16.2_4.16.3.patch like
https://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/33/3844.html?lang=en&start=20#28 ??


Kind regards
Jacobsen


Letzte Änderung: 02.10.2017 17:19
 
03.10.2017 08:08
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18088
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

JoomShopping-4.16.3_fix.zip - installed?

changes_4.16.2_4.16.3.patch - uploaded.

 
03.10.2017 17:20
#9
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 355
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

JoomShopping-4.16.3_fix.zip - installed

WERE IS changes_4.16.2_4.16.3.patch - uploaded.?

Kind regards
Jacobsen

 
03.10.2017 21:10
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18088
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

https://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/33/3844.html?lang=en&start=20#28

 
Copyrights MAXXmarketing GmbH. All Rights Reserved