CI Session problem

[eluser]Akinzekeel[/eluser]
The session library renews the session_id in the database regularly for security reasons. That's fine, but how to I keep track of what is connected to that session in the database?

For example, I have a table "cart" with fk_session and fk_article which is basically my own cart library. It works fine for a limited time, but as soon as the session_id changes, the user will lose all articles in his cart because fk_session won't match anymore.

Using userdata() doesn't seem applicable since SQL WHERE and JOIN clauses won't work with serialized strings afaik.

So should I just disable session renewing or is there a better approach to solving this?

(Using CI 2.0, but older versions would be affected as well)