02.10.2017 10:29
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25856
|
Aw: Error when updating from 4.16.2 - to 4.16.3
You used the old type of update.
|
|
02.10.2017 13:49
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25856
|
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
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
Aw: Error when updating from 4.16.2 - to 4.16.3
Yes..... But what now ???
Kind regards
Jacobsen
|
|
02.10.2017 16:59
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25856
|
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
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25856
|
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
|
|
jacobsen
Name: john
15.02.2011
Posts: 410
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25856
|
|
|
14.12.2017 12:05
|
|
JohannesChristoph
Name: Johannes
09.03.2013
Posts: 20
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25856
|
|
|
14.12.2017 14:24
|
|
JohannesChristoph
Name: Johannes
09.03.2013
Posts: 20
|
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
|
|