Trouble Storing an Array

[Gossamer]

I'm currently working on an add-on that is supposed to take the recently posted post_id and post_date and store it in an array on a particular field of the xf_user table. I'm trying to serialize the array, but I keep getting an error when I try to unserialize it.

Here is what I have so far:
User Model

public function getActivityPosts($userId)
{
$posts = $this->_getDb()->fetchOne('
SELECT rp_messages_for_activity AS posts
FROM xf_user
WHERE user_id = ?
', $userId);

return $posts;
}

User Datawriter

public function updateTrackedActivityPosts($userId, $postid, $postdate)
{

/* Get current activity posts from database */
$activityPosts = $this->_getUserModel()->getActivityPosts($userId);

/* Unserialize data */
$activityPosts = unserialize($activityPosts);

/* Add new entry to activityPosts */
$activityPosts[$postid] = $postdate;

/* Serialize data */
$activityPosts = serialize($activityPosts);

$this->set('rp_messages_for_activity', $activityPosts);
}

I keep getting this error:

unserialize(): Error at offset 0 of 2 bytes

1. 
   
2. XenForo_Application::handlePhpError()
3. 
   
4. unserialize() in Goss/RoleplaySystem/DataWriter/User.php at line 23
5. 
   
6. Goss_RoleplaySystem_DataWriter_User->updateTrackedActivityPosts() in Goss/RoleplaySystem/DataWriter/DiscussionMessage/Post.php at line 53
7. 
   
8. Goss_RoleplaySystem_DataWriter_DiscussionMessage_Post->_updateUserPostsForActivity() in Goss/RoleplaySystem/DataWriter/DiscussionMessage/Post.php at line 10
9. 
   
10. Goss_RoleplaySystem_DataWriter_DiscussionMessage_Post->_messagePostSave() in XenForo/DataWriter/DiscussionMessage.php at line 589
11. 
    
12. XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1423
13. 
    
14. XenForo_DataWriter->save() in XenForo/ControllerPublic/Thread.php at line 578
15. 
    
16. XenForo_ControllerPublic_Thread->actionAddReply() in XenForo/FrontController.php at line 351
17. 
    
18. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
19. 
    
20. XenForo_FrontController->run() in C:/xampp/htdocs/xenforo_DEV/index.php at line 13

Any ideas?

 

[Snog]

Your serialized data most likely has an invalid length or data in general.

What does a dump of the serialized data look like?

 

[Gossamer]

Okay, so I think I figured out that issue. My database still had old info from when I was testing saving with unserialized data. I removed that from the field and it looks like the data isn't saving at all now.

This is my DataWriter

class Goss_RoleplaySystem_DataWriter_User extends XFCP_Goss_RoleplaySystem_DataWriter_User
{
protected function _getFields()
{
$fields = parent::_getFields();

$fields['xf_user']['rp_message_count'] = array('type' => self::TYPE_UINT_FORCED, 'default' => 0);
$fields['xf_user']['app_accept_date'] = array('type' => self::TYPE_UINT_FORCED, 'default' => 0);
$fields['xf_user']['rp_messages_for_activity'] = array('type' => self::TYPE_STRING, 'default' => 0);

return $fields;
}

public function updateTrackedActivityPosts($userId, $postid, $postdate)
{

/* Get current activity posts from database */
$activityPosts = $this->_getUserModel()->getActivityPosts($userId);

/* Unserialize data */
$activityPosts = unserialize($activityPosts);

/* Add new entry to activityPosts */
$activityPosts[$postid] = $postdate;

/* Serialize data */
$activityPosts = serialize($activityPosts);

$this->set('rp_messages_for_activity', $activityPosts);

return true;
}

protected function _getUserModel()
{
return $this->getModelFromCache('XenForo_Model_User');
}
}

 

[Gossamer]

Oops, I figured out what I was missing. I forgot to setExistingData. Seems to be good now!