Hello Ivo, here the Output. There are some warnings and the same error again. If you like I can send you the database. Regards, Philipp
mysql> source pandoradb_migrate_4.1_to_5.0.mysql.sql;
Query OK, 0 rows affected, 1 warning (0.02 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1060 (42S21): Duplicate column name 'id_agent'
ERROR 1060 (42S21): Duplicate column name 'url_address'
ERROR 1060 (42S21): Duplicate column name 'quiet'
ERROR 1060 (42S21): Duplicate column name 'normal_count'
ERROR 1060 (42S21): Duplicate column name 'warning_count'
ERROR 1060 (42S21): Duplicate column name 'critical_count'
ERROR 1060 (42S21): Duplicate column name 'unknown_count'
ERROR 1060 (42S21): Duplicate column name 'notinit_count'
ERROR 1060 (42S21): Duplicate column name 'total_count'
ERROR 1060 (42S21): Duplicate column name 'fired_count'
ERROR 1060 (42S21): Duplicate column name 'update_module_count'
ERROR 1060 (42S21): Duplicate column name 'update_alert_count'
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1060 (42S21): Duplicate column name 'special_day'
ERROR 1060 (42S21): Duplicate column name 'wizard_level'
ERROR 1060 (42S21): Duplicate column name 'monday'
ERROR 1060 (42S21): Duplicate column name 'tuesday'
ERROR 1060 (42S21): Duplicate column name 'wednesday'
ERROR 1060 (42S21): Duplicate column name 'thursday'
ERROR 1060 (42S21): Duplicate column name 'friday'
ERROR 1060 (42S21): Duplicate column name 'saturday'
ERROR 1060 (42S21): Duplicate column name 'sunday'
ERROR 1060 (42S21): Duplicate column name 'periodically_time_from'
ERROR 1060 (42S21): Duplicate column name 'periodically_time_to'
ERROR 1060 (42S21): Duplicate column name 'periodically_day_from'
ERROR 1060 (42S21): Duplicate column name 'periodically_day_to'
ERROR 1060 (42S21): Duplicate column name 'type_downtime'
ERROR 1060 (42S21): Duplicate column name 'type_execution'
ERROR 1060 (42S21): Duplicate column name 'type_periodicity'
ERROR 1060 (42S21): Duplicate column name 'id_user'
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 274 rows affected (0.01 sec)
Records: 274 Duplicates: 0 Warnings: 0
ERROR 1060 (42S21): Duplicate column name 'all_modules'
ERROR 1005 (HY000): Can't create table 'pandora.tplanned_downtime_modules' (errno: 150)
Query OK, 284 rows affected (0.03 sec)
Records: 284 Duplicates: 0 Warnings: 0
Query OK, 284 rows affected (0.01 sec)
Records: 284 Duplicates: 0 Warnings: 0
Query OK, 284 rows affected, 1 warning (0.00 sec)
Records: 284 Duplicates: 0 Warnings: 1
Query OK, 284 rows affected, 1 warning (0.01 sec)
Records: 284 Duplicates: 0 Warnings: 1
Query OK, 284 rows affected, 1 warning (0.01 sec)
Records: 284 Duplicates: 0 Warnings: 1
Query OK, 284 rows affected (0.01 sec)
Records: 284 Duplicates: 0 Warnings: 0
Query OK, 284 rows affected (0.01 sec)
Records: 284 Duplicates: 0 Warnings: 0
Query OK, 284 rows affected, 1 warning (0.00 sec)
Records: 284 Duplicates: 0 Warnings: 1
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
[...]
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.03 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.02 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.03 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.02 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected, 1 warning (0.03 sec)
Records: 479 Duplicates: 0 Warnings: 1
Query OK, 479 rows affected, 1 warning (0.02 sec)
Records: 479 Duplicates: 0 Warnings: 1
Query OK, 479 rows affected, 1 warning (0.03 sec)
Records: 479 Duplicates: 0 Warnings: 1
Query OK, 479 rows affected (0.02 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.03 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.03 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.02 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.02 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected, 1 warning (0.02 sec)
Records: 479 Duplicates: 0 Warnings: 1
Query OK, 479 rows affected, 1 warning (0.02 sec)
Records: 479 Duplicates: 0 Warnings: 1
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 47 rows affected (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 0
Query OK, 47 rows affected (0.01 sec)
Records: 47 Duplicates: 0 Warnings: 0
Query OK, 47 rows affected (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 0
Query OK, 47 rows affected, 1 warning (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 1
Query OK, 47 rows affected, 1 warning (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 1
Query OK, 47 rows affected, 1 warning (0.01 sec)
Records: 47 Duplicates: 0 Warnings: 1
Query OK, 47 rows affected (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 0
Query OK, 47 rows affected (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 0
Query OK, 47 rows affected (0.01 sec)
Records: 47 Duplicates: 0 Warnings: 0
Query OK, 47 rows affected (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 0
Query OK, 47 rows affected, 1 warning (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 1
Query OK, 47 rows affected, 1 warning (0.00 sec)
Records: 47 Duplicates: 0 Warnings: 1
Query OK, 47 rows affected, 1 warning (0.01 sec)
Records: 47 Duplicates: 0 Warnings: 1
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 138 rows affected (0.00 sec)
Records: 138 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 16 rows affected (0.00 sec)
Records: 16 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
ERROR 1005 (HY000): Can't create table 'pandora.#sql-20f_11c' (errno: 150)
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.03 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 11 rows affected (0.00 sec)
Records: 11 Duplicates: 0 Warnings: 0
Query OK, 11 rows affected (0.00 sec)
Records: 11 Duplicates: 0 Warnings: 0
Query OK, 11 rows affected (0.00 sec)
Records: 11 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 0 rows affected, 1 warning (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.01 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
Query OK, 4 rows affected (0.01 sec)
Records: 4 Duplicates: 0 Warnings: 0
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.01 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.01 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.01 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.01 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.01 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 12 rows affected (0.00 sec)
Records: 12 Duplicates: 0 Warnings: 0
Query OK, 12 rows affected (0.00 sec)
Records: 12 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
Query OK, 1 row affected, 1 warning (0.00 sec)
Query OK, 1 row affected, 1 warning (0.00 sec)
[...]
Query OK, 0 rows affected (0.00 sec)
Query OK, 479 rows affected (0.01 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.01 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 479 rows affected (0.01 sec)
Records: 479 Duplicates: 0 Warnings: 0
Query OK, 284 rows affected (0.01 sec)
Records: 284 Duplicates: 0 Warnings: 0
Query OK, 284 rows affected (0.01 sec)
Records: 284 Duplicates: 0 Warnings: 0
Query OK, 284 rows affected (0.00 sec)
Records: 284 Duplicates: 0 Warnings: 0
Query OK, 284 rows affected (0.01 sec)
Records: 284 Duplicates: 0 Warnings: 0
Query OK, 7 rows affected (0.00 sec)
Records: 7 Duplicates: 0 Warnings: 0
Query OK, 7 rows affected (0.00 sec)
Records: 7 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 20 rows affected (0.00 sec)
Rows matched: 20 Changed: 20 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 618 rows affected (0.01 sec)
Records: 618 Duplicates: 0 Warnings: 0
Query OK, 16 rows affected (0.00 sec)
mysql>
After this, the start of pandora shows the following log:
2014-08-15 07:36:10 - pandoraserver Starting Pandora FMS Server. Error logging activated.
DBD::mysql::db do failed: Unknown column 'last_error' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.
DBD::mysql::db do failed: Unknown column 'last_error' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.
DBD::mysql::db do failed: Unknown column 'last_error' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.
DBD::mysql::db do failed: Unknown column 'last_error' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 811.