View Single Post
  #3  
Old 12th October 2006, 10:20
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,504
Thanks: 813
Thanked 5,265 Times in 4,129 Posts
Default

Quote:
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 config.inc.php 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 ispconfig.org.
Reply With Quote