Hello, I've upgraded from 6.0SP4 to 6.0SP5 on my Testsystem. When I try to create an Agent-Group I get an Error ("There was a problem creating group"). For debugging purposes i changed (in include/functions_db.php)
case "mysql":
return mysql_db_process_sql($sql, $rettype, $dbconnection, $cache);
break;
to
case "mysql":
return @mysql_db_process_sql($sql, $rettype, $dbconnection, $cache);
break;
so i could can see PHP-Errors. I get
SQL error: Unknown column 'password' in 'field list' ('INSERT INTO `tgrupo` (`nombre`, `icon`, `parent`, `disabled`, `custom_id`, `id_skin`, `description`, `contact`, `propagate`, `other`, `password`) VALUES ('ghgh','',0,0,'ghgh','','','',0,'','')')
So i looked at the Database and yes, there is no such column "password".
mysql> select * from tgrupo;
+----------+--------------+-----------------+--------+-----------+----------+-----------+---------+---------------------------------------------------------+-------------------------+-------+
| id_grupo | nombre | icon | parent | propagate | disabled | custom_id | id_skin | description | contact | other |
+----------+--------------+-----------------+--------+-----------+----------+-----------+---------+---------------------------------------------------------+-------------------------+-------+
I am a little confused, because the Upgrade-Documention states that
The upgrading / migrating process from level versions that are the same implies that versions don't come with any database changes.
Does this imply that i may have done something wrong in earlier updates? What can I do to fix the Problem in a clean way (without just adding that column manually)? Additional Information:
- I am in CentOS
- I already tried upgrading with rpm -U --force ...
I am thankful for any information. Regards.
