Missing Stream error on inbox page

Failed to load resource: the server responded with a status of 412 (Precondition Failed)
Q.js:15999 Q: Q.request xhr: 412 {“errors”: [{“message”:“DbQuery Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘publisherId’ in ‘field list’ … Query was: SELECT userId,id,publisherId,streamName,description,attributes,insertedTime,updatedTime\nFROM soulstice.assets_charge \nWHERE userId = ‘hyxwdjax’ \nORDER BY insertedTime DESC “,“code”:10005,“line”:803,“file”:”/var/www/html/qp/Q/Platform/platform/classes/Db/Query/Mysql.php”,“trace”:[{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Db/Query/Mysql.php”,“line”:1666,“function”:“execute”,“class”:“Db_Query_Mysql”,“type”:“->”},{“file”:“/var/www/html/qp/Q/Platform/platform/plugins/Assets/handlers/Assets/history/response/tool.php”,“line”:113,“function”:“fetchDbRows”,“class”:“Db_Query_Mysql”,“type”:“->”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q.php”,“line”:1212,“function”:“Assets_history_response_tool”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q.php”,“line”:1092,“function”:“handle”,“class”:“Q”,“type”:“::”},{“file”:“/var/www/html/qp/Q/Platform/platform/handlers/Q/response/default.php”,“line”:34,“function”:“event”,“class”:“Q”,“type”:“::”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q.php”,“line”:1212,“function”:“Q_response_default”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q.php”,“line”:1092,“function”:“handle”,“class”:“Q”,“type”:“::”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q/Response.php”,“line”:83,“function”:“event”,“class”:“Q”,“type”:“::”},{“file”:“/var/www/html/qp/Q/Platform/platform/handlers/Q/response.php”,“line”:88,“function”:“fillSlot”,“class”:“Q_Response”,“type”:“::”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q.php”,“line”:1212,“function”:“Q_response”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q.php”,“line”:1092,“function”:“handle”,“class”:“Q”,“type”:“::”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q/Dispatcher.php”,“line”:525,“function”:“event”,“class”:“Q”,“type”:“::”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q/Dispatcher.php”,“line”:411,“function”:“response”,“class”:“Q_Dispatcher”,“type”:“::”},{“file”:“/var/www/html/qp/Q/Platform/platform/classes/Q/ActionController.php”,“line”:69,“function”:“dispatch”,“class”:“Q_Dispatcher”,“type”:“::”},{“file”:“/var/www/html/qp/Yoga/web/action.php”,“line”:11,“function”:“execute”,“class”:“Q_ActionController”,“type”:“::”}],“fields”:[“PDOException”],“classname”:“Q_Exception_DbQuery”}]}
Q.js:16475 DbQuery Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘publisherId’ in ‘field list’ … Query was: SELECT userId,id,publisherId,streamName,description,attributes,insertedTime,updatedTime
FROM soulstice.assets_charge
WHERE userId = ‘hyxwdjax’
ORDER BY insertedTime DESC
Q.request.options.onCancel @ Q.js:16475
history.js:93 Assets/history: DbQuery Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘publisherId’ in ‘field list’ … Query was: SELECT userId,id,publisherId,streamName,description,attributes,insertedTime,updatedTime
FROM soulstice.assets_charge
WHERE userId = ‘hyxwdjax’
ORDER BY insertedTime DESC

The error is self-explanatory: the publisherId firld isn’t in the table. Check the database. Perhaps there is newer plugin version that adds this column? You can try to add it manually.

Check GitHub for the newest Qbix Platform. All the plugins have been added there too!

1 Like

I pull in all changes for the assets plugin from the git repo. I’m now getting more issues…