Guest Posted March 15, 2007 Posted March 15, 2007 Hi Scott, This error occurrs as soon as I click on a "Manufacturer" in the left hand column:- "Categories Categories 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '16' [TEP STOP]" It also ocurred before I changed the "Let's see whats here now" to "Categories" The right hand of the screen shows the logo of the Manufacturer that was selected. On the other hand if I click on the left hand column "Categories" it brings up a fresh page showing the appropriate items with their pictures on the left of the details correctly but the logo box at the top right is empty. From what I can see as (a non-php programmer) is the calls being listed above are made from the main "new_installations", "catalog", index.php 25kb - (there are two other inactive index.php files 19kb and 25kb that you provided). Help please! Regards, peter_of_stirling Quote
Guest Posted March 17, 2007 Posted March 17, 2007 Hi Scott, This error occurrs as soon as I click on a "Manufacturer" in the left hand column:- "Categories Categories 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '16' [TEP STOP]" It also ocurred before I changed the "Let's see whats here now" to "Categories" The right hand of the screen shows the logo of the Manufacturer that was selected. On the other hand if I click on the left hand column "Categories" it brings up a fresh page showing the appropriate items with their pictures on the left of the details correctly but the logo box at the top right is empty. From what I can see as (a non-php programmer) is the calls being listed above are made from the main "new_installations", "catalog", index.php 25kb - (there are two other inactive index.php files 19kb and 25kb that you provided). Help please! Regards, peter_of_stirling I have since downloaded SPPC Attributes_Revision1 from the Contributions list, and all the little bugs have gone away!!!! That is the error above has gone I can now access bothe Attributes, and Manufacturers without any problems!!!!! Hoping that this will help someone else. Regards, peter_of_stirling Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.