Welcome to Geeklog, Anonymous Tuesday, April 23 2024 @ 04:22 am EDT
Geeklog Forums
Error in Search.php
Status: offline
Creator
Forum User
Full Member
Registered: 07/11/02
Posts: 181
Location:Austin, TX
I'm getting an error in my site whenever I do a search or call search.php:
L. Whitworth
1064: You have an error in your SQL syntax near ') ORDER by username' at line 1
The error log shows:
Tue Nov 12 12:47:43 2002 - 1064: You have an error in your SQL syntax near ') ORDER by username' at line 1 SQL in question: SELECT uid,username FROM gl_users WHERE uid in () ORDER by username
This is the search.php from the 1.3.6 core install.
Can anyone help me out?
L. Whitworth
6
4
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
This is a well-known problem (I'm too lazy to search now, but it has been discussed here before) and will go away as soon as you have a story on your site ...
In other words: It only happens when you have no stories on your site.
bye, Dirk
3
4
Quote
All times are EDT. The time is now 04:22 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