Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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

Posted
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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...