jeremylwf Posted June 6, 2007 Posted June 6, 2007 Hi, I accidently delated my product tables and finally got it restored using the default oscommerce product table. Now i have this error: 1054 - Unknown column 'products_featured' in 'where clause' SELECT products_id from products where products_featured = '1' and now() >= products_featured_until and products_featured_until > 0 [TEP STOP] got any idea how to fix this?
Nullachtfuffzehn Posted June 6, 2007 Posted June 6, 2007 The mentioned table fields are not part of an osC standard installation, so I guess they came with an installed contribution. Check the installation files of the contribution for .sql file. There you should find the needed information. You can run that file to recreate the fields, but without any warranty. Make sure to make a backup of your database before running that file!
jeremylwf Posted June 7, 2007 Author Posted June 7, 2007 I cant remember what contribution i installed so can anyone just help me fix this error?
RyanH Posted June 7, 2007 Posted June 7, 2007 Likely "Featured Products"? http://www.oscommerce.com/community/contri...search,featured Let me know if I'm wrong and I'll look more in depth.
jeremylwf Posted June 8, 2007 Author Posted June 8, 2007 Hi, "Featured Products" dont seem to be the right one. I tried the sql but i still got the same error
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.