Upgrade from ZABBIX 1.1alpha10 to the latest Version

[masterd01]

Hello,
i know, that the Database is a critical Element in a Zabbix-System. So i was unsure to Upgrade my Old Version ZABBIX 1.1alpha10 to a newerone.
Now i'm installing a new Webserver and so i'd like to Upgrade my Zabbix for y newer Version. Like everyone i don't want to loose any archived-data and alarms.
So i tryed to export and import the Database and tryed only to Patch it with the last patch.sql. That don't work :-(
After that i tryed to patch from Version to Version the Database (about 400 MB big). The first Updates from Alpha to Beta works without any fault. But some tables weren't found. I continoued but at last there are too many faults, so the last Version won't work.
You you give me a short Howto which Versions i had to Update from the ZABBIX 1.1alpha10 to the lastone without loosing Data ?

Kind regards,

MasterD

[richlv]

ouch. that's old.
1. verify that there are no db schema changes since last alpha/beta/whatnot and next stable version;
2. if there are errors with some patch, do not continue with others - resolve the errors first. maybe also paste exact first errors here, if you can't figure it out

[masterd01]

Hi,

i know that's an old version. But i'll do my very best to update it.

The Update makes this failure:

ERROR 1091 (42000) at line 7: Can't DROP 'alerts_1'; check that column/key exists
ERROR 1060 (42S21) at line 1: Duplicate column name 'esc_period'

After looking in the Webbrowser i see these Messages:

    * Error in query [SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('3d765853e8f7bcfe9148427c411d180e',2,1241600719,0)] [Unknown column 'status' in 'field list']
    * Error in query [SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid ] [Unknown column 'g.gui_access' in 'field list']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 limit 1] [Unknown column 'g.users_status' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Undefined index: autologin[/srv/www/htdocs/zabbix/include/perm.inc.php:107]
    * Error in query [SELECT * FROM nodes WHERE nodeid=0] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Undefined index: lang[/srv/www/htdocs/zabbix/include/config.inc.php:164]
    * Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Unknown column 'configid' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Use of undefined constant S_INSTALLATION - assumed 'S_INSTALLATION'[/srv/www/htdocs/zabbix/include/profiles.inc.php:342]
    * Unable to select configuration
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT * FROM nodes WHERE nodeid=0] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table 'zabbix.nodes' doesn't exist]
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Unknown column 'configid' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Unable to select configuration

The Table alerts_1 issn't found because it's not not there. Where comes it from?

If i understand the Browser-Failures correctly, zabbix tryed to find db.inc.php witch is used in older Versions bzw. not in newer ?
The newer-Version was running (without the older-db) correctly without db.inc.php ?

I updateded from

zabbix-1.1alpha11
zabbix-1.1alpha12
zabbix-1.1beta1
zabbix-1.1beta2
zabbix-1.1beta3
zabbix-1.1beta4
zabbix-1.1beta5
zabbix-1.1beta6
zabbix-1.1beta7
zabbix-1.1beta8
zabbix-1.1beta9
zabbix-1.1beta10
zabbix-1.1beta11
zabbix-1.1beta12
zabbix-1.3
zabbix-1.3.1
zabbix-1.3.2
zabbix-1.3.3
zabbix-1.3.4
zabbix-1.3.5
zabbix-1.3.6
zabbix-1.3.7
zabbix-1.3.8
zabbix-1.4
zabbix-1.4.1
zabbix-1.4.2
zabbix-1.4.3
zabbix-1.4.4
zabbix-1.4.5
zabbix-1.4.6
zabbix-1.6
zabbix-1.6.1
zabbix-1.6.2
zabbix-1.6.3
zabbix-1.6.4

MasterD01

[richlv]

at which point exactly do upgrade failures occur ?
that is, going from which version to which ?

[masterd01]

Hi,
after searching in the Board ive found another user with the same Problem.
Now i've added the zabbix.nodes to the MySQL-DB and this failture is over.

