Upgrade error

[firque]

well error . i must have done something wrong during the upgrade from 1.6 to 1.8.1

i could not drop the indexes at all. it showed my errors on non exsisting indexes while using the commands below.
alter table dhosts drop index dhosts_1;
alter table dservices drop index dservices_1;
alter table httptest drop index httptest_2;
alter table httptest drop index httptest_3;
alter table history_log drop index history_log_2;
alter table history_text drop index history_text_2;
alter table actions drop index actions_1;
alter table escalations drop index escalations_2;
alter table graphs_items drop index graphs_items_1;
alter table graphs_items drop index graphs_items_2;
alter table services drop index services_1; i am pretty sure i stopped al possible processes before running the patch script.
after this i continued with the setup (while crossing my fingers) and offcourse it is not working and it show this errors.

• Error in query [SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 1 AND g.usrgrpid = ug.usrgrpid AND g.debug_mode = 1 LIMIT 1 OFFSET 0] [Unknown column 'g.debug_mode' in 'where clause']
• mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/data/srv/www/htdocs/include/db.inc.php:546]
• mysql_free_result(): supplied argument is not a valid MySQL result resource[/data/srv/www/htdocs/include/db.inc.php:548]

i guess the errors have to do with the fact that the indexes where not dropped and the patch script did not run so i am wondering why i could not drop the indexes. at the moment i am trying the upgrade process again on another virtual machine but still this issue bothers me.

kind regards all

FIXED

[firque]

forget about it. i fixed it :-)

[alfco72]

How to solve that error ???

well error . i must have done something wrong during the upgrade from 1.6 to 1.8.1

i could not drop the indexes at all. it showed my errors on non exsisting indexes while using the commands below.
alter table dhosts drop index dhosts_1;
alter table dservices drop index dservices_1;
alter table httptest drop index httptest_2;
alter table httptest drop index httptest_3;
alter table history_log drop index history_log_2;
alter table history_text drop index history_text_2;
alter table actions drop index actions_1;
alter table escalations drop index escalations_2;
alter table graphs_items drop index graphs_items_1;
alter table graphs_items drop index graphs_items_2;
alter table services drop index services_1; i am pretty sure i stopped al possible processes before running the patch script.
after this i continued with the setup (while crossing my fingers) and offcourse it is not working and it show this errors.

• Error in query [SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 1 AND g.usrgrpid = ug.usrgrpid AND g.debug_mode = 1 LIMIT 1 OFFSET 0] [Unknown column 'g.debug_mode' in 'where clause']
• mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/data/srv/www/htdocs/include/db.inc.php:546]
• mysql_free_result(): supplied argument is not a valid MySQL result resource[/data/srv/www/htdocs/include/db.inc.php:548]

i guess the errors have to do with the fact that the indexes where not dropped and the patch script did not run so i am wondering why i could not drop the indexes. at the moment i am trying the upgrade process again on another virtual machine but still this issue bothers me.

kind regards all

FIXED

Hello, Could you tell me how to solve that error ?
Thanks

[itemhunter]

Ditto

Ditto. How was this resolved?

[ironstorm]

[SOLVED] Upgrade error

Ditto. How was this resolved?

I'm a little late to this party, but I just completed the upgrade of Zabbix 1.6.4 to Zabbix 1.8.1 as part of an Ubuntu dist-upgrade from Karmic to Lucid.

The way I resolved it in my case was:

sudo sh -c "zcat /usr/share/doc/zabbix-server-mysql/examples/patch.sql.gz | mysql -f -D zabbix" # note -f 'force' is required.
sudo /etc/init.d/zabbix-server restart

The key being that force (-f) switch, which was needed because the patch SQL script failed to complete on the first run with this message:

ERROR 1061 (42000) at line 68: Duplicate key name 'graphs_items_1'

I presume this was because this key was already there in 1.6.4...?

-G