Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 10:34 pm EST
Geeklog Forums
Search on GeekLog site broken: Search string: Who's new
Chase
Anonymous
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.
6
4
Quote
Chase
Anonymous
how do i fix it on my site?
6
5
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
4
5
Quote
All times are EST. The time is now 10:34 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