Re: [quick-r] Anyone else getting this error?

Top Page
Author: Open source prepaid management system
Date:  
To: Open source prepaid management system
Subject: Re: [quick-r] Anyone else getting this error?
On Thursday 25 November 2004 04:47 pm, Evert Meulie wrote:
> Hi everyone!
>
> Each night the cron job generates these errors:
> ERROR: syntax error at or near "'1 month'" at character 90
> ERROR: syntax error at or near "'1 month'" at character 90
> ERROR: syntax error at or near "'1 month'" at character 90
>
> Who can tell me how to fix this...?



Hi Evert,

In the file bin/qn_collecttrash.pl

replace this:
==========
"AND (date_expiration + INTERVAL('1 month')) < DATE(NOW()) ".
==========

with this:
==========
"AND (date_expiration + CAST('1 month' AS INTERVAL)) < DATE(NOW()) ".
==========

If this solves it, it means you're using a newer version of PostgreSQL.

HTH,
-eric
_______________________________________________
quick-r mailing list
quick-r@???
http://lists.q-linux.com/mailman/listinfo/quick-r