Announcement

Collapse
No announcement yet.

Sudden invalid users

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

  • Sudden invalid users

    Setting up our brand new Vbulletin 3.00 beta 4 board, suddenly a couple of users (Registered and 2 admins) are NOT able to login and when others who can login view their profile they get:

    vBulletin Message
    Invalid user specified. If you followed a valid link, please notify the webmaster
    This what the affected users get:
    There seems to have been a slight problem with the Comingout.nl Forum database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.
    Please help us out!

  • #2
    this is the dispatched email:

    Database error in vBulletin 3.0.0 Beta 4:

    Invalid SQL: SELECT moderatorid, permissions FROM vb_moderator WHERE userid = LIMIT 1
    mysql error: You have an error in your SQL syntax near 'LIMIT 1' at line 1

    mysql error number: 1064

    Date: Friday 25th of July 2003 12:58:16 PM
    Script: http://forum.comingout.nl/
    Referer: http://forum.comingout.nl/
    IP Address: 213.51.47.136

    Comment


    • #3
      Fault is somewhere in includes/functions.php's can_moderate function, or more likely, the PHP code prior to that one being called not properly handling $u into $userid or something like that. The failing query comes from this function:


      // ###################### Start ismoderator #######################
      function can_moderate($forumid = 0, $do = '', $userid = -1)

      Comment

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