1054 Error?

[bajanboost]

I have installed OsCommerce successfully. However, when I click on a category (http://localhost/osc/index.php?cPath=36_22), I am getting the error quoted below.

Does anyone know how I can fix it?

 

I have been told by members on these forums that it is "the classical runsin as site that uses mysql v4 commands on a server running mysql5" and "somewhere in your code the "splitPageResults" function is called with wrong parameters."

I have not had any solutions as yet. I search the contributions and was unable to find a fix for my site. I tried several different methods but have not found one specific to my problem. Anyone have any advice?

 

 

 

1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '22'

[TEP STOP]

[bajanboost]

I found this contribution and followed it;

 

http://www.oscommerce.com/community/contributions,4654

 

However, I could not find this:

 

-------------------------------------------------------------------
In catalog/advanced_search_result.php 

Find this


$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

----------------------------------------
and replace with this


$from_str = "from ((" . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

 

 

The closest I came to finding it was:

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id";