Welcome to Geeklog, Anonymous Saturday, March 15 2025 @ 04:23 am EDT
Geeklog Forums
Incorrect syntax near 'ttl'.
tomn
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
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
17
18
Quote
Status: offline
THEMike
Forum User
Moderator
Registered: 07/25/03
Posts: 141
Location:Sheffield, UK
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
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
19
18
Quote
All times are EDT. The time is now 04:23 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content