Subject: Incorrect syntax near 'ttl'.

Posted on: 26/06/08 04:42pm
By: Anonymous

Anyone seen, and fixed, whatever is causing the following error:

Line 1: Incorrect syntax near 'ttl'.: DELETE FROM gl_tokens WHERE (DATE_ADD(created, INTERVAL ttl SECOND) < getUTCDate()) AND (ttl > 0) - DELETE FROM gl_tokens WHERE (DATE_ADD(created, INTERVAL ttl SECOND) < getUTCDate()) AND (ttl > 0)

??

MS-SQL 2000
IIS 6


Thanks

Tom

Re: Incorrect syntax near 'ttl'.

Posted on: 29/06/08 03:06pm
By: THEMike

Yes.

I have now committed a fix to CVS, get the latest lib-security.php and functions.inc from the calendar plugin, where I've eliminated the use of MSSQL breaking SQL...

http://eight.pairlist.net/pipermail/geeklog-cvs/2008-June/004952.html
http://eight.pairlist.net/pipermail/geeklog-cvs/2008-June/004951.html

And if you try to install other than as DBO, you'll need this:

http://eight.pairlist.net/pipermail/geeklog-cvs/2008-June/004953.html

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=83457