Welcome Guest, Not a member yet? Register   Sign In
Using session ID as foreign key for temporary rows, too volatile since 3.x?
#1

We are using the session ID to piggyback off of the session GC. Search results have a column linking them to the current session, the idea was to have the user have access to those rows during his session and when the sessions get cleaned so do the search results. This has worked pretty well in CI2.x the past years, but since upgrading to 3.x the session ID seems to be more volatile and it changes during a request, before being added to the sessions table (causing foreign key errors when inserting)
I'm starting to think this is not a reliable value to link to anymore.

Can we utilise the 'sess_time_to_update' config setting to get the desired behaviour or should I start investigating a different way of tracking "while a user is logged in"? (FYI we use Ion_auth for authentication)

Thanks in advance,
Alex
Reply


Messages In This Thread
Using session ID as foreign key for temporary rows, too volatile since 3.x? - by alex - 09-13-2018, 11:55 AM



Theme © iAndrew 2016 - Forum software by © MyBB