I installed Zabbix 1.6.6 with mysql 14.12, php 5.2.0 on a debian lenny.
Since the apt-get install did not create the databases I downloaded the tar-file and installed them as described in the PDF.
the frontend starts but on top there is the following Message:
Error in query [select * from rights where userid=2] [Unknown column 'userid' in 'where clause']
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/share/zabbix/include/db.inc.php on line 104
When I log in as admin I get in "reports" the following additional SQL-Error:
SQL error: Unknown column 'value' in 'field list'
Query: insert into profiles (userid,idx,value,valuetype) values (1,'web.menu.reports.last','report1.php',0)
I remove both, the frontend and zabbix-server and re-installed via apt-get
but it didn't help.

Edgar
Since the apt-get install did not create the databases I downloaded the tar-file and installed them as described in the PDF.
the frontend starts but on top there is the following Message:
Error in query [select * from rights where userid=2] [Unknown column 'userid' in 'where clause']
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/share/zabbix/include/db.inc.php on line 104
When I log in as admin I get in "reports" the following additional SQL-Error:
SQL error: Unknown column 'value' in 'field list'
Query: insert into profiles (userid,idx,value,valuetype) values (1,'web.menu.reports.last','report1.php',0)
I remove both, the frontend and zabbix-server and re-installed via apt-get
but it didn't help.

Edgar


Comment