Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MYsql grammar solution!!! HELP


Tcet

Recommended Posts

Posted

Hi I Really need help ASAP ..HELP!!!!

 

I've had a oscommerce site for a long time now ..everything was fine until the server that the runs on .. got upgraded with mysql 5 ... used to be 4 i guess...

 

The site works just fine..only when products need to be listed (after selecting a category in the menu.. I get a Mysql error... the grammar is no longer working in mysql 5.0.

 

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 = '5' and p2c.categories_id = '35'

 

SO HOW do i change the grammar to work ...where do i change it ..???

I cant find this section anywhere...on the index page that generates it......?

 

www.maha-nail.nl/catalog

and click link in left menu...for category ...

 

 

 

Super thanx!

Alx

 

HELP???...anyone... I just really need it wrking and have no idea about mysql grammar..

Posted
Hi I Really need help ASAP ..HELP!!!!

 

I've had a oscommerce site for a long time now ..everything was fine until the server that the runs on .. got upgraded with mysql 5 ... used to be 4 i guess...

 

The site works just fine..only when products need to be listed (after selecting a category in the menu.. I get a Mysql error... the grammar is no longer working in mysql 5.0.

 

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 = '5' and p2c.categories_id = '35'

 

SO HOW do i change the grammar to work ...where do i change it ..???

I cant find this section anywhere...on the index page that generates it......?

 

www.maha-nail.nl/catalog

and click link in left menu...for category ...

 

EMail: [email protected]

 

Super thanx!

Alx

 

HELP???...anyone... I'll pay 20 Bucks! I just really need it wrking and have no idea about mysql grammar..

 

 

Apply the updates that come up with the updated release of Oscommerce

 

osCommerce 2.2 Milestone 2 051112 Update Released

 

from the following URL you can get the fixes article to read.

http://www.oscommerce.com/about/news,121

 

 

Satish Mantri

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Archived

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

×
×
  • Create New...