Could not obtain regd user/online information

[kenerly]

Could not obtain regd user/online information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE page_id = 2335' at line 1

SELECT forum_name, forum_id FROM phpbb_forums

Line : 409
File : index.php


Here is line 409 from index.php

Code: Select all

'U_VIEWCAT' => append_sid("index.$phpEx?" . POST_CAT_URL . "=$cat_id"))

The weird thing is I have not done anything(mods, etc) today. This just popped up when I logged in as admin.
Any idea where I should look.

Thanks

[espicom]

It doesn't have to be something you did TODAY, just what you did today to trigger it...

The select statement in question is not in index.php, so it is probably in one of the include files. What were you trying to do when you logged in? That is, were you answering the second, "i want into the Admin Control Panel" login prompt?

[kenerly]

The error happens after I log in the ACP. The error displays on the right half of screen, all the admin options load fine on the left side.

[espicom]

The strange thing is that it would appear that something is getting appended to the query, but not completely; you got the error message saying that the WHERE page_id = 2335 portion of the query was bad, but the query, as printed in the error message doesn't have a WHERE clause... and the error report is associated with a completely different SQL query!

Here is the code associated with the debug message:

Code: Select all

	$sql = "SELECT u.user_id, u.username, u.user_session_time, u.user_session_page, s.session_logged_in, s.session_ip, s.session_start 
		FROM " . USERS_TABLE . " u, " . SESSIONS_TABLE . " s
		WHERE s.session_logged_in = " . TRUE . " 
			AND u.user_id = s.session_user_id 
			AND u.user_id <> " . ANONYMOUS . " 
			AND s.session_time >= " . ( time() - 300 ) . " 
		ORDER BY u.user_session_time DESC";
	if(!$result = $db->sql_query($sql))
	{
		message_die(GENERAL_ERROR, "Couldn't obtain regd user/online information.", "", __LINE__, __FILE__, $sql);
	}

And here is the code, further down, that is associated with the query that get printed in the error message:

Code: Select all

	$sql = "SELECT forum_name, forum_id
		FROM " . FORUMS_TABLE;
	if($forums_result = $db->sql_query($sql))
	{
		while($forumsrow = $db->sql_fetchrow($forums_result))
		{
			$forum_data[$forumsrow['forum_id']] = $forumsrow['forum_name'];
		}
	}
	else
	{
		message_die(GENERAL_ERROR, "Couldn't obtain user/online forums information.", "", __LINE__, __FILE__, $sql);
	}