Fixed Serialised content array not converted to json

Hi,
I still need some help with this. We upgraded from 1.5 to 2.2 and while everything works, we are seeing this error getting logged pretty frequently.

The xf_report table structure is:

mysql> describe xf_report;
+------------------------+-----------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------------------+------+-----+---------+----------------+
| report_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| content_type | varbinary(25) | NO | MUL | NULL | |
| content_id | int(10) unsigned | NO | | NULL | |
| content_user_id | int(10) unsigned | NO | MUL | NULL | |
| content_info | mediumblob | NO | | NULL | |
| first_report_date | int(10) unsigned | NO | | NULL | |
| report_state | enum('open','assigned','resolved','rejected') | NO | MUL | NULL | |
| assigned_user_id | int(10) unsigned | NO | MUL | NULL | |
| comment_count | int(10) unsigned | NO | | 0 | |
| last_modified_date | int(10) unsigned | NO | MUL | NULL | |
| last_modified_user_id | int(10) unsigned | NO | MUL | 0 | |
| last_modified_username | varchar(50) | NO | | | |
| report_count | int(10) unsigned | NO | | 0 | |
+------------------------+-----------------------------------------------+------+-----+---------+----------------+

Reading this thread's earlier posts, it looks like content_info is not getting converted to JSON properly.
What I want to know is how to fix it now that we are running version 2.2.1?

This is the full stack trace:


  • ErrorException: [E_NOTICE] Undefined index: node_id

  • src/XF/Report/Post.php:12
  • Generated by: <<admin>>

  • Nov 6, 2020 at 12:49 PM

Stack trace​

#0 src/XF/Report/Post.php(12): XF::handlePhpError(8, '[E_NOTICE] Unde...', '/home/accurate/...', 12, Array)
#1 src/XF/Report/AbstractHandler.php(19): XF\Report\Post->canViewContent(Object(XF\Entity\Report))
#2 src/XF/Entity/Report.php(45): XF\Report\AbstractHandler->canView(Object(XF\Entity\Report))
#3 src/XF/Mvc/Entity/AbstractCollection.php(320): XF\Entity\Report->canView()
#4 [internal function]: XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}(Object(XF\Entity\Report))
#5 src/XF/Mvc/Entity/AbstractCollection.php(189): array_filter(Array, Object(Closure))
#6 src/XF/Mvc/Entity/AbstractCollection.php(321): XF\Mvc\Entity\AbstractCollection->filter(Object(Closure))
#7 src/XF/Pub/App.php(304): XF\Mvc\Entity\AbstractCollection->filterViewable()
#8 src/XF/Pub/App.php(197): XF\Pub\App->updateModeratorCaches()
#9 src/XF/App.php(2296): XF\Pub\App->start(true)
#10 src/XF.php(465): XF\App->run()
#11 index.php(20): XF::runApp('XF\\Pub\\App')
#12 {main}

Request state​

array(4) {
["url"] => string(17) "/login/keep-alive"
["referrer"] => string(78) "<<forum url>>"
["_GET"] => array(1) {
["/login/keep-alive"] => string(0) ""
}
["_POST"] => array(2) {
["_xfResponseType"] => string(4) "json"
["_xfToken"] => string(8) "********"
}
}
 
Last edited:
Top Bottom