Problem with graphs on oracle

[kari]

Hi,
I've just migrated from mysql to Oracle. The server process is working as it should, i can see that the monitored values are populated.

However i have a problem with the frontend. Graphs are not showing at all. At first i tought that this was a php-gd problem but nope. I get the following error in apache's error.log:

[Thu Nov 02 14:30:31 2006] [error] [client 193.x.x.x] PHP Warning: ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch in /usr/share/zabbix/include/db.inc.php on line 185, referer: http://mysite.org/zabbix/history.php...h&itemid=20009

The box itself is a Ubuntu 6.10 server, Oracle XE 10.2, apache2 and php4.

Thank you,

Kari

More info about the problem: http://forums.oracle.com/forums/thre...sageID=1488300

I'll download version 9 and test with that.

[bibi23]

fix

hi,

i post update for this problem with oracle:

http://www.zabbix.com/forum/showthr...99&page=2&pp=10

[kari]

I just looked at my graph.inc.php and the correction was already there as you posted: ' and clock<='.$to_time.' group
by itemid, i' //' round('.$x.'*(mod(clock+'.$z.','.$p.'))/('.$p.'),0)',

This did not fix the problem.

Thx,

Kari

[bibi23]

you should replace i' by round('.$x.'*(mod(clock+'.$z.','.$p.'))/('.$p.'),0)'
for the 3 lines as mentioned.

thx

[kari]

Thank you very much!

I just tought it was the other way round, ie that the 'i //' should be there.

I owe you one......

Thx again,

Kari

[kari]

Hi,
i just upgraded to version 1.1.4 and the graph issue appeared again! Anyone that has solved this?

Thank you,

Kari