StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8320875
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-30T03:41:21.170
FavoriteCount
0
LastActivityDate
2011-11-30T03:41:21.170
LastEditDate
LastEditorUserId
0
OwnerUserId
1029908
ParentId
7103608
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
I noticed the same issue in one of my applications too. Debugging the problem lead me to discover that CodeIgniter is (was) not properly implementing serialization/unserialization of multi-dimensional arrays. There was actually a bug submitted for that, and I believe they either fixed it or about to fix it. Take a look at the their session lib in Core. <pre><code>function _serialize($data) { if (is_array($data)) { foreach ($data as $key => $val) { if (is_string($val)) { $data[$key] = str_replace('\\', '{{slash}}', $val); } } } else { if (is_string($data)) { $data = str_replace('\\', '{{slash}}', $data); } } return serialize($data); } </code></pre> Notice that it only goes through 1 level of your array and that the ONLY level that gets the slashes replaced. The problem is that you have multi-dimensional array and there's probably data there that's throwing off serialization and wiping your session. We fixed it by extending their session library and creating these calls: <pre><code>class MY_Session extends CI_Session { public function __construct() { parent::__construct(); } function _serialize($data) { $data = $this->_serialize_backslash_recursive($data); return serialize($data); } function _unserialize($data) { $data = @unserialize(strip_slashes($data)); return $this->_unserialize_backslash_recursive($data); } function _serialize_backslash_recursive($data) { if (is_array($data)) { return array_map(array($this,'_serialize_backslash_recursive'), $data); } else { if (is_string($data)) { return str_replace('\\', '{{slash}}', $data); } } return $data; } function _unserialize_backslash_recursive($data) { if (is_array($data)) { return array_map(array($this,'_unserialize_backslash_recursive'), $data); } else { if (is_string($data)) { return str_replace('{{slash}}', '\\', $data); } } return $data; } } </code></pre> This will now go through all the levels properly. Give it a try and see if it works for you.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWeird session behaviour in codeigniter
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAlexey Gerasimov
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.