Mysql.options doesn't exist


#1

I am using mysql instead of H2 and am getting the following error in my logs:

±----------------±-
| type | Database
| detail | Database reported: Table ‘mysql.options’ doesn’t exist
| message | General SQL Error
| errorcode | errorCode.sqlError
| extendedinfo |
| tagcontext | {CFML Type::array}
| sql | SELECT opt_id, opt_value
FROM options
WHERE opt_id LIKE ?
| nativeerrorcode | 1146
| sqlstate | 42S02
| queryError | Table ‘mysql.options’ doesn’t exist
| datasource | RAZUNA_SERVER
| tagname | CFQUERY
| template | /opt/razuna/razuna_tomcat_1_9_6/tomcat/webapps/razuna-searchserver/api/authentication.cfc
| line | 70
| column | 4
±----------------±-
{ts ‘2018-12-07 08:18:49’} — Executing Indexing from Cron
{ts ‘2018-12-07 08:18:49’} ---------------------- Config Error. Aborting… !!!

I have seen that there is a page to configure the razuna searchserver DB settings but these are set correctly.

Is this a bug or am I missing something?

Thanks
Chris


#3

Looks like Razuna did not get installed properly.


#4

I’d try and either reinstall, or go through the setup wizard again. Make sure to use MySQL version 5.6, I ran into similar issues when trying to install with MySQL 8