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: 410
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25856
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: 410
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25856
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: 410
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25856
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


Last change: 02.10.2017 16:59
 
02.10.2017 17:16
#7
jacobsen
Joomshopping forum user no avatar
Name: john
15.02.2011
Posts: 410
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


Last change: 02.10.2017 17:19
 
03.10.2017 08:08
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25856
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: 410
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25856
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: 20
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25856
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: 20
Quote
Aw: Error when updating from 4.16.2 - to 4.16.3

Danke, ich habe es jetzt verstanden.


Last change: 14.12.2017 14:25
 


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.