Cakephp Session Limit – Database – Mssql

This took me hours before I tracked that the error is on database. My cakephp application communicate to mssql. Currently, table cake_sessions has a field cake_sessions.data with the datatype of text. This text does not hold many session variables so I decided to change the datatype from [text] to nvarchar(8000).

Hmmm… nvarchar(MAX) wont solve the problem. For some reason, It does not save session value if the value is in array, weird. Only, nvarchar(8000) will do.

Please let me know, if you have similar problem or better solution than mine.

Tags:

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

You must be logged in to post a comment.