mark27uk3 Posted January 10, 2004 Share Posted January 10, 2004 :( Hi Guys, I know I should not post 2 threads about the same thing but I am totally screwed. I am trying to remove the featured products contribution, I have removed everything from my .php files but now I am left with 1146 - Table 'castlemobiuk.table_featured' doesn't exist select featured_id from TABLE_FEATURED where status = '1' and now() >= expires_date and expires_date > 0 [TEP STOP] How do I get rid of this error! Please help me I am desperate! (also no good at databases) Eternal Thanx Mark Lifes a bitch, then you marry one, then you die! Link to comment Share on other sites More sharing options...
Guest Posted January 10, 2004 Share Posted January 10, 2004 run the sql statement which contains table_featured (most likely from a contribution) against your castlemobiuk database. Link to comment Share on other sites More sharing options...
mark27uk3 Posted January 10, 2004 Author Share Posted January 10, 2004 Right I have done that in myphpadmin and it says SQL-query : [Edit] [Create PHP Code] create TABLE featured( featured_id int( 11 ) not null auto_increment, products_id int( 11 ) default '0' not null , featured_date_added datetime, featured_last_modified datetime, expires_date datetime, date_status_change datetime, status int( 1 ) default '1', PRIMARY KEY ( featured_id ) ) But I am still getting the same error. Mark Lifes a bitch, then you marry one, then you die! Link to comment Share on other sites More sharing options...
wizardsandwars Posted January 10, 2004 Share Posted January 10, 2004 Uninstall the contribution by doing all of the installation instructions backwards. Apparently, you left a couple lines of code in your index.php file that are trying to execute SQL against that table, which doesn't exist. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
Guest Posted January 10, 2004 Share Posted January 10, 2004 I know I should not post 2 threads about the same thing but I am totally screwed. So what?..... being "totally screwed" is good enough reason to crosspost? I spent over an hour last night removing crossposts.... :blink: Crossposting and bumping - two surefire ways to have your problem ignored IMO Matti Link to comment Share on other sites More sharing options...
dyland Posted January 10, 2004 Share Posted January 10, 2004 Your select calls the table 'TABLE_FEATURED' , your SQL create statement just calls the table 'FEATURED'. You probably mistyped your table name in the select statement. Do a global search for 'table_featured' and change to 'featured'. Always remember to make a backup before applying a contrib, makes falling back much easier - I know its saved me a lot of heart ache. Dylan 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.