Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Mail : Discussion :

Upgrade from 2.1.1 to 2.2.4 fails at isntall.cgi

May 7, 2005, 5:38 PM
DrewBlack
User (59 posts)
May 7, 2005, 5:38 PM
Post #1 of 2
Views: 2533
Shortcut
Quote Reply
Upgrade from 2.1.1 to 2.2.4 fails at isntall.cgi
Trying to upgrade from 2.1.1 to 2.2.4. It fails after unpacking the script.

bummer.


Upgrading Gossamer Mail from 2.1.1 to 2.2.0...
Dropping unique index foldername_unique...
Okay!
Adding column folders_type to folders table...
Could not add column folders_type: Column folders_type was specified as not null, but has no default value
Updating folders_type column for system folders (Inbox, Sent, Trash)...
Error: DBD::mysql::st execute failed: You have an error in your SQL syntax near 'WHERE folders_fid IN (1,2,3)' at line 1 at /var/www/cgi-bin/gmail_admin/GT/SQL/Driver/sth.pm line 101.
DBD::mysql::st execute failed: You have an error in your SQL syntax near 'WHERE folders_fid IN (1,2,3)' at line 1 at /var/www/cgi-bin/gmail_admin/GT/SQL/Driver/sth.pm line 101.
May 8, 2005, 3:17 AM
brewt
Staff (4101 posts)
brewt's avatar
May 8, 2005, 3:17 AM
Post #2 of 2
Views: 2467
Shortcut
Quote Reply
Re: [DrewBlack] Upgrade from 2.1.1 to 2.2.4 fails at isntall.cgi In reply to
You can fix this by editing the install.cgi. Search for 'add_column(' and there's two places where you have to fix it so that it defines a default value for those not_null columns.

They're all clustered around line 9168:
Code:
add_column($i, $DB, folders => folders_type => { type => 'INT', not_null => 1, unsigned => 1, default => 0 }); # 1 = inbox, 2 = sent, 3 = trash, 4 = drafts
...
add_column($i, $DB, folders => folders_father => { type => 'INT', not_null => 1, unsigned => 1, default => 0 });
add_column($i, $DB, folders => folders_root => { type => 'INT', not_null => 1, unsigned => 1, default => 0 });
add_column($i, $DB, folders => folders_depth => { type => 'INT', not_null => 1, unsigned => 1, default => 0 });

I'll have to get the package fixed on Monday.

Adrian

Last edited by:

brewt: May 8, 2005, 3:17 AM