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 » 15 Sep 2020, 13:13

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: 43748
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 17 Sep 2020, 12:16

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 » 17 Sep 2020, 12:30

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

https://imgur.com/8Gy6fT6

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

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

Post by Jan » 17 Sep 2020, 13:10

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 » 17 Sep 2020, 14:35

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: 43748
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan » 22 Sep 2020, 12:32

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