Getting Error message when clicking All Products

[bubbadan]

Working on a project for a client and now for some reason I get the generic

WARNING: An Error occurred, please refresh the page and try again.
When I click on the "All Products" link.

My error log shows the following:

PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total in /home/alljust/public_html/includes/classes/db/mysql/query_factory.php on line 120

I looked at the file - can't make heads or tales of it and have never touched it.
This just started happening for no reason. (of course there must be a reason, I just have no clue what it could be).

I have not added any new plugins to the site today, and it was working fine yesterday.

The site is of an adult nature so I will not post the link here.

Anyone have any ideas?

If you need more information and/or I may have left out some important info that I am not aware of... please ask nicely as I don't have a thick skin and will cry if you are mean. :)

Thanks

[philip937]

does it happen if you switch to the default template?

[lat9]

Try also using your admin's Tools->Developers Tool Kit, Look-up in all files and set Key or Name to select count(p.products_id) as total and All Files Lookups to "All Files - Catalog". That will identify the file that contains the invalid SQL statement ...

[DrByte]

"select count(p.products_id) as total" is a SERIOUSLY incomplete SQL statement. It would need to at least include a table name to have even partial validity.

The query_factory.php file is ONLY THE MESSENGER. It didn't build the query. It simply RUNS the query.

As others have said, you need to search the rest of your site's files (most likely your plugin files) to find the offending culprit, and fix whatever was broken by the changes you've made since it last worked properly.

[bubbadan]

Thanks all...it must have been some plugin because it works with the basic template. I will figure it out. But odd that it just started after 48 hours...

[philip937]

Seems I'd that there would be any mod with such a drastic error in the code. Where have your sources your mods from? Why not do as per suggested above to find out where this code is located?