1054 Unknown column "prod.main_category_id" in "list of fields"

10.11.2022 15:12
#1
Xtracat
Joomshopping forum user no avatar
Name: Oleg
02.04.2019
Posts: 3
Quote
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
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
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
#3
Xtracat
Joomshopping forum user no avatar
Name: Oleg
02.04.2019
Posts: 3
Quote
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"

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
#4
Xtracat
Joomshopping forum user no avatar
Name: Oleg
02.04.2019
Posts: 3
Quote
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.

Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"

 
11.11.2022 10:19
#5
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
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
#6
zepelin
Joomshopping forum user no avatar
Name: zahner
13.01.2012
Posts: 31
Quote
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
#7
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"

Enable debug mode Joomla.
Error?

 
22.02.2023 13:28
#8
zepelin
Joomshopping forum user no avatar
Name: zahner
13.01.2012
Posts: 31
Quote
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"

Hi,
See screenshot

Thanks
Aw: 1054 Unknown column "prod.main_category_id" in "list of fields"

 
22.02.2023 20:44
#9
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
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
#10
zepelin
Joomshopping forum user no avatar
Name: zahner
13.01.2012
Posts: 31
Quote
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
#11
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
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
#12
zepelin
Joomshopping forum user no avatar
Name: zahner
13.01.2012
Posts: 31
Quote
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
#13
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
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
#14
vega55
Joomshopping forum user no avatar
Name: Vega Arda
07.12.2022
Posts: 31
Quote
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
 


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.