Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 28th June 2009, 14:46
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
Default Fatal error when updating ISPConfig

I am running ISPConfig 3.0.1. Trying to upload to the latest stable version produces the following error:

Code:
>> Update

Operating System: Debian Lenny/Sid or compatible

This application will update ISPConfig 3 on your server.
MySQL root password []: xxxxxxxxxxx


Fatal error: Cannot use string offset as an array in /root/ispconfig3_install/install/update.php on line 148
root@ispconfig:~/ispconfig3_install/install#
I'm running Ubuntu 8.04, kept fresh via apt. I have successfully updated ISPConfig before.
Any idea what may cause this?
Reply With Quote
Sponsored Links
  #2  
Old 28th June 2009, 19:43
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
Default More bad news

Also since the failed update, I can't login into any of the FTP's nor the ISPConfig webinterface.

What to do now?
Reply With Quote
  #3  
Old 28th June 2009, 19:45
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Did you had a released version installed or a svn version?

Check your database with phpmyadmin, if its empty then restore the bakup that you find in the root folder.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 28th June 2009, 20:00
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
Default

First of all, I don't know what kind of version I had, apart from it being 3.0.1

My ISPConfig DB seems to be empty. I can't believe how you guys let me download and execute a MINOR version update that is able to fuck up my entire sytem without any warning. This is entirely unacceptable even for free software.

Now I have several backups:

- I have full system (VPS) backup for both the MySQL and the ISPConfig host
- I have ispconfig_db_backup since the last update, but it's 2 months old

Questions about how to proceed:

1. If I restore yesterday's MySQL DB and ISPConfig files (effectively undoing this entire failed update), how can I update to the latest version?

2. If I restore only the MySQL DB from yesterday, won't the update kill it again?

3. What can I do with the 2 month old ispconfig_db_backup?
Reply With Quote
  #5  
Old 28th June 2009, 20:09
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Quote:
My ISPConfig DB seems to be empty. I can't believe how you guys let me download and execute a MINOR version update that is able to fuck up my entire sytem without any warning. This is entirely unacceptable even for free software.
Thats a good question and before blaming us you should try to answer the question if you had a developemnt release installed before or not. We had already very many succesful updates and the only possible reason for your problem is that you did not had a stable version installed.

1+2) That depends on the answer which question you had installed before. How many database tables contains your backup?

3) About which backup are you talking?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 28th June 2009, 20:15
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
Thats a good question and before blaming us you should try to answer the question if you had a developemnt release installed before or not.
I'm not sure, but I MIGHT HAVE had the SVN version before. Is there a way to find this out for sure? (I have trunk folders in root/, so possibly SVN)

Quote:
1+2) That depends on the answer which question you had installed before. How many database tables contains your backup?
The corrupted database (that was fucked up by the update) contains 44 tables.

Quote:
3) About which backup are you talking?
I have these from my 2 previous updates, but they are way too old, I have many new sites and clients in my setup.

-rwx------ 1 root root 112971 Mar 10 07:26 ispconfig_db_backup_2009-03-10_07-26.sql
-rwx------ 1 root root 118113 Apr 10 03:37 ispconfig_db_backup_2009-04-10_03-37.sql

Last edited by gkovacs; 28th June 2009 at 22:53.
Reply With Quote
  #7  
Old 28th June 2009, 21:31
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Alright, I've restored the database from a backup, so essentially I've went back to ISPConfig 3.0.1 (probably SVN) version.
The database has 54 tables.

So how can I upgrade this to the latest version (so that logrotate would work)?

Your download/info page has no specific information to SVN users.

Last edited by gkovacs; 28th June 2009 at 22:54.
Reply With Quote
  #8  
Old 28th June 2009, 23:00
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Your version is definately a svn version and the update failed because it contains more database tables then the stable releases. There are 2 options:

a) Update always to svn revisions and do not install stable releases.
b) Execute the following commands in the ispconfig mysql database:

[code]DROP TABLE IF EXISTS `billing_invoice`;
DROP TABLE IF EXISTS `billing_product`;
DROP TABLE IF EXISTS `billing_service`;
DROP TABLE IF EXISTS `billing_service_class`;
DROP TABLE IF EXISTS `billing_tax`;
DROP TABLE IF EXISTS `client_address_book`;
DROP TABLE IF EXISTS `domain`;
DROP TABLE IF EXISTS `domain_handle`;
DROP TABLE IF EXISTS `domain_provider`;
DROP TABLE IF EXISTS `domain_tld`;[code]

and then try the stable update again.

I recommend that you use option b)

Quote:
Your download/info page has no specific information to SVN users.
Thats correct, as we do not offer svn versions for download.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
gkovacs (29th June 2009)
  #9  
Old 29th June 2009, 00:32
gkovacs gkovacs is offline
Member
 
Join Date: Jan 2009
Location: Budapest, Hungary
Posts: 47
Thanks: 5
Thanked 0 Times in 0 Posts
 
Default

I have dropped the tables and updated ISPConfig with the stable version. This time there were no errors.

You might want to check in the update script if a user wants to upgrade a development version to the stable, and warn him before he bricks his installation.

Thanks for the help.

Last edited by gkovacs; 29th June 2009 at 00:45.
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
ISPConfig 3.0.0.8 RC1 released till General 92 22nd February 2010 09:52
ISPConfig 3.0.0.9 RC2 released till General 51 17th April 2009 17:12
ISPConfig 3.0.0.4 Beta Released till General 54 4th March 2009 09:55
Virtual users... Ubuntu 8.04 spaceuser HOWTO-Related Questions 12 19th June 2008 08:04
Can not send mail out to any outside domain Txchaser Installation/Configuration 11 14th April 2008 15:31


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


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