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