HI,
After upgrading from 9.19.8 to 11.1 I get error on “Search engine query” when accessing the settings tab in the console.
In the log I see the following errors:
2015-11-12 15:59:05 [0.000306] [31.168.80.201] [607122753] [API] [KalturaFrontController->errorHandler] NOTICE: /opt/kaltura/app/alpha/apps/kaltura/lib/db/DbManager.php line 258 - Undefined offset: 0
2015-11-12 15:59:05 [0.000344] [31.168.80.201] [607122753] [API] [DbManager::connectFallbackLogic] ERR: exception ‘Exception’ with message 'failed to connect to ’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/db/DbManager.php(279): KalturaLog::err(‘failed to conne…’)
2015-11-12 15:59:05 [0.001723] [31.168.80.201] [607122753] [API] [KalturaPDO->queryAndFetchAll] DEBUG: Sql took - 0.0014638900756836 seconds
2015-11-12 15:59:05 [0.000602] [31.168.80.201] [607122753] [API] [kCoreException->__construct] ERR: exception ‘kCoreException’ with message ‘Invalid sphinx query [SELECT id FROM kaltura_kuser WHERE partner_id = 102 AND is_admin = 1 AND login_data_id > 0 AND kuser_status <> 2 AND kuser_status = 1 AND type = 0 AND MATCH(’( @role_ids “^102ri2$” ) ( @puser_id HASVALUE102 )’) LIMIT 30 OPTION ranker=none, max_matches=30, comment=’@KALTURA_COMMENT@’]
SQLSTATE error code [42000]
Driver error message [index kaltura_kuser: no such filter attribute ‘type’]’ in /opt/kaltura/app/plugins/sphinx_search/lib/SphinxCriteria.php:153
and after that (when trying to upload file), I got:
2015-11-12 16:12:52 [0.000841] [31.168.80.201] [776764661] [API] [KalturaPDO->exec] DEBUG: Sql took - 0.00066184997558594 seconds
2015-11-12 16:12:52 [0.000245] [31.168.80.201] [776764661] [API] [kSphinxSearchManager->execSphinx] ERR: exception ‘Exception’ with message ‘unknown column: ‘user_names’’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/plugins/sphinx_search/lib/kSphinxSearchManager.php(432): KalturaLog::err(‘unknown column:…’)
so how to fix the sphinx?