I think there is now a Problem with some row in a table. Do you know witchone ?

    * Error in query [SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='3d765853e8f7bcfe9148427c411d180e' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1241603250) OR (u.autologout=0)) AND (u.userid div 100000000000000) in (0) ] [Unknown column 's.status' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('99bfcc88e01d55e2cf50fb74a81f6782',2,1241603250,0)] [Unknown column 'status' in 'field list']
    * Error in query [SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid ] [Unknown column 'g.gui_access' in 'field list']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 limit 1] [Unknown column 'g.users_status' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [UPDATE sessions SET status=1 WHERE sessionid='99bfcc88e01d55e2cf50fb74a81f6782'] [Unknown column 'status' in 'field list']
    * Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Unknown column 'configid' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Use of undefined constant S_INSTALLATION - assumed 'S_INSTALLATION'[/srv/www/htdocs/zabbix/include/profiles.inc.php:342]
    * Unable to select configuration
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Unknown column 'configid' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Unable to select configuration

[masterd01]

Hi,
hier are the failure-results with versionsnumbers:

Version:/install/zabbix-alt/zabbix-1.1alpha11
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1alpha12
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta1
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta2
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta3
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta4
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta5
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta6
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta7
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta8
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta9
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta10
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta11
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.1beta12
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.3
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.3.1
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.3.2
ERROR 1050 (42S01) at line 1: Table 'images' already exists
Version:/install/zabbix-alt/zabbix-1.3.3
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.3.4
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.3.5
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.3.6
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.3.7
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.3.8
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.4
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.4.1
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.4.2
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.4.3
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.4.4
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.4.5
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.4.6
ERROR 1005 (HY000) at line 1: Can't create table './zabbix/acknowledges_tmp.frm' (errno: 121)
Version:/install/zabbix-alt/zabbix-1.6
ERROR 1091 (42000) at line 7: Can't DROP 'alerts_1'; check that column/key exists
Version:/install/zabbix-alt/zabbix-1.6.1
ERROR 1060 (42S21) at line 1: Duplicate column name 'esc_period'
Version:/install/zabbix-alt/zabbix-1.6.2
ERROR 1060 (42S21) at line 1: Duplicate column name 'esc_period'
Version:/install/zabbix-alt/zabbix-1.6.3
ERROR 1060 (42S21) at line 1: Duplicate column name 'esc_period'
Version:/install/zabbix-alt/zabbix-1.6.4
ERROR 1060 (42S21) at line 1: Duplicate column name 'esc_period'

The Problem with the "alerts_1" i've fixed with copying another table.

The Browser shows this Problems:

    * Error in query [INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('ba7174b115bb1007111b03ece6bd75f8',2,1241766566,0)] [Unknown column 'status' in 'field list']
    * Error in query [SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid ] [Unknown column 'g.gui_access' in 'field list']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 limit 1] [Unknown column 'g.users_status' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Undefined index: autologin[/srv/www/htdocs/zabbix/include/perm.inc.php:107]
    * Undefined index: lang[/srv/www/htdocs/zabbix/include/config.inc.php:164]
    * Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Unknown column 'configid' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Use of undefined constant S_INSTALLATION - assumed 'S_INSTALLATION'[/srv/www/htdocs/zabbix/include/profiles.inc.php:342]
    * Unable to select configuration
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Unknown column 'r.groupid' in 'on clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Unknown column 'configid' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/srv/www/htdocs/zabbix/include/db.inc.php:519]
    * Unable to select configuration

Could you see where the Problem is ?

Thanks a lot

[richlv]

well, you are trying to upgrade from a very old alpha release. that is going to be tricky as (at least for some time now) upgrades are only supported through the released versions.

you don't have to upgrade between dot releases like 1.4.1 and 1.4.2 - only 1.4 and 1.6 change warrants a db patch.

i would suggest backing down, patching the thing to 1.1 final, installing 1.1 frontend and making sure that works. if it does not, look at the changes in schema between your version and 1.1 final, create patch for that yourself. when done, continue on with release patches only. if that succeeds, try latest frontend. again, if not, verify with frontend for each release and fix the patches as necessary.