Announcement

Collapse
No announcement yet.

3.0.5 database error, no email sent.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 3.0.5 database error, no email sent.

    My friend is having some trouble getting his 3.0.5 board to work so he asked me to help. He had a backup of the database and all the forum files saved on his computer. He uploaded them today for the first time in a couple years. It just says that there's a database error and an email was sent to the tech staff but not the actual error. Now I change the config.php and change the webmaster email to mine so I can get an email to figure out the problem. Well it's not sending an error.

    I'm confused as to why it's not sending me an emial. Is there a way I can get to the error report so I can find out what's wrong?

    Thanks - Kevin

  • #2
    Try this:

    Admin CP -> vBulletin Options -> Server Settings and Optimization Options -> Enable "-f" Parameter -> Yes

    Then try the vB email functions.

    If it still doesn't work, then this is either a server and/or mailbox issue. vB uses PHP's mail() function for all its email and uses the SMTP server specified in php.ini. If PHP and the mail serverare configured correctly then email will work.

    You will need to view the mail logs on the server to see what happened to those emails that don't work. Once vB sends it to PHP it's in the hands of the server. If you are on a shared server you may need to ask your host to look through the logs for you.

    Another thing to keep in mind is that many ISPs and mail clients are putting in very aggressive spam filters. For instance, AOL will not accept emails from domains that do not have reverse DNS setup. It's possible these emails are being placed into a spam folder or are being filtered.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Originally posted by Steve Machol
      Try this:

      Admin CP -> vBulletin Options -> Server Settings and Optimization Options -> Enable "-f" Parameter -> Yes

      Then try the vB email functions.

      If it still doesn't work, then this is either a server and/or mailbox issue. vB uses PHP's mail() function for all its email and uses the SMTP server specified in php.ini. If PHP and the mail serverare configured correctly then email will work.

      You will need to view the mail logs on the server to see what happened to those emails that don't work. Once vB sends it to PHP it's in the hands of the server. If you are on a shared server you may need to ask your host to look through the logs for you.

      Another thing to keep in mind is that many ISPs and mail clients are putting in very aggressive spam filters. For instance, AOL will not accept emails from domains that do not have reverse DNS setup. It's possible these emails are being placed into a spam folder or are being filtered.
      There's a database error no matter what page you go to so the ACP is out of the question. And there's no spam filter on my email so that can't be the problem. I'll look into the PHP deal and see if it won't work. Thanks.

      Comment


      • #4
        We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Well, I set up an email on his website (same as forums) and it sent the email fine. Now I dunno what's wrong exactly.

          Code:
          Database error in vBulletin :
          
          Invalid SQL: 
                                          SELECT title, data
                                          FROM datastore
                                          WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache',
          'vbookiesettings', 'userstats', 'birthdaycache', 'maxloggedin', 'iconcache',
          'eventcache', 'mailqueue')
                                  
          mysql error: Table '[I]site[/I]_forum.datastore' doesn't exist
          
          mysql error number: 1146
          
          Date: Tuesday 16th of May 2006 09:51:44 PM
          Script: http://www.[I]site[/I].com/forums/
          Referer: 
          IP Address: ***.***.***.***

          Comment


          • #6
            Originally posted by Steve Machol
            We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
            Whoa... I never knew it was in the source. Thanks for the tip. Anyway, the error is in the post above.

            Comment


            • #7
              As the error states, the datastore table is missing. This is either a vvery serious problem with the daatabase, or he is using table prefixes and has not edited his config.php file with the appropriate prefix.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                Ooh. I put in the vb3_ prefix which wasn't there and it fixed it! Thanks much. There's a bunch more errors but it looks like missing files which shouldn't be too hard to fix.

                Thanks - Kevin

                Comment

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