need help im getting to many Database error

[djjeffa]

my forum is located @ .com/vb my vBa CMPS is located @ .com and .com/vb but im gussing bots go to like .com/member.php?u=123456 com/index com/showthread.php?p=12345 ect. and I keep geting db errors. any clue on how I could fix this?

[whitey10tc]

Post your error messages and maybe someone can help better. Right now we have no clue what the error is, or what might cause it.

[djjeffa]

Post your error messages and maybe someone can help better. Right now we have no clue what the error is, or what might cause it.

The problem is there generating url that are not it the forum folder my site is @ djjeffa.com/vb

Database error in vBulletin :
 
Invalid SQL:
 
			SELECT *
			FROM vbdatastore
			WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache');
 
MySQL Error   : Table 'djjeffa_djjeffavb.vbdatastore' doesn't exist
Error Number  : 1146
Request Date  : Sunday, January 29th 2012 @ 06:01:17 AM
Error Date    : Sunday, January 29th 2012 @ 06:01:17 AM
Script        : http://djjeffa.com/member.php?u=74479
Referrer      : 
IP Address    : 66.249.67.140
Username      : 
Classname     : vB_Database
MySQL Version :

Database error in vBulletin :
 
Invalid SQL:
 
			SELECT *
			FROM vbdatastore
			WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','iconcache','mailqueue','prefixcache');
 
MySQL Error   : Table 'djjeffa_djjeffavb.vbdatastore' doesn't exist
Error Number  : 1146
Request Date  : Sunday, January 29th 2012 @ 05:57:00 AM
Error Date    : Sunday, January 29th 2012 @ 05:57:00 AM
Script        : http://www.djjeffa.com/forumdisplay.php?f=306
Referrer      : http://www.djjeffa.com/forumdisplay.php?f=306
IP Address    : 178.86.17.24
Username      : 
Classname     : vB_Database
MySQL Version :

anyideal for a fix my mailbox gets loaded quick.

[Trevor Hannant]

Run this in phpMyAdmin:

CREATE TABLE vbdatastore (
    title CHAR(50) NOT NULL DEFAULT '',
    data MEDIUMTEXT,
    unserialize SMALLINT NOT NULL DEFAULT '0',
    PRIMARY KEY (title)
)

This will recreate your Datastore table. Then go into AdminCP and save any setting in there.

[djjeffa]

Run this in phpMyAdmin:

CREATE TABLE vbdatastore (
    title CHAR(50) NOT NULL DEFAULT '',
    data MEDIUMTEXT,
    unserialize SMALLINT NOT NULL DEFAULT '0',
    PRIMARY KEY (title)
)

This will recreate your Datastore table. Then go into AdminCP and save any setting in there.

thanks trevor
I understand the first part but settings am i saving in the admin cp?

[djjeffa]

Bump.......................

thanks trevor
I understand the first part but settings am i saving in the admin cp?

[Zachery]

Yes.

[djjeffa]

Yes.

lol sorry i was asking what am I doing in the admin cp what am i saving where?

[Zachery]

Save everything that can be saved.
Edit any settings group, Settings > Options >
Edit and save a forum
Edit and save a style
Edit and save a Language
Edit and save a usergroup