Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Urgent help Please. live store getting error


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





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



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


My Contributions

Link to comment
Share on other sites


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

  • Create New...