View Single Post
Old 12th October 2006, 11:20
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

Originally Posted by jdell
Hi All,

Word of warning (and glad I did my backups first). I just upgraded from 2.2.6 to 2.2.7, and the entire contents of the ispconfig mysql database (all tables) were deleted.

At the end of the upgrade, I got the message:

All prerequisites are fulfilled.
Here we go...

Connected successfully to db ispconfig

and then a bunch of php mysql_fetch_array(): supplied argument is not a valid MySQL result resource (because the tables were missing).

I restored the mysql ispconfig db, and everything was fine again. Just to be safe, I re-ran the install against the existing 2.2.7 install, and everything went fine.

So, I have no idea why/how that happened, but do your backups.

This happens if the databse username and password in the ISPConfig file are incorrect or if ISPConfig is not able to connect to your mysql database because it is stopped.

ISPConfig is doing a abackup of the database and the directories /root/ispconfig and /home/admispconfig automatically before the update in your /tmp directory. So you will just have to unpack these tar.gz files to their original locations, make sure that the mysql connection is possible and ran the update again.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from
Reply With Quote