Problems Upgrading to 1.5

[Melkor]

Hi,
I have Zabbix 1.42 in a Debian Etch, yesterday I tried to upgrade it to a 1.5 but I´m getting problems with MySQL database (the same that if I upgrade to 1.44).

I haven´t found any documents or manual to upgrade Zabbix 1.4 (just the old documentation to upgrade from 1.1) and I want to know the exactly/better process to upgrade it.

Thank u in advance

[themons]

I also can't upgrade my DB shema first I suppose there is no need to upgrade the DB

But when I launch the GUI i have some error like this

    * Error in query [SELECT COUNT(g.usrgrpid) as grp_count FROM usrgrp g, users_groups ug WHERE ug.userid = '2' AND g.usrgrpid = ug.usrgrpid AND g.gui_access = 1] [Unknown column 'g.gui_access' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/opt/jmo/zabbix-1.5/frontends/php/include/db.inc.php:411]
    * Error in query [SELECT COUNT(g.usrgrpid) as grp_count FROM usrgrp g, users_groups ug WHERE ug.userid = '2' AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1] [Unknown column 'g.users_status' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/opt/jmo/zabbix-1.5/frontends/php/include/db.inc.php:411]

[Alexei]

We do not provide upgrade scripts to unstable releases. You may do a fresh install of 1.5.

[themons]

The aim is to test the new version off zabbix with our production DB export. How can i import data in thze new shema ?

[Alexei]

It is too early to provide any migration scripts as the new database schema is not finalized yet.

[bbrendon]

Hmm. I remember reading in the forum that someone upgraded successfully and actually had some great things to say about the new version. I don't remember who though. I wouldn't expect anything from alexei, he's still working on the code and probably not interested in upgrades right now. Good luck searching

I would run a diff on the 1.4 schema and 1.6 schema and see if you can figure it out yourself.

[AlexJJ]

Some warnings during install process

It is too early to provide any migration scripts as the new database schema is not finalized yet.

I performed a clean install of 1.5.2 on my CentOS 4.4 SE box (LAMP, PHP4) (was Zabbix 1.1 early), it seems that here we have some problems with mysql tables structure. I did not use any migration procedures, just removed the database.
I can't login - the program hangs and during install I have the following messages:
Undefined variable: ZBX_SERVER[/home/zbxweb/***/setup.inc.php:685]
Undefined variable: ZBX_SERVER_PORT[/home/zbxweb/***/setup.inc.php:686]
Undefined index: DB[/home/zbxweb/***/setup.inc.php:678]
Database is'nt filled.
After I filled it myself using create/*.sql folder, I see the following errors, that I just sent you in private message.
Thank you!