[phpBB 2.0.13 SQL error in session cXIb8O3.8] Author: Maksymilian Arciemowicz Date: 10.3.2005 - --- 0.Description --- phpBB is a high powered, fully scalable, and highly customizable Open Source bulletin board package. phpBB has a user-friendly interface, simple and straightforward administration panel, and helpful FAQ. Based on the powerful PHP server language and your choice of MySQL, MS-SQL, PostgreSQL or Access/ODBC database servers, phpBB is the ideal free community solution for all web sites. Contact with author http://www.phpbb.com/about.php. - --- 1. Session SQL error --- Error is non critical but is very interesting because is specific. If you don`t have cookies in forum, go to for exemple: URL1# http://[HOST]/[DIR]/modcp.php?mode=delete&t=-99&sid= or URL2# http://[HOST]/[DIR]/modcp.php?mode=move&t=-99&sid= etc. And have you fun error. Error message : - --------------- phpBB : Critical Error Error creating new session 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 ' 0)' at line 3 INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('f908cee2ec0ceabe41c17c16198d6ff5', -1, 1107468751, 1107468751, '7f000001', , 0) Line : 158 File : /www/phpBB2/includes/sessions.php - --------------- Sql injection? No! Why? Because you don`t can insert varible to querty. And some what.. if you have cookie try to go to this url and can you see next error. Error message : - --------------- phpBB : Critical Error Error updating sessions table 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 session_id = '06f01a9adbc6777f54039ab745c038f7'' at line UPDATE phpbb_sessions SET session_time = 1107469991, session_page = WHERE session_id = '06f01a9adbc6777f54039ab745c038f7' Line : 279 File : /www/phpBB2/includes/sessions.php - --------------- What is wrong? Wrong is variable $page_id in function session_begin() [ERROR1] and variable $thispage_id in function session_pagestart()[ERROR2]. Frist function try start new session but variable $page_id don't exist and then we see error in sql query. Next function try change something in session but variable don`t exist and this is a problem. Example sql query is: INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('26fc83315ce07d83a68014f18ccf3486', -1, 1110470967, 1110470967, '7f000001', , 0) - --- 2.Contact --- Author: Maksymilian Arciemowicz