Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Urgent help Please. live store getting error


sinryder

Recommended Posts

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

Link to comment
Share on other sites

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.

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...