JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')

17.12.2022 23:06
#1
vega55
Joomshopping forum user no avatar
Name: Vega Arda
07.12.2022
Posts: 31
Quote
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
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25850
Quote
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
#3
vega55
Joomshopping forum user no avatar
Name: Vega Arda
07.12.2022
Posts: 31
Quote
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
#4
Aleksxander
Joomshopping forum user no avatar
Name: Alekxander
28.12.2017
Posts: 10
Quote
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
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')

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
#5
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25850
Quote
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
#6
Aleksxander
Joomshopping forum user no avatar
Name: Alekxander
28.12.2017
Posts: 10
Quote
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?
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')
Aw: JoomShopping-5.1.1 Update error (Error SQL Duplicate column name 'manufacturer_code')


Last change: 05.05.2023 16:32
 
05.05.2023 16:39
#7
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25850
Quote
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
#8
Aleksxander
Joomshopping forum user no avatar
Name: Alekxander
28.12.2017
Posts: 10
Quote
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
#9
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25850
Quote
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
#10
Aleksxander
Joomshopping forum user no avatar
Name: Alekxander
28.12.2017
Posts: 10
Quote
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

 


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.