22.01.2024 12:42
|
|
mhuber
Name: Manfred
21.05.2011
Posts: 116
|
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
|
|
mhuber
Name: Manfred
21.05.2011
Posts: 116
|
Aw: Shop not working after update to 5.3
1054 - Unknown column 'user_id' in 'field list'
|
|
22.01.2024 13:11
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25965
|
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
|
|
mhuber
Name: Manfred
21.05.2011
Posts: 116
|
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
|
|
mhuber
Name: Manfred
21.05.2011
Posts: 116
|
Aw: Shop not working after update to 5.3
I updated over the admin area
|
|
22.01.2024 13:13
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25965
|
Aw: Shop not working after update to 5.3
Yes.
only
#_ - change to db prefix
|
|
22.01.2024 13:15
|
|
mhuber
Name: Manfred
21.05.2011
Posts: 116
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25965
|
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`;
|
|