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: 18312
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: 18312
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: 18312
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: 18312
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: 18312
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

 
14.12.2017 12:05
#11
JohannesChristoph
Joomshopping forum user no avatar
Name: Johannes
09.03.2013
Posts: 13
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

Where can I find: JoomShopping-4.16.3_fix.zip ?

Johannes


Joomla: 3.8.3
JoomShopping: 4.16.2
PHP: 7.0.25
Website Url: https://www.alpakas-vom-silberberg.de/
 
14.12.2017 13:43
#12
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18312
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

https://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/1/12416.html?lang=en#6

 
14.12.2017 14:24
#13
JohannesChristoph
Joomshopping forum user no avatar
Name: Johannes
09.03.2013
Posts: 13
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

Danke, ich habe es jetzt verstanden.


Letzte Änderung: 14.12.2017 14:25
 
Copyrights MAXXmarketing GmbH. All Rights Reserved