Welcome to Geeklog, Anonymous Thursday, September 19 2024 @ 10:44 pm EDT

Geeklog Forums

Search -SQL error?


Status: offline

mrjeff

Forum User
Chatty
Registered: 01/28/04
Posts: 36
caffeinated
When I try to do a search on my site I get the following error

An SQL error has occured. Please see error.log for details.

Any help would be appreciated
Thanks!

Error Log:
Mon Feb 2 11:27:54 2004 - 1064: You have an error in your SQL syntax near '' at line 1. SQL in question: SELECT COUNT(*) FROM
"friends don't help friends run windows"
 Quote

Status: offline

Turias

Forum User
Full Member
Registered: 10/20/03
Posts: 807
It's probably plugin-related. Try deactivating any recently installed plugins.
 Quote

Status: offline

mrjeff

Forum User
Chatty
Registered: 01/28/04
Posts: 36
I tried your suggestion and found it was the Contacts plugin causing it. Any Ideas on how I should try to remedy this?

Thankyou for your help Big Grin
"friends don't help friends run windows"
 Quote

Status: offline

mrjeff

Forum User
Chatty
Registered: 01/28/04
Posts: 36
caffeinated
I edited the config.php in contacts to disable integrated search, and that worked. Hope this helps anybody else with this problem.

$_CONTACT_CONF['search'] = '0'; // Set to '1' to use integrated search '0' to not
"friends don't help friends run windows"
 Quote

Status: offline

mrjeff

Forum User
Chatty
Registered: 01/28/04
Posts: 36
I dug a little deeper and found updating your contacts functions.inc to rev 1.3 from cvs will fix this problem.
I enabled integrated search again in config.php and everything works Big Grin
Thanks for your help, I didn't know where to begin to look to find the source of this problem.

Functions.inc 1.3

"friends don't help friends run windows"
 Quote

Terry

Anonymous
When I try to do a search on my site I get the following error

Warning: fopen("/var/www/geeklog-1.3.9/logs/error.log", "a") - Permission denied in /var/www/lib-common.php on line 1520
An SQL error has occured. Please see error.log for details.

Any help would be appreciated
Thanks!
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Terry: Warning: fopen("/var/www/geeklog-1.3.9/logs/error.log", "a") - Permission denied in /var/www/lib-common.php on line 1520

Please read the installation instructions again, specifically the bit about chmod'ing the logs directory and its contents ...

bye, Dirk
 Quote

All times are EDT. The time is now 10:44 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