Please Help me out with this error

[sinryder]

hey guys i switched my site to new web hosting provider and now when i visted the site. i was getting this error when i go to categories or subcategories

 

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

 

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '5' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

 

[TEP STOP]

 

 

olny two things i could think of changed.

1) my older host had mysql v 4.1 and the newer one upgraded me to 5.0 .

2) new host had register global off so i had to turn it on by entering php_flag register_globals On in .htaccess file .

 

please help me fix this error .

 

thankyou

[♥FWR Media]

hey guys i switched my site to new web hosting provider and now when i visted the site. i was getting this error when i go to categories or subcategories

 

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

 

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '5' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

 

[TEP STOP]

olny two things i could think of changed.

1) my older host had mysql v 4.1 and the newer one upgraded me to 5.0 .

2) new host had register global off so i had to turn it on by entering php_flag register_globals On in .htaccess file .

 

please help me fix this error .

 

thankyou

 

You shouldn't need to pay for this, it's very well documented. do a google search for that error.

[sinryder]

You shouldn't need to pay for this, it's very well documented. do a google search for that error.

 

thankx bro google realy helped. i have found the the fix here http://www.oscommerce.com/forums/index.php?sho...230304&st=0

just one problem left... the error is gone from products info page, manufacturer page , and from sub categories. But iam still getting it on main category. Not sure how come sub categories is fixed but main category is not :(

 

could you please point me to the right direction.

 

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

 

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '65' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

 

[TEP STOP]

[♥FWR Media]

thankx bro google realy helped. i have found the the fix here http://www.oscommerce.com/forums/index.php?sho...230304&st=0

just one problem left... the error is gone from products info page, manufacturer page , and from sub categories. But iam still getting it on main category. Not sure how come sub categories is fixed but main category is not :(

 

could you please point me to the right direction.

 

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

 

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '65' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

 

[TEP STOP]

 

That's index.php which is quite a complex file. You need to upgrade that particular file. You could try just dropping in the RC2a catalog/index.php which worked for me the other day, however I wouldn't call it tested.