ERROR - 1054 Unknown column 'p.id' in 'where clause'

Phoca Cart - complex e-commerce extension
baluator
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 19 Jul 2020, 14:59

ERROR - 1054 Unknown column 'p.id' in 'where clause'

Post by baluator »

Hi,
I imported many products and assigned them filter specifications. I created a filter module and set the specification "Restrict specifications to the active category". When I click on Category, everything works, when I click on a subcategory, the message "1054 Unknown column 'p.id' in 'where clause'" appears. Where is the problem?
Thanks for the reply


--------------------
Joomla! 3.9.20
Phoca Cart 3.5.3
PHP Version 7.4.6

Tags:
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: ERROR - 1054 Unknown column 'p.id' in 'where clause'

Post by Jan »

Hi, can you enable DEBUG MODE in Joomla! Global configuration and paste here whole error message?

Thank you, Jan
If you find Phoca extensions useful, please support the project
baluator
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 19 Jul 2020, 14:59

Re: ERROR - 1054 Unknown column 'p.id' in 'where clause'

Post by baluator »

Hallo Jan,
here is a printscreen page with error 1054 and message.

https://imgur.com/8Gy6fT6
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: ERROR - 1054 Unknown column 'p.id' in 'where clause'

Post by Jan »

Hi, thank you for the screenhost, testing now, product table should be included.

Try to download this file:
https://www.phoca.cz/forumfiles/specification.zip

and unzip it to folder:

administrator/components/com_phocacart/libraries/phocacart/specification/ so specification.php file will be overwritten and let me know if it is OK or not.

Thank you, Jan
If you find Phoca extensions useful, please support the project
baluator
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 19 Jul 2020, 14:59

Re: ERROR - 1054 Unknown column 'p.id' in 'where clause'

Post by baluator »

Hi Jan,
thank you for the quick fix. I overwritten the file and now it works properly.

Thank you very much
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: ERROR - 1054 Unknown column 'p.id' in 'where clause'

Post by Jan »

Ok, great to hear it, will be fixed in new version (3.5.4 - now it can be tested as beta on test servers: https://www.phoca.cz/news/1094-phoca-ca ... a-released )

Jan
If you find Phoca extensions useful, please support the project
Post Reply