Database error in vBulletin 3.8.7

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wii
    Senior Member
    • Sep 2000
    • 1036
    • 3.8.x

    Database error in vBulletin 3.8.7

    I get this message now when people register, how can I fix it?

    Thanks

    ---------------------------------------

    Invalid SQL:

    SELECT activationid, usergroupid, emailchange
    FROM useractivation
    WHERE activationid = '303ad804380d67458a9b62bfc45d185edc750bca'
    AND userid =
    AND type = 0;

    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 'AND type = 0' at line 5
    Error Number : 1064
    Request Date : Thursday, May 8th 2014 @ 01:11:05 AM
    Error Date : Thursday, May 8th 2014 @ 01:11:05 AM
    Script : http://www.mydomain.com/register.php...5d185edc750bca
    Referrer : http://posta32.posta.libero.it/cp/Ma...4563801513e876
    IP Address : 87.8.166.99
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    Please try the following:

    To disable the plugin/hook system completely, edit includes/config.php and add the following code:
    Just below
    Code:
    <?php
    enter
    Code:
    define('DISABLE_HOOKS', true);
    Now try registering an account.

    Does the same problem occur?
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • wii
      Senior Member
      • Sep 2000
      • 1036
      • 3.8.x

      #3
      I just registered an account, and it worked perfectly, I didn't get an error either, so maybe this was just a temporary error ?!

      Strange...

      Comment

      • Mark.B
        vBulletin Support
        • Feb 2004
        • 24286
        • 6.0.X

        #4
        Could be, I would keep an eye on it.
        MARK.B
        vBulletin Support
        ------------
        My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
        My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

        Comment

        • wii
          Senior Member
          • Sep 2000
          • 1036
          • 3.8.x

          #5
          I will, thanks.

          Comment

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