10.11.2022 15:12
|
|
Xtracat
Name: Oleg
02.04.2019
Posts: 3
|
1054 Unknown column "prod.main_category_id" in "list of fields"
Hello,
when I upgraded from version 5.0.3 to 5.1.1, I got this message on the main page of the site:
1054
Unknown column "prod.main_category_id" in "list of fields"
Also messages in the administrative part of the site:
JInstaller: :Install: SQL Error Duplicate column name 'manufacturer_code'
Extension installation aborted.
Before updating, make sure the update is compatible with your Joomla! mounting.
It is highly recommended that you back up your site's files and database before starting the upgrade.
×
Danger
Component update failed.
What should I require? Change something in the database?
localhost
apache 2.4
Joomla 4.0.1
PHP 7.4
Thank you.
Joomla: 4.0.1 JoomShopping: 5.1.1 PHP: 7.4 MySQL: 5.6 Website Url: localhost
|
|
10.11.2022 20:25
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25853
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
Update Sql manual:
administrator\components\com_jshopping\sql\updates\mysql\5.1.0.sql
|
|
10.11.2022 21:27
|
|
Xtracat
Name: Oleg
02.04.2019
Posts: 3
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
I copied the SQL file from the zip file to a directory on the server. Unfortunately, nothing has changed. The files were the same.
Restarting the server didn't work either.
Maybe there is another solution?
Thank you.
|
|
10.11.2022 21:59
|
|
Xtracat
Name: Oleg
02.04.2019
Posts: 3
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
It looks like I found the problem.
I removed "prod.main_category_id" from ListModel.php file (line 127) located here ...\components\com_jshopping\Model\Productlist\
Now the site is working.
|
|
11.11.2022 10:19
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25853
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
admin - 10.11.2022 20:25
Update Sql manual:
administrator\components\com_jshopping\sql\updates\mysql\5.1.0.sql
Open phpMyAdmin
and
execure query (+ need change prefix #__ => to your ptrefix).
|
|
21.02.2023 22:52
|
|
zepelin
Name: zahner
13.01.2012
Posts: 31
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
admin - 11.11.2022 10:19
admin - 10.11.2022 20:25
Update Sql manual:
administrator\components\com_jshopping\sql\updates\mysql\5.1.0.sql
Open phpMyAdmin
and
execure query (+ need change prefix #__ => to your ptrefix).
Hi,
I have the same problem after update Joomshopping 5.1.2.
If i update sql maunaly i have error 403, and I don't understand your last solution.
Many thanks for your help.
Joomla: 4.2.8 JoomShopping: 5.1.2 PHP: 8.1.15 MySQL: 10.3.35
|
|
22.02.2023 07:33
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25853
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
Enable debug mode Joomla.
Error?
|
|
22.02.2023 13:28
|
|
zepelin
Name: zahner
13.01.2012
Posts: 31
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
Hi,
See screenshot
Thanks
|
|
22.02.2023 20:44
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25853
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
1. version before update?
2. prefix your table?
query ? (in phpmyadmin)
|
|
22.02.2023 23:17
|
|
zepelin
Name: zahner
13.01.2012
Posts: 31
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
1. version before update?
5.0.3 (Works perfectly)
2. prefix your table?
query ? (in phpmyadmin)
Sorry but I don't understand your request.
Regards
|
|
23.02.2023 07:59
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25853
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
1. How did you update JoomShopping (Copy file manual, Update use Joomla ...., )
2. for fix need update table manual
https://www.joomshopping.com/forum/posts/1/15653.html?limitstart=0&lang=en#5
See video example:
https://www.youtube.com/watch?v=hrW_hdTKVUg
Last change: 23.02.2023 08:15
|
|
23.02.2023 13:10
|
|
zepelin
Name: zahner
13.01.2012
Posts: 31
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
Hi,
Solved with your video, thanks a lot for your patience.
PS: I always update extensions via Joomla.
Regards
|
|
23.02.2023 19:49
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25853
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
I always update extensions via Joomla.
-----------------------------------------------
strange error
|
|
03.03.2023 11:46
|
|
vega55
Name: Vega Arda
07.12.2022
Posts: 31
|
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"
You're great Admin, thanks to your video, I ran sql queries to update the tables one by one.
And it turned out to make this mistake because of the invalid date time problem
Joomla: 4 - 4.28 JoomShopping: 5.12 PHP: 7.4
Last change: 03.03.2023 18:00
|
|