database error

[hornstar6969]

I was cleaning up the database last night and dropped a fair few tables that I thought were no longer in use, however I guess 1 of those were still in use lol.

MySQL Error  : Table 'gamerzne_backup.maf_application' doesn't exist
Error Number : 1146

first: what is that table 'maf_application' What reads from that?

secondly, what is the query that I need to run to create that same table again.

Thanks.

[organik81]

The 'maf_application' table is used in the Moderator Application System plugin; you can find it here : http://www.vbulletin.org/forum/showthread.php?t=102506

also you can try to install this and try again.. or you can re-create this table again with this query below;

CREATE TABLE `maf_application` (
`appid` int(10) NOT NULL auto_increment,
`userid` int(10) NOT NULL default '0',
`email` varchar(250) NOT NULL default '',
`fullname` varchar(250) NOT NULL default '',
`age` tinyint(4) NOT NULL default '0',
`location` varchar(250) NOT NULL default '',
`timezone` varchar(25) NOT NULL default '',
`position` varchar(250) NOT NULL default '',
`why_them` mediumtext NOT NULL,
`what_they_bring` mediumtext NOT NULL,
`pactivity` mediumtext NOT NULL,
`globally_pactivity` mediumtext NOT NULL,
`plus_site` mediumtext NOT NULL,
`neg_site` mediumtext NOT NULL,
`better_than_rest` mediumtext NOT NULL,
`more` mediumtext NOT NULL,
`application_time` int(10) NOT NULL default '0',
`auto_mailed` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`appid`)
);