Welcome to Geeklog Wednesday, December 01 2021 @ 11:34 pm EST

Geeklog Forums

Error in Search.php


Status: offline

Creator

Forum User
Full Member
Registered: 11/07/02
Posts: 181
Location:Austin, TX
I'm getting an error in my site whenever I do a search or call search.php:

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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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
 Quote

Status: offline

Creator

Forum User
Full Member
Registered: 11/07/02
Posts: 181
Location:Austin, TX
NOW I remember!!! Thanks for the lazy reminder, Dirk.---L. Whitworth www.finiserv.com
L. Whitworth
 Quote

All times are EST. The time is now 11:34 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