Last modified: 2012-09-07 12:34:46 UTC
When searching for a blocked IP I see this Database error page. A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "IndexPager::reallyDoQuery (BlockListPager)". Database returned error "1: ERROR: operator does not exist: text <= integer LINE 1: ...(ipb_range_start LIKE '%' ) AND (ipb_range_start <= 0) AND ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.".
This happens when I search for an IP from the form on the Special:BlockList page.
What do you see after adding the following to your LocalSettings? $wgShowSQLErrors = true; $wgDebugDumpSql = true;
I can't reproduce this using trunk. Which version exactly are you using? There were some changes in 1.18.1 - can you check? I would be grateful for output of http://yourwiki/w/index.php?title=Special:Version as well as output with $wgShowSQLErrors = true; $wgDebugDumpSql = true; $wgShowDBErrorBacktrace = true; $wgShowExceptionDetails = true; $wgDebugLogFile = "somefilewebservercanwriteto.log"; You can send the log privately to me if it contains some private information
Hello, As far as I can see it works for me. Unless you provide further information as requested we cant fix any problem if there is any.
