Re: [Omail-ospam] ping / mysql 4.1?

[Olivier M. <om-...@om...>]

On Wed, 2005-07-13 at 10:13 +0200, Olivier Mueller wrote:
> I still do on my own servers, but will need to make
> some updates because of the mysql 4.1 timestamp issues
> (new format): got to adapt the code... 

So, I guess it's working now. First I tried to change the
queries by replacing "SELECT ts" by "SELECT ts+0 as ts": works,
but not in WHERE clause -> can not be used :/

Current solution:

1) adapt table structure of 'dotqmail'  (bigint -> varchar):
	ALTER TABLE `dotqmail` CHANGE `lastprefchange` `lastprefchange`\
        VARCHAR( 30 ) NOT NULL DEFAULT '0'

2) relpace this at line 496:

	if ($lastprefchange == $spam_ts) { $ts_changed = 0; } 
           else { $ts_changed = 1; }
    by

        if ($lastprefchange eq $spam_ts) { $ts_changed = 0; } 
           else { $ts_changed = 1; }


And it should do the trick. Side effect: your users will get
a mail "ospam settings changed" after the code change, so 
you may want to stop the mail-info feature on the first run.

Tested on a 4.1 and a 4.0 server, and it looks fine so far. 

regards,
Olivier