Announcement

Collapse
No announcement yet.

MYSQL error. Is this important?

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

  • MYSQL error. Is this important?

    Database error in vBulletin: Invalid SQL: SELECT *,INSTR(',120,-1,', CONCAT(',', forumid, ',') ) AS ordercontrol FROM access WHERE userid= AND (forumid='120' OR forumid='-1') ORDER BY ordercontrol LIMIT 1
    mysql error: You have an error in your SQL syntax near 'AND (forumid='120' OR forumid='-1') ORDER BY ordercontrol LIMIT 1' at line 1
    mysql error number: 1064
    Date: Thursday 07th of June 2001 09:38:09 PM
    Script: /speak/forumdisplay.php?forumid=120
    Referer: http://www.curvemag.com/speak/index.php

    what does this mean?

    How do I fix this?

    Only about 8 people on the board now, waiting for the answer to this problem before I open up my board.

  • #2
    Someone else posted that today but I can't reproduce it, and I have added a line that should prevent it in the future.

    But unless it's happening consistently, it's not importatnt.

    Comment


    • #3
      Sorry to drag this up again, but I am also getting the same error after our Ezboard converstion.

      Database error in vBulletin: Invalid SQL: SELECT *,INSTR(',8,1,-1,', CONCAT(',', forumid, ',') ) AS ordercontrol FROM access WHERE userid= AND (forumid='8' OR forumid='1' OR forumid='-1') ORDER BY ordercontrol LIMIT 1
      mysql error: You have an error in your SQL syntax near 'AND (forumid='8' OR forumid='1' OR forumid='-1') ORDER BY ordercontrol LIMIT 1' at line 1
      mysql error number: 1064
      Date: Friday 08th of June 2001 01:00:51 PM
      Script: /forumdisplay.php?forumid=8
      Any fixes known yet?
      HP DL-380 G6, 2x E5520, 28GB RAM, 4x300GB SAS, VMWare ESXi
      -
      Unreal Tournament : Assault forums - irc://irc.utassault.net:6667 -

      Comment


      • #4
        Find this string in functions.php:

        FROM access WHERE userid=

        right after it you should see $userid -- surround that in single quotes:

        FROM access WHERE userid='$userid'

        Comment


        • #5
          Hey, ED. It was me who reported that error, yEsTeRdAy.

          Comment


          • #6
            Thanks, I've applied the fix and I'm sure it will work
            HP DL-380 G6, 2x E5520, 28GB RAM, 4x300GB SAS, VMWare ESXi
            -
            Unreal Tournament : Assault forums - irc://irc.utassault.net:6667 -

            Comment

            Loading...
            Working...
            X