Welcome to Geeklog, Anonymous Tuesday, December 10 2024 @ 05:22 pm EST
Geeklog Forums
Search Error
Status: offline
samstone
Forum User
Full Member
Registered: 09/29/02
Posts: 820
I got the following error when I do a search or click on the link from Site Clendar block.
1064: You have an error in your SQL syntax near '' at line 1
And the following is from the error log.
Wed Jan 8 03:02:11 2003 - 1064: You have an error in your SQL syntax near '' at line 1 SQL in question: SELECT COUNT(*) FROM
A similar situation was posted here before. Dirk's answer was because there was no story posted. But in my case I do have several posted, and still encounter this error. I am using GL 1.3.7.
Sam
14
17
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
There should be the name of a table after the "FROM".
I've seen a quite a few reports like this recently. Is there some version of a plugin or hack around that is notorious for the omission of the table name when it's not installed properly?
AFAICS, this is not a problem of Geeklog but one with some add-on that you installed on your site. Not sure which one, though ...
bye, Dirk
13
16
Quote
Status: offline
samstone
Forum User
Full Member
Registered: 09/29/02
Posts: 820
Dirk,
Where in the world do you live? It is 3 a.m. in NY now. Do you ever sleep? I came back without expecting an answer posted so soon.
Anyway, I am rebuilding a geeklog site, so I will test it will every plugin I am going to install and report it to you.
Sam
15
14
Quote
Anonymous
Anonymous
Got the same error, installed are geekary and mycal. Error log gives -> Mit 08 Jan 2003 12:53:51 CET - 1064: You have an error in your SQL syntax near '' at line 1 SQL in question: SELECT * FROM gl_geekary_images WHERE cat_id='5' AND
It's the updated search.php from Blaine Lang
17
16
Quote
Status: offline
efarmboy
Forum User
Moderator
Registered: 02/26/02
Posts: 147
Disable the plugins 1 by 1 to find the source of the problem. If you are doing a search on all types or using the SiteCalendar block search, then it does a search of type all. This will automatically call all plugin search functions.
You can try isolating the source by testing each search type individually.
I uploaded a revised 1.3.7 version of the search.php for SiteCalendar on mysite a few days ago.
Blaine
13
13
Quote
Status: offline
Fraggle
Forum User
Newbie
Registered: 11/03/02
Posts: 10
I erased the search plugin function entirely from the search.php. Would be nice in a future release to have the ability to disable search within selected plugins. My problem was with the journal plugin which does not allow searches of private journals but the search.php tried to do it anyway. Rather then recode the journal plugin I just fixed the search.php...---the c0w says: m00
the c0w says: m00
the c0w says: m00
17
13
Quote
Anonymous
Anonymous
Is there a place where I can find instructions on how to work with CVS? I have never apply one even though I have heard so much talk about it.
Sam
20
15
Quote
Anonymous
Anonymous
You can also turn off the integrated contact search in the contact config.php.
CVS is easy for one file like this just browse cvs till you find the file you want, then view and copy and paste it. No cvs client required.
TomW
15
20
Quote
Anonymous
Anonymous
Thanks, I will check it out.
Sam
15
17
Quote
All times are EST. The time is now 05:22 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