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?
Thanks!
That fixed it. And yes, I am using a 'new' version of PostgreSQL,
version 7.4.6

Regards,
    Evert


neuroticimbecile wrote:

>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
>
>
>
>


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