Welcome to Geeklog, Anonymous Sunday, June 22 2025 @ 03:54 am EDT
Geeklog Forums
Search on GeekLog site broken: Search string: Who's new
i get the following error
An SQL error has occurred. Please see error.log for details.
An SQL error has occurred. Please see error.log for details.
10
6
Quote
Status: offline
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Fixed, thanks. It was actually a bug in the search of the forum plugin.
bye, Dirk
bye, Dirk
9
8
Quote
how do i fix it on my site?
9
10
Quote
Status: offline
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
In the forum plugin's functions.inc file, find the function plugin_dopluginsearch_forum(). Change this:
$query = addslashes($query); // <-- new
$sqltmp .= "AND (comment LIKE '%$query%' OR subject LIKE '%$query%')";
} else if ( $keyType == 'any' ) {
and a bit further down:
$query = addslashes($query); // <-- new
$sqltmp = "WHERE (comment LIKE '%$query%' OR subject LIKE '%$query%')";
}
bye, Dirk
Text Formatted Code
if ( $keyType == 'phrase' ) {$query = addslashes($query); // <-- new
$sqltmp .= "AND (comment LIKE '%$query%' OR subject LIKE '%$query%')";
} else if ( $keyType == 'any' ) {
and a bit further down:
Text Formatted Code
} else {$query = addslashes($query); // <-- new
$sqltmp = "WHERE (comment LIKE '%$query%' OR subject LIKE '%$query%')";
}
bye, Dirk
8
8
Quote
All times are EDT. The time is now 03:54 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