1.0 to 1.1 upgrade problems

[festivalman]

Hi, I just tried an upgrade from 1.0 and 1.1 and am running into some db problems with the process. During all of the cat statements to import the various patches into the db, i got a few errors, such as

ERROR 1050 (42S01) at line 1: Table 'images' already exists

and a few others. When I go into the configuration/images options, there's no images defined. In looking through the various .sql files, I'm seeing that there's no checks to see if tables already exist, so it dies a lot where this stuff already is in the db. Any solutions? Thanks. Here's what I ran:

cat ./1.0_to_1.1alpha1/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1alpha2_to_1.1alpha3/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1alpha3_to_1.1alpha4/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1alpha4_to_1.1alpha5/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1alpha8_to_1.1alpha9/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1alpha9_to_1.1alpha10/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1alpha10_to_1.1alpha11/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1alpha11_to_1.1alpha12/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1alpha12_to_1.1beta1/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta1_to_1.1beta2/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta2_to_1.1beta3/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta4_to_1.1beta5/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta5_to_1.1beta6/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta6_to_1.1beta7/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta7_to_1.1beta8/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta8_to_1.1beta9/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta9_to_1.1beta10/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta11_to_1.1beta12/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

cat ./1.1beta12_to_1.1/mysql/patch.sql |/usr/local/mysql/bin/mysql zabbix -u zabbix -p

[robertjw]

Upgrade Errors

I just tried exactly as you suggested. I fared somewhat better than you did, but I'm not sure if it will work or not. Here were the errors I found:

ERROR 13 at line 53: Can't get stat of 'Hub.png' (Errcode: 2)
ERROR 1051 at line 5: Unknown table 'escalation_rules'