17.12.2022 23:06
|
|
vega55
Name: Vega Arda
07.12.2022
Posts: 31
|
JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
Hi Admin
When I try to update Joomshopping I get the following error message
JInstaller: :Install: Error SQL Duplicate column name 'manufacturer_code'
Extension installation aborted.
Joomshopping version :5.0.3
|
|
18.12.2022 16:03
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25850
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
Problem in 'schemas' version in Joomla
table
..._schemas
extension_id - in from table
..._extensions
---------
or
send me acces to phpMyAdmin
|
|
18.12.2022 19:02
|
|
vega55
Name: Vega Arda
07.12.2022
Posts: 31
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
Thank you Admin
I removed the incompatible extensions and on localhost
|
|
05.05.2023 14:00
|
|
Aleksxander
Name: Alekxander
28.12.2017
Posts: 10
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
admin - 18.12.2022 16:03
Problem in 'schemas' version in Joomla
table
..._schemas
extension_id - in from table
..._extensions
---------
or
send me acces to phpMyAdmin
I have the same error after updating three rows in a table
vega55 - 18.12.2022 19:02
Thank you Admin
I removed the incompatible extensions and on localhost
Please tell me how did you solve the problem?
Last change: 05.05.2023 14:01
|
|
05.05.2023 15:53
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25850
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
1. search extension_id from table extensions
SELECT * FROM `nlg49_extensions` WHERE `element` LIKE 'com_jshopping'
2. add extension_id / current JoomShopping version in table
nlg49_schemas
|
|
05.05.2023 16:30
|
|
Aleksxander
Name: Alekxander
28.12.2017
Posts: 10
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
admin - 05.05.2023 15:53
1. search extension_id from table extensions
SELECT * FROM `nlg49_extensions` WHERE `element` LIKE 'com_jshopping'
2. add extension_id / current JoomShopping version in table
nlg49_schemas
I already deleted one line. it was an unsupported import extension, old version. Need to add as in the picture? Right?
Last change: 05.05.2023 16:32
|
|
05.05.2023 16:39
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25850
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
Yes. Your version 5.1.3?
|
|
05.05.2023 16:59
|
|
Aleksxander
Name: Alekxander
28.12.2017
Posts: 10
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
admin - 05.05.2023 16:39
Yes. Your version 5.1.3?
Joomshopping 5.0.3 update to 5.1.3
|
|
05.05.2023 17:06
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25850
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
Set in nlg49_schemas 5.0.3
|
|
06.05.2023 11:23
|
|
Aleksxander
Name: Alekxander
28.12.2017
Posts: 10
|
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
admin - 05.05.2023 17:06
Set in nlg49_schemas 5.0.3
thank you very much
|
|