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!
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}
UPDATE:
This issue was being caused because of a one-time issue with the migration of plugins to github causing db tables to be malformed. Not likely any devs will experience it in the future
Was it fixed? When you try to install an app from scratch does it come up?