#1  
Old 11th February 2010, 00:25
quentusrex quentusrex is offline
Senior Member
 
Join Date: May 2008
Posts: 174
Thanks: 6
Thanked 11 Times in 7 Posts
Default upgrade dropped all users

I just upgraded from 3.0.1 to 3.0.1.6 and all my sys_user rows were dropped.

More might have happened...
Reply With Quote
Sponsored Links
  #2  
Old 11th February 2010, 00:35
quentusrex quentusrex is offline
Senior Member
 
Join Date: May 2008
Posts: 174
Thanks: 6
Thanked 11 Times in 7 Posts
Default

confirmed. Upgrade dropped the entire dbispconfig database, and recreated it. So now I have no data. No dns records, users, or any other data.
Reply With Quote
  #3  
Old 11th February 2010, 07:51
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default

Have you upgraded from SVN version to 3.0.1.6?
Reply With Quote
  #4  
Old 11th February 2010, 07:54
quentusrex quentusrex is offline
Senior Member
 
Join Date: May 2008
Posts: 174
Thanks: 6
Thanked 11 Times in 7 Posts
Default

yes, that is exactly what happened. But I was able to find the sql dumps in the home folder. From that I was able to drop the dbispconfig database, create it, import from the install sql file, then import from the backup sql file. I had to remove sections of the sql file in the backup, such as the list of countries, etc. So that I could accept any additions from the new install sql.

In the end I was able to fix the issue. But the upgrade still dropped the table. That is broken. Unless the upgrade says exactly that the database will be dropped, it shouldn't ever do so.
Reply With Quote
  #5  
Old 11th February 2010, 08:25
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default

Quote:
In the end I was able to fix the issue. But the upgrade still dropped the table. That is broken. Unless the upgrade says exactly that the database will be dropped, it shouldn't ever do so.
I'm not the right person for the answer, Till might be able to answer this better than me but what i know is that is BAD and not recommended to upgrade older SVN versions with stable ones.
Reply With Quote
  #6  
Old 11th February 2010, 09:00
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,670
Thanks: 819
Thanked 5,317 Times in 4,170 Posts
Default

You can not upgrade from SVN to a stable version like 3.0.1.6 as the svn version might have adifferent table layout like it was in your case which causes all table contents to be lost. Every ispconfig upgrade dumps the database, then creates a new table layout and loads the database contents again. So if you either modified any table manually or you use a table layout from a version that is incompatible with the released versions, you will loose the database contants. I've written that a lot of times in the forum already, do not upgrade from svn to stable and do not use SVN versions at all on production systems.

But ISPConfig always stores a security backup of the database before the update, so you just have to modify this backup so it can be loaded again into the new database layout.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 14th February 2010, 08:58
quentusrex quentusrex is offline
Senior Member
 
Join Date: May 2008
Posts: 174
Thanks: 6
Thanked 11 Times in 7 Posts
 
Default

till, I'm glad for the backups.

Also, I can't seem to get any changes. I've added new sites but they don't ever appear. It seems the cron job that applies settings isn't running.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Clamav + samba configuration wammy28 HOWTO-Related Questions 8 31st January 2009 19:12
After upgrade to 2.2.24 i can't create new email users. damir Installation/Configuration 0 29th August 2008 10:49
Cacti and ISPConfig: Monitoring Tool VMartins Tips/Tricks/Mods 11 9th August 2008 18:37
Junk mail and spamassassin... sthompson Installation/Configuration 4 27th December 2006 16:11
Upgrade question for "Virtual Users And Domains With Postfix, Courier And MySQL" emresumengen HOWTO-Related Questions 3 1st December 2006 15:33


All times are GMT +2. The time now is 15:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.