Announcement

Collapse
No announcement yet.

Need Help on vBulletin mysql error

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

  • websissy
    replied
    Originally posted by Trevster View Post
    Have a look in your config.php file:

    Code:
     // ****** TECHNICAL EMAIL ADDRESS ******
     // If any database errors occur, they will be emailed to the address specified here.
     // Leave this blank to not send any emails when there is a database error.
    $config['Database']['technicalemail'] = '[email protected]';
    You were absolutely right! Thanks very much. YOU get my gold star for the day!

    Leave a comment:


  • Trevor Hannant
    replied
    Have a look in your config.php file:

    Code:
     // ****** TECHNICAL EMAIL ADDRESS ******
     // If any database errors occur, they will be emailed to the address specified here.
     // Leave this blank to not send any emails when there is a database error.
    $config['Database']['technicalemail'] = '[email protected]';

    Leave a comment:


  • websissy
    started a topic Need Help on vBulletin mysql error

    Need Help on vBulletin mysql error

    I recently moved a site I host from one server to another. Soon afterwards, I started receiving mysql errors that I can't figure out. Here's the error:

    <[email protected]>:
    Sorry, I couldn't find any host named hitcraft.com. (#5.1.2)

    --- Below this line is a copy of the message.

    Return-Path: <[email protected]>
    Received: (qmail 6376 invoked from network); 24 Nov 2009 13:03:38 -0000
    Received: from maker1010.hostmaker.com (294.120.170.34)
    by gateway02.websitewelcome.com with SMTP; 24 Nov 2009 13:03:38 -0000
    Received: from hitch by maker1010.hostmaker.com with local (Exim 4.69)
    (envelope-from <[email protected]>)
    id 1NCurb-0006Da-Nt
    for [email protected]; Tue, 24 Nov 2009 06:51:23 -0600
    To: [email protected]
    Subject: vBulletin Database Error!
    X-PHP-Script: www.walkinoutnewhampshire.com/forums/member.php for 91.211.117.122
    From: [email protected] <[email protected]>
    Message-ID: <[email protected]>
    MIME-Version: 1.0
    Content-Type: text/plain
    Content-Transfer-Encoding: 8bit
    X-Priority: 3
    X-Mailer: vBulletin Mail via PHP
    Date: Tue, 24 Nov 2009 06:51:23 -0600
    X-AntiAbuse: This header was added to track abuse, please include it with any abuse report
    X-AntiAbuse: Primary Hostname - maker1010.hostmaker.com
    X-AntiAbuse: Original Domain - hitcraft.com
    X-AntiAbuse: Originator/Caller UID/GID - [943 943] / [47 12]
    X-AntiAbuse: Sender Address Domain - WalkinOutNewHampshire.com

    Database error in vBulletin 3.8.2:

    Invalid SQL:

    SELECT reason, liftdate
    FROM vb3_userban
    WHERE userid =;

    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
    Error Number : 1064
    Request Date : Tuesday, November 24th 2009 @ 07:51:23 AM
    Error Date : Tuesday, November 24th 2009 @ 07:51:23 AM
    Script : http://www.walkinoutnewhampshire.com...er.php?u=26073
    Referrer : http://www.walkinoutnewhampshire.com...er.php?u=26073
    IP Address : 91.211.117.122
    Username :
    Classname : vB_Database
    MySQL Version :
    The first problem with this message is the domain name of the sending domain is spelled wrong. It should be hitchcraft.com and not hitcraft.com. I assume this is as a result of a typo I made somewhere; but the question is WHERE? I'm not sure where recipient address for mysql errors address is being drawn from. The webmaster's email address from the vbulletin global options page is the other email address you see in this message, namely "[email protected]"

    Can anyone tell me where the heck the misspelled email address is drawn from so that I can find and correct it?

    BTW, I don't think this error is a result of the server change. I assume these errors may have been occurring all along but on the old host with my extensive custom junk-mail filtering I'm not sure an error email sent out to a non-existent email address would have made it to my inbox when it bounced back.

    As you can see from this message, I'm running vbulletin 3.8.2 and the error is coming from a query against the vb3_userban table. Is there possibly a known error dealing with vb3_userban in version 3.8.2 of vb3?

    Here's another clue... I did a full export dump of ALL my mysql databases on this server (100+ mb of data) and then did a "grep" search of the entire dump file looking for any occurrence of "hitcraft.com" but found none. Isn't that a pretty solid indication the misspelled email address is coming from somewhere else? The question is WHERE?

    Thanks!
    Last edited by websissy; Tue 24th Nov '09, 4:49am.

Related Topics

Collapse

Working...
X