Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 11:38 pm EST
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
17
12
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
32
15
Quote
All times are EST. The time is now 11:38 pm.
- 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