Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error Problem. Cant figure out. Please Help.


surajk42

Recommended Posts

Hi

 

I am getting this error whenever anyone clicks any catagory on my website. http://www.bollywoodbest.com

 

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 = '25'

 

[TEP STOP]

 

 

Please Help!

Thanks in Advance!

Link to comment
Share on other sites

Download the latest bug fix release and follow the upgrade path :)

 

Matti

 

Hello,

I also get the same error, even after downloading the lastes bug fix release:

 

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 = '23'

 

[TEP STOP]

 

This is what the hosting company says:

 

We have upgraded MySQL on all servers to version 5.0.18. Although we have taken every measure to ensure the new version is backward compatible with the previous one, some incompatibilities may still occur in JOIN statements (see http://bugs.mysql.com/bug.php?id=13551). If you encounter a database error, you may have to revise your code accordingly (information on how to properly code JOINs is found here http://dev.mysql.com/doc/refman/5.1/en/join.html). We apologize for any inconvenience this may have caused.

 

I am new to databases. Can anyone explain how and where to fix this in plain English?

I followed the hosting company links but I just dunno :blush:

Any info much appreciated! :blink:

Link to comment
Share on other sites

Hello,

I also get the same error, even after downloading the lastes bug fix release:

 

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 = '23'

 

[TEP STOP]

 

This is what the hosting company says:

 

We have upgraded MySQL on all servers to version 5.0.18. Although we have taken every measure to ensure the new version is backward compatible with the previous one, some incompatibilities may still occur in JOIN statements (see http://bugs.mysql.com/bug.php?id=13551). If you encounter a database error, you may have to revise your code accordingly (information on how to properly code JOINs is found here http://dev.mysql.com/doc/refman/5.1/en/join.html). We apologize for any inconvenience this may have caused.

 

I am new to databases. Can anyone explain how and where to fix this in plain English?

I followed the hosting company links but I just dunno :blush:

Any info much appreciated! :blink:

 

:thumbsup: Found the fix in Bug Report 3259 LEFT JOIN Errors LEFT JOIN Errors

Link to comment
Share on other sites

having the same prob guys do i do the same thing or what?

 

1054 - Unknown column 'c.customer_discount' in 'field list'

 

select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customer_discount, c.customers_default_address_id from customers c left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '8'

 

[TEP STOP]

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...