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

[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

[Jan]

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

Thank you, Jan

[baluator]

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

https://imgur.com/8Gy6fT6

[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

[baluator]

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

Thank you very much

[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