Code: Select all
Your session has expired. Please log in again
This problem came after the upgrade from 1.5.8 to 1.5.9
SQL queries from the page with "Your session expired" error (tried to login from frontend):
Code: Select all
#
SELECT *
FROM sh10_session
WHERE session_id = 'b9f73d4d950af5f43621a41f78082d5e'
#
DELETE
FROM sh10_session
WHERE ( time < '1231608598' )
#
SELECT *
FROM sh10_session
WHERE session_id = 'b9f73d4d950af5f43621a41f78082d5e'
#
UPDATE `sh10_session`
SET `time`='1231609498',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1231609498;s:18:\"session.timer.last\";i:1231609498;s:17:\"session.timer.now\";i:1231609498;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (X11; U; Linux x86_64; ru; rv:1.9.0.5) Gecko/2008122115 Firefox/3.0.5\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:60:\"/www/sh10/www/htdocs/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"2710328ebdf339b94779a53e0473dc32\";s:17:\"application.queue\";a:1:{i:0;a:2:{s:7:\"message\";s:97:\"Your session has expired. Please log in again\";s:4:\"type\";s:7:\"message\";}}}'
WHERE session_id='b9f73d4d950af5f43621a41f78082d5e'