HELP! 1054 - Unknown column 'products_featured' in 'field list'

Discussion in 'Databases' started by kimbiz88, Apr 4, 2008.

0
  1. #1
    I am getting this error on my site suddenly,

    1054 - Unknown column 'products_featured' in 'field list'

    update products set products_status = '0', products_featured = '0', products_last_modified = now() where products_id = '77'

    [TEP STOP]

    I am using Oscommerce.

    Can someone please provide step by step solution to this?
    Greatly appreciated.

    Thanks!
     
    kimbiz88, Apr 4, 2008 IP
  2. MyCrib

    MyCrib Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    because your table doesn't have "products_featured" column. Otherwise, you don't put a correct column name to find in field list.
     
    MyCrib, Apr 5, 2008 IP
  3. kimbiz88

    kimbiz88 Peon

    Messages:
    170
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    so how do i fix it?

    Please advise,
    Thanks
     
    kimbiz88, Apr 5, 2008 IP