1054 - Unknown Column 'p.products_id' In 'on Clause'

[assassin85]

hello

 

after my host upgrade to version 5 , i got error in the front my cart

 

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

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '62' order by pd.products_name

[TEP STOP]

 

any help please?

[MrPhil]

osC is written for MySQL 4 and earlier. It needs updating for MySQL 5.

 

osC and MySQL 5 - 1054 errors 04/30/09

http://www.oscommerce.com/forums/index.php?sho...=335136&hl=

[assassin85]

osC is written for MySQL 4 and earlier. It needs updating for MySQL 5.

 

osC and MySQL 5 - 1054 errors 04/30/09

http://www.oscommerce.com/forums/index.php?sho...=335136&hl=

 

i did the changed and still didn't work

 

i replace osC files with oscommerce-2.2rc2 and it worked well !!! but the problem is i there is a custom style changes so how could i know to fix that code without damage my custom style and i don't know if there was contributions or add-ons

 

regards

[spooks]

just replacing files is not the best plan, there are upgrade methods

 

did you replace your old css, if so put the old back.

 

Upgrading osC from 2.2 MS2 to 2.2 RC2a http://addons.oscommerce.com/info/6654

[assassin85]

can someone please make the follwoing code compitable to mysql 5.0

 

$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '62' order by pd.products_name";

[assassin85]

i also got

 

Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/user/public_html/includes/header.php:136) in /home/user/public_html/includes/boxes/categories.php on line 59

 

when i add item to cart , create a new account , etc

[MrPhil]

can someone please make the follwoing code compitable to mysql 5.0

 

$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '62' order by pd.products_name";

 

Since you didn't read and follow the instructions in the link I provided in my answer:

$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '62' order by pd.products_name";

 

What mod or contribution is this from? File name and line? It would be nice to add this to the list I started (see first post).

 

Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/user/public_html/includes/header.php:136) in /home/user/public_html/includes/boxes/categories.php on line 59

 

You probably botched a mod/contribution install and put in code twice to declare the tep_show_category() function. If not, perhaps you have two different mods/contributions that happen to both define this function? In that case, if they're different function definitions, you'll have to change the name on one of them (and all uses of it). If they're the same function definition, just remove the second definition.