redheadedal Posted June 4, 2007 Share Posted June 4, 2007 Whenever I try to browse a category I get the following error 1109 - Unknown table 'p' in field list select count(p.products_id) as total order by pd.products_name [TEP STOP] My memory of MYSQL is poor at best. I had a different error (wish I still had the error code) that was a common problem fixed by replacing code in index.php. Any idea what is going on here and where to start? Link to comment Share on other sites More sharing options...
Guest Posted June 4, 2007 Share Posted June 4, 2007 start by checking the changes you did in catalog\index.php Link to comment Share on other sites More sharing options...
user99999999 Posted June 4, 2007 Share Posted June 4, 2007 You need to edit some queries for mySQL 5 compatibility http://www.oscommerce.com/ext/update-20051...l#_Toc119693716 Mainly the order of the from clause should be from (main table) (joins) (additional tables) Several queries are in this order giving the error listed from (main table) (additional tables) (joins) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.