Select all records results in log out

[swar]

Where: /index.php?module=items/items&path=XX

What: In case you have 3513 or more items in the entity and you decide to select them all ("select all records") on the listing page, you are logged out. In case you have 3512 or fewer items, it is fine, you can use select all records without any problems.

How replicate:
1. Create an entity.
2. Add a lot of items to the entity, at least 3513.
3. Go to the listing page of the entity (items/items) and in the selection menu, click on "Select all records".
4. Perform any action (e.g. delete with selected or just click on some link).
5. You are logged out and redirected to log in.

[support]

Usually it can be session issue.
Open config/server.php file and find next line

Code: Select all

define('STORE_SESSIONS', 'mysql'); 

remove mysql so it will looks like this

Code: Select all

define('STORE_SESSIONS', ''); 

[swar]

Thanks, this seems one way to do it.

Thanks to your advice, I also found where is the issue in MySQL and managed to find the fix!

The problem is structure of MySQL table app_sessions. - it does not allow storage of longer strings which causes a problem in case you select a large number of items in rukovoditel. But the fix is easy:

1. Open table app_sessions in PHPMyAdmin.
2. Change type of column value from text to mediumtext or longtext.
3. Problem solved.

I think it would be great if you included this updated table app_sessions to DB update of the next version of rukovoditel. It would totally eliminate the risk of such issues for everybody while using MySQL as session storage.

[support]

Thank you for the suggestion. I will update it for next release.