Welcome to Geeklog, Anonymous Tuesday, April 16 2024 @ 03:19 am EDT

Geeklog Forums

sql error with stories


Anonymous

Anonymous
hello! i have some problems with geeklog... When I clik on read more link, I get this error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-3, 10-3' at line 1 and the line from error.log :pon 12 maj 2003 14:05:58 CDT - 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-3, 10-3' at line 1 SQL in question: SELECT sid,tid,title,comments,unix_timestamp(date) AS day FROM nuke_stories WHERE (perm_anon = 2) AND (date <= NOW()) AND (draft_flag = 0) AND (featured = 0) ORDER BY date DESC LIMIT 10-3, 10-3 i'm running gl 1.3.7sr1.... tnx for help! miki
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Hmm, what do you have for $_CONF['limitnews'] in your config.php? It looks like you may have $_CONF['limitnews'] = '10-3'; there for whatever reason. Make sure that's only a number. bye, Dirk
 Quote

All times are EDT. The time is now 03:19 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