News:

Help keep this project going by donating or buying adseller pro

Main Menu
Coinbase

getting error forum is down

Started by marinelife, August 08, 2006, 05:38:21 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

marinelife

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

bigguy

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

marinelife

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

it is ads ver 2

bigguy

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.

marinelife

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

jerm

run this command in sql:

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

marinelife