VKBrookeWilliams Posted October 15, 2005 Share Posted October 15, 2005 I've loaded and edited the files needed, to use the "Featured Products" contribution. However, it's not allowing me to add any product to it. When ever I click on the Featured Product link in my admin area, I get the following error: 1146 - Table 'triumph_osc1.featured' doesn't exist select count(*) as total from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id [TEP STOP] Does any one know what this means and/or how to fix it? Thanks! Link to comment Share on other sites More sharing options...
241 Posted October 15, 2005 Share Posted October 15, 2005 did you run the sql file on the database to create the table featured No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
VKBrookeWilliams Posted October 15, 2005 Author Share Posted October 15, 2005 did you run the sql file on the database to create the table featured I don't know... :huh: I downloaded the contribution and did all the steps in the READ ME file. So, how would I run the sql file on the database to create the table featured? Thanks. :blush: Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted October 15, 2005 Share Posted October 15, 2005 I don't know... :huh: I downloaded the contribution and did all the steps in the READ ME file. So, how would I run the sql file on the database to create the table featured? Thanks. :blush: go check out the contribution files ... there should be a file called something.sql Now go to your webhost cPanel, find the databases and the phpmyadmin tool. Click on it, then select your database and click on sql. There will be a field to copy the content of that .sql file in. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
VKBrookeWilliams Posted October 16, 2005 Author Share Posted October 16, 2005 go check out the contribution files ... there should be a file called something.sql Now go to your webhost cPanel, find the databases and the phpmyadmin tool. Click on it, then select your database and click on sql. There will be a field to copy the content of that .sql file in. I looked through every file under catalog and did not find anything called, something.sql I would assume it should be there because I've copied every file from the contribution onto it. The original download was done on a computer that I can't get to for a couple of days. I would download it again, but I'm currently using dialup... I've clicked on the phpmyadmin tool, but I don't know which database to select. Link to comment Share on other sites More sharing options...
241 Posted October 16, 2005 Share Posted October 16, 2005 the sql inserts may be included in the install file instead of a seperate file even on dialup this should not take long to download as the package should only be about 25k No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
VKBrookeWilliams Posted October 16, 2005 Author Share Posted October 16, 2005 the sql inserts may be included in the install file instead of a seperate file even on dialup this should not take long to download as the package should only be about 25k I've just downloaded two featured product contributions and looked for the file... I can't find it (something.sql). So where could I download the install file? Or should it be with my files already in the cPanel? Link to comment Share on other sites More sharing options...
241 Posted October 16, 2005 Share Posted October 16, 2005 The install instructions should be install.txt included in the package, make sure that you are downloading a full package and not a bug fix or update package that only has a readme file in it. No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
VKBrookeWilliams Posted October 16, 2005 Author Share Posted October 16, 2005 The install instructions should be install.txt included in the package, make sure that you are downloading a full package and not a bug fix or update package that only has a readme file in it. Okay, now ran a sql file on the database. But now I have a new error. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1 select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20 What do I do to fix this one? Link to comment Share on other sites More sharing options...
241 Posted October 16, 2005 Share Posted October 16, 2005 This is a known bug associated with newer versions of mysql and the -20,20 is from your split page results http://www.oscommerce.com/community/bugs,1605 No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
mtechama Posted October 16, 2005 Share Posted October 16, 2005 241, I am look for the samething and I don't have the Featured.php file where can find that file. Wade Morris Amarillo, Texas Before you do any changes on your site you need to do BACKUP! BACKUP! Link to comment Share on other sites More sharing options...
VKBrookeWilliams Posted October 16, 2005 Author Share Posted October 16, 2005 241, I am look for the samething and I don't have the Featured.php file where can find that file. I'm not 241, but I know where that file is. http://www.oscommerce.com/community/contributions,651/page,5 Link to comment Share on other sites More sharing options...
mtechama Posted October 16, 2005 Share Posted October 16, 2005 VKBrooke, look at my post http://www.oscommerce.com/forums/index.php?showtopic=175662 Wade Morris Amarillo, Texas Before you do any changes on your site you need to do BACKUP! BACKUP! Link to comment Share on other sites More sharing options...
avail1now Posted January 30, 2006 Share Posted January 30, 2006 where is the official support thread for Featured Products contribution. cheers, Bridgette & Deano my contributions: tableless CSS template login form for STSresources: effective searching knowledge base how to: sandbox with Paypal IPN Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.