unix_timestamp error ...

Just noticed this one (catching up on email after a couple
of days away)

=======================
Subject: Cron <rootwm>
    
/var/amavis/maia/scripts/send-quarantine-digests.pl>/dev/
null

DBD::Pg::st execute failed: ERROR:  function
unix_timestamp() does not exist
HINT:  No function matches the given name and argument
types. You may need to
add explicit type casts.
=======================


my $unixTime = $isPg ? "( ROUND(DATE_PART('epoch',
NOW())) - ROUND(DATE_PART('epoch',
maia_users.last_digest_sent)))"
                      : "(UNIX_TIMESTAMP() -
UNIX_TIMESTAMP(maia_users.last_digest_sent))";

Where is $isPg supposed to be defined?  I don't find
anything when I grep 
the scripts, nor in /etc/maia.conf ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappyhub.org                              MSN .
scrappyhub.org
Yahoo . yscrappy               Skype: hub.org        ICQ .
7615664
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Marc G. Fournier wrote:

> Where is $isPg supposed to be defined?  I don't find
anything when I grep 
> the scripts, nor in /etc/maia.conf ...

Looks like it got removed in http
s://secure.renaissoft.com/maia/changeset/977

Add this line somewhere before that other line and see if it
works...

my $isPg = $dsn =~ /^dbi:Pg/;

- --
David Morton
Maia Mailguard                        - http://www.maiamailguard
.com
Morton Software Design and Consulting - http://www.dgrmm.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org


iD8DBQFEw+6DUy30ODPkzl0RAh5+AKDY6lzBVou0lsoAnjqBjNYNOQ8UrgCe
MO1Y
odV60tjRdo0sqS9hf0psjgE=
=dHxo
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

On Sun, 23 Jul 2006, David Morton wrote:

>
------------------------------------------------------------
---------------
> /usr/local/libexec/ppf_verify: pgp command failed
>
> gpg: WARNING: using insecure memory!
> gpg: please see http://www.gnupg.org/fa
q.html for more information
> gpg: Signature made Sun Jul 23 18:47:47 2006 ADT using
DSA key ID 33E4CE5D
> gpg: Can't check signature: public key not found
>
------------------------------------------------------------
---------------
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Marc G. Fournier wrote:
>
>> Where is $isPg supposed to be defined?  I don't
find anything when I grep
>> the scripts, nor in /etc/maia.conf ...
>
> Looks like it got removed in http
s://secure.renaissoft.com/maia/changeset/977
>
> Add this line somewhere before that other line and see
if it works...
>
> my $isPg = $dsn =~ /^dbi:Pg/;

needs to be

my $isPg = $dsn =~ /^dbi:Pg/i;

I believe ... I have mine set as DBI:Pg ...

but, then the next error:

wm# /var/amavis/maia/scripts/send-quarantine-digests.pl
DBD::Pg::st execute failed: ERROR:  syntax error at or near
"$3" at character 109
2006-07-23 22:24:31 Maia: [send-quarantine-digests] FATAL
ERROR: Couldn't execute query: ERROR:  syntax error at or
near "$3" at character 109

-------
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappyhub.org                              MSN .
scrappyhub.org
Yahoo . yscrappy               Skype: hub.org        ICQ .
7615664
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users