MYSQL error. Is this important?

[evoir]

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.

[Mike Sullivan]

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.

[Martz]

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?

[Mike Sullivan]

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'

[klisis]

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

[Martz]

Thanks, I've applied the fix and I'm sure it will work