Subject: Search Error

Posted on: 08/01/03 03:00am
By: samstone

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

Search Error

Posted on: 08/01/03 03:27am
By: Dirk

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

Search Error

Posted on: 08/01/03 03:48am
By: samstone

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

Search Error

Posted on: 08/01/03 07:01am
By: 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

Search Error

Posted on: 08/01/03 08:48am
By: efarmboy

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

Search Error

Posted on: 08/01/03 09:47am
By: Fraggle

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

I found it

Posted on: 08/01/03 01:43pm
By: samstone

After installing Contact plugin. Any idea how to fix that? Sam

I found it

Posted on: 08/01/03 02:38pm
By: Anonymous

Sure get the updated functions.inc from cvs for the contact plugin. I would give you the right link but sourceforge cvs appears to be down. Go to Gplugs and follow the cvs link. You might also look at this story.

TomW


I found it

Posted on: 08/01/03 02:43pm
By: samstone

As Fraggle suggested, I commented out the search plugins functions from the search.php and now it works fine. Sam

I found it

Posted on: 08/01/03 02:47pm
By: 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

I found it

Posted on: 08/01/03 04:17pm
By: 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

I found it

Posted on: 08/01/03 05:09pm
By: Anonymous

Thanks, I will check it out. Sam

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=14800