Print Page - getting error forum is down

Title: getting error forum is down
Post by: marinelife on August 08, 2006, 05:38:21 PM

Table 'masohiodb.smf_ads' doesn't exist
File: D:\websites\masohio\forums\Sources\LoadAds.php
Line: 33

version SMF 1.1 RC2

Can you turn off ads in the database or repair the smf_ads
I look in phpmyadmin and it shows it on the list but says it does not exist

Title: Re: getting error forum is down
Post by: bigguy on August 08, 2006, 05:46:11 PM

Try re-uploading "LoadAds.php" file to your sources directory.

Title: Re: getting error forum is down
Post by: marinelife on August 08, 2006, 05:55:26 PM

Does nothing, it was working and has been working for the longest time

it is ads ver 2

Title: Re: getting error forum is down
Post by: bigguy on August 08, 2006, 06:12:46 PM

Jerm will probably have some ideas on this. I`m not real familiar with sql at all, sorry. He should be around soon. I guess if you had a recent backup of the database you could try that, but I think thats going to the extreme.

Title: Re: getting error forum is down
Post by: marinelife on August 08, 2006, 06:42:02 PM

I tried a back, I am hoping I can edit the files and get the ad mod off and then reinstall it

Title: Re: getting error forum is down
Post by: jerm on August 09, 2006, 10:45:10 AM

run this command in sql:

Code Select


CREATE TABLE IF NOT EXISTS smf_ads (
ADS_ID mediumint(8) unsigned NOT NULL auto_increment,
NAME tinytext NOT NULL,
CONTENT text NOT NULL,
BOARDS tinytext,
POSTS tinytext,
HITS mediumint(8) NOT NULL default '0',
TYPE smallint(4) NOT NULL default '0',
show_index smallint(4) NOT NULL default '0',
show_board smallint(4) NOT NULL default '0',
show_threadindex smallint(4) NOT NULL default '0',
show_thread smallint(4) NOT NULL default '0',
show_bottom smallint(4) NOT NULL default '0',
show_welcome smallint(4) NOT NULL default '0',
show_topofpage smallint(4) NOT NULL default '0',
show_towerright smallint(4) NOT NULL default '0',
show_towerleft smallint(4) NOT NULL default '0',
PRIMARY KEY (ADS_ID)
);

somehow the table got deleted, no idea how that happened

Title: Re: getting error forum is down
Post by: marinelife on August 09, 2006, 03:32:31 PM

thanks that has seemed to fix it

SMF Ads Support Forum

Support => General Support => Topic started by: marinelife on August 08, 2006, 05:38:21 PM