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…

Run the installer, one of the scripts adds this column to the table.

The previous error is gone but now seeing this one in console:

Assets.js:11 Uncaught TypeError: Cannot set properties of undefined (setting ‘Assets/canPayForStreams’)
at Assets.js:11:55
at Assets.js:887:3

Also, installer is failing on assets plugin:

Plugin ‘Assets’ schema on ‘Assets’ (SQL 1.0.17, PHP 1.0.16) is already installed

Upgrading ‘Assets’ on ‘Assets’ schema to version: SQL 1.0.177

Processing SQL file: 1.0.174-Assets.mysql You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{communityId}} COMMENT ‘community managing the credits’

AFTER reason,

CHANGE …’ at line 2

Query was: ALTER TABLE assets_credits

ADD COLUMN communityId varbinary(31) NOT NULL DEFAULT {{communityId}} COMMENT ‘community managing the credits’

AFTER reason,

CHANGE COLUMN credits amount DECIMAL(10, 4) NOT NULL

in /var/www/html/qp/Q/Platform/platform/classes/Db/Query/Mysql.php (803)

#0 /var/www/html/qp/Q/Platform/platform/classes/Q/Plugin.php(475): Db_Query_Mysql->execute()

#1 /var/www/html/qp/Q/Platform/platform/classes/Q/Plugin.php(907): Q_Plugin::installSchema()

#2 /var/www/html/qp/Q/Platform/platform/scripts/app.php(250): Q_Plugin::installPlugin()

#3 /var/www/html/qp/Yoga/scripts/Q/install.php(15): include(‘…’)

#4 {main}