Table Structure to Handle sessions from the DB in Concrete 5.7?

Permalink 1 user found helpful
Hi!

I was wondering if anyone knew the tables/table layout required to handle sessions from the database?

I'm having problems with running sessions the normal method with my current web host provider (They haven't yet been helpful in resolving the issue) so I'd like to give this a go but don't know the required tables.

I've enabled table sessions following instructions in this post:
https://www.concrete5.org/documentation/how-tos/developers/enable-da...

and I've tried the table design from:
https://www.concrete5.org/documentation/how-tos/developers/handle-se...
But I assume this was the design required for 5.6 as it doesn't work.

Has anyone else already done this? and hence know the table layout? I can't find any more references anywhere.

Thanks!

 
Mainio replied on at Permalink Best Answer Reply
Mainio
In 5.7 the Sessions table is automatically installed with concrete5.

Here is its structure:
https://github.com/concrete5/concrete5/blob/7054355abd9e40ca4df386d1...
ginbin replied on at Permalink Reply
Thanks Mainio for your quick help!

After looking at that table structure, I've gone back through the database and figured out my development mySQL server defaulted all the tables to lowercase whilst the live server did not. (Hence couldn't find the table).

Thanks for that link too, good to be able to easily view the database structure!


Really Appreciate it!
Mainio replied on at Permalink Reply
Mainio
Cool.

Hopefully you are also aware of this tool:
https://www.concrete5.org/marketplace/addons/database-migration...