Horde database deleted by cPanel upgrade!

[Ivalde]

From within WHM this evening I carried out a cPanel upgrade, to receive the latest version cPanel 11.24.5-S38506 - WHM 11.24.2 - X 3.9.

The upgraded system ends up in the following error message when I log into the Horde webmail:

A fatal error has occurred
DB Error: no such database
Details have been logged for the administrator

The log file tells me the following:
HORDE [emergency] [horde] DB Error: no such database: [nativecode=1049 ** Unknown database 'horde'] …

What did happen with the Horde database during the cPanel upgrade process? Did the upgrade process delete the Horde database? Unbelievable!!! In such case, all the user's preferences are gone!!!

How to sort it out? How to bring the Horde database back?

 

[thewebhosting]

If you have an database backup then you can restore the Horde database backup from the available backup.

 

[Ivalde]

Upgrade scripts bugs bugs

The horde database has now been regenerated from backup, after the fatal database deletion carried out by the cPanel upgrade process. Without this MySQL database backup system set up some months ago, all the user’s preferences etc. would have been lost forever. How is this possible? I know the horde database has been redesigned over some time, the histories table is not included any longer as an example.

Was that the original intention of the upgrade script? To drop the histories table? Then the script dropped the complete database instead? Bugs bugs bugs. Can we thrust the upgrade scripts for the future?

 

[cPanelKenneth]

The horde database has now been regenerated from backup, after the fatal database deletion carried out by the cPanel upgrade process. Without this MySQL database backup system set up some months ago, all the user’s preferences etc. would have been lost forever. How is this possible? I know the horde database has been redesigned over some time, the histories table is not included any longer as an example.

Was that the original intention of the upgrade script? To drop the histories table? Then the script dropped the complete database instead? Bugs bugs bugs. Can we thrust the upgrade scripts for the future?

There was a logic flaw in the Horde update scripts that caused this. The problem is resolved in 11.25.0

 

[borki]

We have no Horde-DB backup - or is this done automatically with cpanel-backup? Should we create a new empty db?

 

[JaredR.]

Check /var/cpanel/horde

There may be a dump of the Horde database in /var/cpanel/horde. The file format would be horde.backup.sql.XXXXXXXXXX. You can restore the database by first making sure the database exists, creating it if necessary, then importing from the dump using a command like this:

# mysql -uroot -p horde < horde.backup.sql.XXXXXXXXXX

Replace the X characters with the actual numbers in the filename, and enter the MySQL root password when prompted.

If there is no good backup in /var/cpanel/horde, you can run /scripts/reinstallhorde to completely reinstall Horde with an initial database.

 

[borki]

Hi

OK, this backups were quite old and there was no data inside.. I restored the DB-Files from our normal backup and I just placed the MyISAM Files there.. seems to work...

Regards