Urgent help Please. live store getting 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

 

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

[FIMBLE]

Either an addon has been added and the SQL update has been ommitted, or the database has dropped the table for some reason,

Try to restore a back up and see if this works, if not you can try to repair the database through your web control panel [back up first though] if all else fails add the table yourself through your web control panel phpmy admin.

[Guest]

Search the contributions for MYsql5, there should be a contribution that will tell you the changes needed to work with the upgraded version.

 

http://www.monikamathe.com/oscommerce/mysql5.txt