Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

Re: [JerryP] Upgrading Questions

Quote Reply
Re: [JerryP] Upgrading Questions In reply to
I have a few more questions about upgrading from 2.05 to 2.06 if I may.

There was a bug before in incoming.pl at line 316 that caused checking of remote pop accounts to fail if the previous pop account being checked failed. In 2.06 it looks like the fix was not incorporated. I tried searching to find where the fix was posted but can't seem to find it right now in the forum.

the old code was
my $count = $POP->connect or die $GT::Mail::POP3::error;

the new code is
my $count = $POP->connect;
if ((!$count) {
GMail->debug ("Unable to connect to POP: $GT::Mail::POP3::error");
return;
}

does this fix need to be reapplied or has it been fixed somewhere else?

Next, when upgrading I got this error message

Upgrading Gossamer Mail from 2.0.5 to 2.0.6 ...
Changing the name of a column in the user table; 'user' is changed to 'email' because 'user' is a reserved word in SQL92 ...
Error: DBD::mysql::st execute failed: Access denied for user: 'mail@domain.com' to database 'gmail' at /www/domain/cgi-bin/mail/admin/GT/SQL/Driver/MYSQL.pm line 113.

My database is on a separate server from the web server and I'm not sure yet if it failed because of a permissions issue or because the database is on the other server, but I manually made the alteration to the table. My question is, this appears to be the last step in the install process under sub upg_205_206 in the install.cgi, so if I manually altered the database, is the upgrade complete or is there anything else that needs to be continued/rerun? I noticed that in mail/admin/GMail/ConfigData.pm the version number did not get changed, so that's what makes me wonder that there might be something else... I'd rather not re-run the install because I've finished applying all my custom changes which took about 6 hours so if someone can point me to exactly what else needs to be done, I'd be most appreciative.

Next, in this upgrade it appears that the alteration to the database above caused a lot of changes, whereever 'user' was used it had to be changed to 'email'. I have a few templates that still have <%user%> in them and wanted to see if this was an oversight or if these need to be changed too. The templates/files are
admin/Plugins/GMail/wap.pm
data/templates/default/admin.eml
data/templates/default/options_compose.htm (two places)
data/templates/default/options_mailbox.htm

I think that about covers it, thanks for any help folks can provide.
Subject Author Views Date
Thread Upgrading Questions JerryP 2538 Feb 24, 2002, 12:40 AM
Thread Re: [JerryP] Upgrading Questions
JerryP 2454 Feb 24, 2002, 4:46 PM
Thread Re: [JerryP] Upgrading Questions
Alex 2450 Feb 25, 2002, 6:14 PM
Post Re: [Alex] Upgrading Questions
JerryP 2434 Feb 26, 2002, 1:28 AM
Post Re: [Alex] Upgrading Questions
JerryP 2426 Feb 26, 2002, 4:51 PM