Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 03:01 am EST

Geeklog Forums

SQL error generated from all search functions


Status: offline

charliew

Forum User
Newbie
Registered: 07/01/03
Posts: 6
This one seems wierd to me, since I can't figure out what I did to break the geeklog search functionality, and am not entirely sure what to have to replace to fix it.

On my (internal) geeklog site, whenever I execute a search (from anywhere, including the search generated my the MyCal plug in, from the search or advanced seach, or when trying to find all articles by an author) the site simply says 'An SQL error has occured. Please see error.log for details'

Checking error.log gives me:

Thu Jan 8 11:13:42 2004 - 1064: You have an error in your SQL syntax near '' at line 1. SQL in question: SELECT COUNT(*) FROM

As far as I can tell, that means I'm not getting $table passed to search.class.php, but I'm really an SQL & PHP moron.

I took the strategy or replacing public_html/search.php and sys/classes/search.class.php with clean copies from the source, in case these had gotten corrupted, but no dice.

I'd appreciate any advice on troubleshooting this, ideally without my fallback plan, which is to re-install 1.3.8sr3, my current version, and add the plugins in one at a time to test functionality.

Thanks for any help

-- Charlie
 Quote

Status: offline

charliew

Forum User
Newbie
Registered: 07/01/03
Posts: 6
Never mind.

It was, apparently, the contact plug-in. De-installing that return search functionality.
 Quote

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