Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

13.07.2022 10:30
#1
Philippe91
Joomshopping forum user no avatar
Name: Philippe
03.10.2020
Posts: 41
Quote
Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

Hello again,
Got an update error when uploading 5.0.5 to update my current 5.0.3
Should I just ignore table updates?
Thx
Philippe


Joomla: 4.1.5
JoomShopping: 5.0.3
 
13.07.2022 11:04
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25964
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

how do you update?

 
13.07.2022 11:34
#3
Philippe91
Joomshopping forum user no avatar
Name: Philippe
03.10.2020
Posts: 41
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

Just installing 5.0.5...But browsing the forum for suggestions, I fixed it by updating schemas table where no ref was written about jshopping from the template I use.
Looks good now....

However, since this is a migration "restart from scratch" of an existing Joomla 3- Joomshopping 4.x, I am running, I have the other following issue:

Looking at product page or cart checkout page, it seems that I cannot display attributes in the product info block as I did with JS 4.x...

Attributes are created and available, table is ok but when I look at the code of product_default.php file at line 139, echoing $this->attributes returns 0 whereas I do have at least 15 attributes there...

Looking in the db, I found a jshopping_config table and a jshopping_configs table.
jshopping_config table has absolutely nothing in it whereas jshopping_configs has lots of values but nothing pointing to attributes...

Any idea, please?,

Thanks much

Philippe


Joomla: 4.1.5
JoomShopping: 5.0.5
 
13.07.2022 11:46
#4
Philippe91
Joomshopping forum user no avatar
Name: Philippe
03.10.2020
Posts: 41
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

Sorry...jshopping_config is not empty!
What is the param which sets the attribute to be displayed?

 
13.07.2022 12:15
#5
Philippe91
Joomshopping forum user no avatar
Name: Philippe
03.10.2020
Posts: 41
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

Found admin_show_attributes which is set to 1 but this doesn't tell me why attributes are not returned....

 
14.07.2022 08:10
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25964
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

url?
admin login?
ftp?
(forum privat msg.)

 
14.07.2022 10:26
#7
Philippe91
Joomshopping forum user no avatar
Name: Philippe
03.10.2020
Posts: 41
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

How to send PM?
Thx

 
14.07.2022 10:51
#8
Philippe91
Joomshopping forum user no avatar
Name: Philippe
03.10.2020
Posts: 41
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

Found and sent...

 
15.07.2022 17:13
#9
Philippe91
Joomshopping forum user no avatar
Name: Philippe
03.10.2020
Posts: 41
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

Hello,
Just curious to know if you found anything or if I am making a mistake somewhere....
Thx

Philippe

 
15.07.2022 21:21
#10
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25964
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

Problem in table jshopping_products_attr
no fileds
attr_6,...attr_12


Already added.
My test - > product test.


Letzte Änderung: 15.07.2022 21:23
 
16.07.2022 13:21
#11
Philippe91
Joomshopping forum user no avatar
Name: Philippe
03.10.2020
Posts: 41
Quote
Aw: Duplicate column name 'manufacturer_code' when updating from 5.0.3 to 5.0.5

Thank you sooo much for this!
Don't know how and why the fields were missing from table but I appreciate your fixing this!

Cheers and best regards from (very) hot Paris...

Philippe

 


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.