We have problems after upgrading from 4.4.4. to 4.4.7: SQL error ORA-00933

[Navoyenok]

Hello!
Used Database - Oracle
The following errors appear when the WEB-page is displayed on the screen:

SQL error [ORA-00933: SQL command not properly ended] in [SELECT NULL FROM users u WHERE u.userid=3 FOR UPDATE;]
In the System Information panel :

• legal string offset 'value' [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_status_of_zbx() → OracleDbBackend->checkEncoding() → OracleDbBackend->checkDatabaseEncoding() in include/classes/db/OracleDbBackend.php:85]
• Illegal string offset 'parameter' [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_status_of_zbx() → OracleDbBackend->checkEncoding() → OracleDbBackend->checkDatabaseEncoding() in include/classes/db/OracleDbBackend.php:87]
• Illegal string offset 'value' [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_status_of_zbx() → OracleDbBackend->checkEncoding() → OracleDbBackend->checkDatabaseEncoding() in include/classes/db/OracleDbBackend.php:87]

Has anyone encountered such a problem?

[reinaldovp]

Hello, take a look at this https://support.zabbix.com/browse/ZBX-17508
Now Zabbix checks for encoding and charset of the database, it must be UTF8

https://support.zabbix.com/browse/ZBXNEXT-5626

I think that's the reason of your error.
I don't know Oracle and how to change the encoding in Oracle.

[Navoyenok]

Thanks for your answer. This problem resolved in development branch only I will wait for the next release