Problem with session

[Repepioras]

Hi,

i cannot realy explain situation, but i have joomla and 5 users and all these users with session always someting wrong.... cannot login in administrator and no erros, or login but show:
"An error has occurred.1062 Error initialising the session. "
or sometimes show you session time is expire, or i just come to administartor and show that i login with a other user, but i dont login on any user... and this happen and on new browser....sometimes press F5 and show you are login other user information.... this is come when update joomla to 3.6.0 try update 3.6.1 same.... now update to 3.6.2 same....

in DB session table sometimes do not show some user, but this user is log in

[itoctopus]

This problem typically happens when Joomla can't successfully save the session information in the database.


Try truncating the session table in the database, and then try repairing it, by issuing:

Code: Select all

REPAIR TABLE `#__session`

Please post back here to let us know how it went.

[Repepioras]

#__session repair note The storage engine for the table doesn't support r...


and do not show more msg text just ...

[Webdongle]

Disable cache and unpublish the cache plugin. Clear you Browser cache.

If you are unable to login to admin then clear the Joomla cache from the /cache folder and clear your Browser cache. Once logged into Admin make sure the cache plugin is disabled. Go to Extensions >>> Manage >>> Update and check for updates

Did you update the Joomla update Component in Extensions >>> Manage >>> Update ? The Joomla update Component is and extension and needs a separate update before using it to update from 3.6.1.

[Webdongle]

This problem typically happens when Joomla can't successfully save the session information in the database...

Incorrect ... the problem occurs usually because the cache for the website is not being recognised by the updated Joomla. Clearing Joomla cache and disabling the cache plugin is the best option not editing the database.

[itoctopus]

Can you read PHP code? The below is the only place where this error is triggered, and it is triggered when saving to the session information to the database, which means there was an error in saving the session information in the database.

Code: Select all

			try
			{
				$db->execute();
			}
			catch (RuntimeException $e)
			{
				throw new RuntimeException(JText::_('JERROR_SESSION_STARTUP'), $e->getCode(), $e);
			}

From the libraries/cms/application/cms.php .

Also, he is not editing the database, he's truncating the #__session table which has zero effects on the website except that people will have to re-login (clearly that's not a problem since they're not able to login in the first place).

[itoctopus]

@Repepioras - the table name isn't #__session, you will need to replace #__ with your database prefix. Sorry for not mentioning that in my previous post.

[Repepioras]

@itoctopus yes I know about prefix I change it but get same error

[Webdongle]

Note: If your website is running with PHP 5.3, this error message may be displayed when trying to log in:
0 Failed to start the session: already started by PHP ($_SESSION is set).
Joomla! 3.6.2 will fix this issue. See https://github.com/joomla/joomla-cms/pull/11430

https://docs.joomla.org/J3.x:Update_fai ... or_message

[Repepioras]

i use 5.6 and 3.6.2 joomla

[Webdongle]

Did you read the rest of the page linked to ?

[Repepioras]

sometime user login, but in session table show guest - 1, userid - 0, username -0, data - joomla|s:29296:"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2..., and when guest enter in site show you are login with some user data....