Announcement

Collapse
No announcement yet.

Help:

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

  • Help:

    Since I've upgraded to 2.2.3b I get around 2000 errors every day, and they are all like this:

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

    Database error in vBulletin 2.2.3:

    Invalid SQL: SELECT *,INSTR(',28,7,191,-1,', CONCAT(',', forumid, ',') ) AS ordercontrol FROM access WHERE userid= AND (forumid='28' OR forumid='7' OR forumid='191' OR forumid='-1') ORDER BY ordercontrol LIMIT 1
    mysql error: You have an error in your SQL syntax near 'AND (forumid='28' OR forumid='7' OR forumid='191' OR forumid='-1') ORDER BY orde' at line 1

    mysql error number: 1064

    Date: Friday 08th of March 2002 09:52:36 AM
    Script: http://forum.ngx.sm/showthread.php?s=&threadid=70930
    Referer: http://forum.ngx.sm/forumdisplay.php?s=&forumid=28

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

    The script and referrer changes everytime, some examples:

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


    Date: Friday 08th of March 2002 09:53:39 AM
    Script: http://forum.ngx.sm/showthread.php?s=&postid=953661
    Referer: http://forum.ngx.sm/newreply.php

    Date: Friday 08th of March 2002 09:53:21 AM
    Script: http://forum.ngx.sm/forumdisplay.php?s=&forumid=28
    Referer:

    Date: Friday 08th of March 2002 09:52:50 AM
    Script: http://forum.ngx.sm/showthread.php?s...682#post952682
    Referer: http://forum.ngx.sm/forumdisplay.php?s=&forumid=104

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

    The problem is with the variable $userid, that sometimes is blank where it shouldn't, and therefore the MySQL query gets wrong (..."userid=" ) because the ID is missing.

    The strange thing is it DOESN'T happen all the time, but just SOMETIMES.

    Can please someone help me?
    Last edited by Omero; Fri 8th Mar '02, 12:49am.
    Omero
    Info: Mad4Games Admin
    Contact: E-Mail | PM | ICQ
    Welcome Home Netgamer

  • #2
    I've seen that I get also a lot of other random messages, like

    Fatal error: Call to undefined function: updateuserforum() in /usr/local/www/vBB/showthread.php on line 489

    After clicking on a thread... the funny thing is that IF i hit reload, then it works fine... all the errors happen sometimes, not everytime O_O

    Btw I'm running with latest PHP and MySQL, under FreeBSD 4.4, both the db server and the webserver (apache).

    Thanks
    Omero
    Info: Mad4Games Admin
    Contact: E-Mail | PM | ICQ
    Welcome Home Netgamer

    Comment

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