need help im getting to many Database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • djjeffa
    Senior Member
    • Jul 2004
    • 241
    • 3.6.x

    need help im getting to many Database error

    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?


    www.djjeffa.com
  • whitey10tc
    Senior Member
    • Jan 2011
    • 415
    • 4.0.x

    #2
    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.
    www.cdmagurus.com
    www.cellphone-gurus.com

    Comment

    • djjeffa
      Senior Member
      • Jul 2004
      • 241
      • 3.6.x

      #3
      Originally posted by 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.
      The problem is there generating url that are not it the forum folder my site is @ djjeffa.com/vb
      Code:
      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        : [URL]http://djjeffa.com/member.php?u=74479[/URL]
      Referrer      : 
      IP Address    : 66.249.67.140
      Username      : 
      Classname     : vB_Database
      MySQL Version :
      Code:
      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        : [COLOR=#0066cc]http://www.djjeffa.com/forumdisplay.php?f=306[/COLOR]
      Referrer      : [COLOR=#0066cc]http://www.djjeffa.com/forumdisplay.php?f=306[/COLOR]
      IP Address    : 178.86.17.24
      Username      : 
      Classname     : vB_Database
      MySQL Version :
      anyideal for a fix my mailbox gets loaded quick.
      www.djjeffa.com

      Comment

      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24325
        • 5.7.X

        #4
        Run this in phpMyAdmin:

        Code:
        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.
        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

        Comment

        • djjeffa
          Senior Member
          • Jul 2004
          • 241
          • 3.6.x

          #5
          Originally posted by Trevor Hannant
          Run this in phpMyAdmin:

          Code:
          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?
          www.djjeffa.com

          Comment

          • djjeffa
            Senior Member
            • Jul 2004
            • 241
            • 3.6.x

            #6
            Bump.......................
            Originally posted by djjeffa
            thanks trevor
            I understand the first part but settings am i saving in the admin cp?
            www.djjeffa.com

            Comment

            • Zachery
              Former vBulletin Support
              • Jul 2002
              • 59097

              #7
              Yes.

              Comment

              • djjeffa
                Senior Member
                • Jul 2004
                • 241
                • 3.6.x

                #8
                Originally posted by Zachery
                Yes.
                lol sorry i was asking what am I doing in the admin cp what am i saving where?
                www.djjeffa.com

                Comment

                • Zachery
                  Former vBulletin Support
                  • Jul 2002
                  • 59097

                  #9
                  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

                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...