Zabbix 1.5.2 & Oracle: error en table profile

[afullana]

Hello,

I install the version 1.5.2 with Oracle 10G and the Web interface gives the error attached to the end in all screens.

On the table PROFILES is a field RESOURCE and this is a word reserved in Oracle.

Can you change the name of the field?

Sorry for my english

Error----------------------------
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01747: especificacion no valida de usuario.tabla.columna, tabla.columna o columna[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-01747: especificacion no valida de usuario.tabla.columna, tabla.columna o columna] in [INSERT INTO profiles (profileid,userid,idx,value,value2,resource,valuet ype) VALUES (1,1,'web.menu.view.last','dashboard.php','','',0)]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.0' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.1' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.2' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.3' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.4' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.0' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.1' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.2' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.3' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00936: falta una expresion[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-00936: falta una expresion] in [SELECT value,value2,resource,valuetype FROM profiles WHERE userid=1 AND idx='web.history.4' ORDER BY profileid ASC]
* Undefined variable: stid[/home/zabbix/public_html/include/db.inc.php:382]
* ocierror() expects parameter 1 to be resource, null given[/home/zabbix/public_html/include/db.inc.php:382]
* SQL error [] in []
* ocifetchinto() expects parameter 1 to be resource, boolean given[/home/zabbix/public_html/include/db.inc.php:496]
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01747: especificacion no valida de usuario.tabla.columna, tabla.columna o columna[/home/zabbix/public_html/include/db.inc.php:448]
* SQL error [ORA-01747: especificacion no valida de usuario.tabla.columna, tabla.columna o columna] in [INSERT INTO profiles (profileid,userid,idx,value,value2,resource,valuet ype) VALUES (1,1,'web.history.0','Dashboard','dashboard.php',' ',2)]

[Aly]

There is spacial thread for Alpha & Beta releases!

http://www.zabbix.com/forum/forumdisplay.php?f=10

This bug already fixed in the latest SVN.

[afullana]

sorry, is posible move this thread to the correct forum?

Thanks