Shop not working after update to 5.3

22.01.2024 12:42
#1
mhuber
User mhuber
Name: Manfred
21.05.2011
Posts: 116
Quote
Shop not working after update to 5.3

Please helf. My shop is not working anymore after updating from 5.2 to 5.3


Joomla: Joomla 4.4.0
JoomShopping: 5.2.1
Website Url: https://vet-tcm.de/shop
 
22.01.2024 12:45
#2
mhuber
User mhuber
Name: Manfred
21.05.2011
Posts: 116
Quote
Aw: Shop not working after update to 5.3

1054 - Unknown column 'user_id' in 'field list'

 
22.01.2024 13:11
#3
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25965
Quote
Aw: Shop not working after update to 5.3

how did you update?

https://www.joomshopping.com/forum/posts/1/16329.html?lang=en#2

 
22.01.2024 13:12
#4
mhuber
User mhuber
Name: Manfred
21.05.2011
Posts: 116
Quote
Aw: Shop not working after update to 5.3

MYSQL:
ALTER TABLE `#__jshopping_cart_temp` ADD `user_id` INT NOT NULL default 0 AFTER `id_cookie`;
Right?

 
22.01.2024 13:13
#5
mhuber
User mhuber
Name: Manfred
21.05.2011
Posts: 116
Quote
Aw: Shop not working after update to 5.3

I updated over the admin area

 
22.01.2024 13:13
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25965
Quote
Aw: Shop not working after update to 5.3

Yes.

only

#_ - change to db prefix

 
22.01.2024 13:15
#7
mhuber
User mhuber
Name: Manfred
21.05.2011
Posts: 116
Quote
Aw: Shop not working after update to 5.3

That's what I did and it seem to work.
Is this the only table to change?

 
22.01.2024 14:02
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25965
Quote
Aw: Shop not working after update to 5.3

5.3.0.sql

ALTER TABLE `#__jshopping_products_extra_fields` ADD `product_uniq_val` TINYINT NOT NULL default 0;
ALTER TABLE `#__jshopping_products` ADD `real_ean` varchar(16) NOT NULL default '';
ALTER TABLE `#__jshopping_order_item` ADD `real_ean` varchar(16) NOT NULL default '';
ALTER TABLE `#__jshopping_products_attr` ADD `real_ean` varchar(16) NOT NULL default '';
ALTER TABLE `#__jshopping_cart_temp` ADD `user_id` INT NOT NULL default 0 AFTER `id_cookie`;

 


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.