Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

hopemcg

Archived
  • Posts

    2
  • Joined

  • Last visited

Profile Information

  • Real Name
    Hope

hopemcg's Achievements

  1. I have it working now (hopefully all the way...). I thought I'd post what I did in case others had the same problem. store_id needed to be added to the products table. Here is the code that I used: ALTER TABLE `products` ADD `store_id` INT( 11 ) DEFAULT '0' NOT NULL ; I haven't gotten this far yet, but I think I will need to delete and re-add all of the sample data because they won't have store_id populated. I remember when I added it originally, that it griped at me about too many columns -- I'm guessing this is the reason. That last "1" is there for store_id.
  2. I am having the same problem that a couple of other people have mentioned. Can someone please post the solution here? Thank you! 1054 - Unknown column 'store_id' in 'where clause' select count(*) as products_count from products where store_id = '1' [TEP STOP]
×
×
  • Create New...