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
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
13
14
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