SQL when user session has expired [message #28058] |
Mon, 10 October 2005 00:44 |
|
JamesS
Messages: 275 Registered: July 2002 Location: Atlanta, GA
Karma:
|
Senior Member |
|
|
When a user tries to view the forum by clicking on the "Home" link after their session has expired the following SQL is generated and the forum displays a blank white page to the user (lovely run on sentence there):
sensitive parts changed | Mon Oct 10 0:34:30 GMT 2005 (/var/www/forum/index.php:76
/var/www/forum/index.php:176
/var/www/forum/index.php:275
/var/www/forum/index.php:939
/var/www/forum/index.php:1129
) 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 'df0c98188930367283039dc25a8fc04a' AND s.time_sec > 1128902670' at line 9
Query: SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt, u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry FROM example_forum_ses s INNER JOIN example_forum_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN example_forum_themes t ON t.id=u.theme WHERE s.ses_id=''df0c98188930367283039dc25a8fc04a' AND s.time_sec > 1128902670
_GET: array ( 't' => 'index', 'rid' => '001', 'S' => 'df0c98188930367283039dc25a8fc04a', )
Server Version: 4.1.13
[Referring Page] http://example.com/forum/index.php?t=index&rid=0001&S=df0c981889303 67283039dc25a8fc04a
|
This is with version 2.7.3RC1. I am assuming this is after the session has expired because I can reach the forum by removing the session information from the URL; when I do that I have to re-login to the forum.
|
|
|