Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2007-03-08 12:26:22
- loid
- Member
- Registered: 2005-03-09
- Posts: 38
Error Searching Comments By IP
All the possible searches in the comments section work for me except when trying to search by IP. When I try to do that, I get a message saying there’s an error in my MySQL syyntax. Yet I haven’t made any changes to fbtxp_discuss or txplib_db.php, which are both cited in the error message.
Is this a known issue, and/or has anyone else experienced this problem and found a way around it?
Offline
#2 2007-03-10 13:58:45
- loid
- Member
- Registered: 2005-03-09
- Posts: 38
Re: Error Searching Comments By IP
Guess it’s just me.
Offline
#3 2007-03-10 19:58:46
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Error Searching Comments By IP
It’s not just you, I get the same warning. I just never use the search by IP feature…
Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘84.31.186.10’ at line 1 select count(*) from htxp_discuss as txp_discuss where ip like 84.31.186.10 in /home/httpd/vhosts/doggiez.nl/httpdocs/textpattern/lib/txplib_db.php on line 84
And I’m sorry, I don’t know what to do about it.
Last edited by els (2007-03-10 20:00:32)
Offline
Re: Error Searching Comments By IP
Looks like a bug, try patching txp_discuss.php and let us know if that fixes it:
--- 4.0/textpattern/include/txp_discuss.php (revision 2250)
+++ 4.0/textpattern/include/txp_discuss.php (working copy)
@@ -135,7 +135,7 @@
'message' => "message like '%$crit_escaped%'",
'email' => "email like '%$crit_escaped%'",
'website' => "web like '%$crit_escaped%'",
- 'ip' => "ip like %$crit_escaped%",
+ 'ip' => "ip like '%$crit_escaped%'",
);
if (array_key_exists($search_method, $critsql))Last edited by ruud (2007-03-10 21:47:54)
Offline
#5 2007-03-10 23:22:22
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Error Searching Comments By IP
Yep, that fixes it :)
Offline
#6 2007-03-11 10:07:24
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Error Searching Comments By IP
Offline
#7 2007-03-12 18:41:08
- loid
- Member
- Registered: 2005-03-09
- Posts: 38
Re: Error Searching Comments By IP
Thanks everyone! It’s greatly appreciated in this corner.
Offline
Pages: 1