[fixed] userid not being set properly

[pestilence]

Database error in vBulletin: Invalid SQL: SELECT *,INSTR(',4,3,-1,', CONCAT(',', forumid, ',') ) AS ordercontrol FROM access WHERE userid= AND (forumid='4' OR forumid='3' OR forumid='-1') ORDER BY ordercontrol LIMIT 1
mysql error: You have an error in your SQL syntax near 'AND (forumid='4' OR forumid='3' OR forumid='-1') ORDER BY ordercontrol LIMIT 1' at line 1
mysql error number: 1064
Date: Thursday 14th of June 2001 05:51:46 AM
Script: /forums/forumdisplay.php?forumid=4

i get this when i am not logged in and try to enter a forum ????

[Mike Sullivan]

Known, yet somewhat unproduceable, issue. It should be fixed in 2.0.2.

[pestilence]

it only seems to happen when someone first visits the forums if they register then logout the error is not repeated but thanx for the swift reply..top notch support as usual :) yet another reason i ditched ubb

[Robert Basil]

Originally posted by Ed Sullivan
Known, yet somewhat unproduceable, issue. It should be fixed in 2.0.2.

Ed,

I'll study the error and see if I can find out when it is happening the most.

I am getting over 2,000 of these error messages a day so I hope we can get it fixed. :)

[Mike Sullivan]

sessions.php, added line in bold:


$bbuserinfo = $session;
$bbuserinfo['userid'] = 0;

See if that helps at all.

[Robert Basil]

Originally posted by Ed Sullivan
sessions.php, added line in bold:


$bbuserinfo = $session;
$bbuserinfo['userid'] = 0;

See if that helps at all.

Ed,

That did the trick, thanks!

[Steve Machol]

Originally posted by Ed Sullivan
sessions.php, added line in bold:


$bbuserinfo = $session;
$bbuserinfo['userid'] = 0;

See if that helps at all.

Ed,

I've started getting these errors all of a sudden and applied this fix. Unfortunately the errors are continuing. Here is one such error:


Database error in vBulletin: Invalid SQL: SELECT *,INSTR(',12,1,-1,', CONCAT(',', forumid, ',') ) AS ordercontrol FROM access WHERE userid= AND (forumid='12' OR forumid='1' OR forumid='-1') ORDER BY ordercontrol LIMIT 1
mysql error: You have an error in your SQL syntax near 'AND (forumid='12' OR forumid='1' OR forumid='-1') ORDER BY ordercontrol LIMIT 1' at line 1
mysql error number: 1064
Date: Monday 02nd of July 2001 11:59:43 AM
Script: /forums/forumdisplay.php?forumid=12
Referer: http://www.optiboard.com/forums/
In addition, two of my members are having trouble accessing the forums after I applied this change. It may be a coincidence, but neither one has had trouble before this.

Any idea how to fix this? The errors are frequent enough to be annoying.

[Steve Machol]

I'm still getting these errors after inserting the fix to sessions.php. It doesn't happen all the time, just a few errors a day.

Do I need to start a new thread to get some help with this?

[Steve Machol]

Just stopping in to say that once I applied the fix to the correct file, the errors stopped! ;)