Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 07:05 am EST
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
13
16
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
17
17
Quote
All times are EST. The time is now 07:05 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