Last modified: 2006-07-13 00:03:37 UTC
[[Special:Blockme]], (which appears to allow a user who knows the proxy key the
ability to block themselves) takes a special parameter, "ip", which is
md5 ( your IP address + $wgProxyKey ), which for me on non-accessible private
test wiki equals:
md5 ("192.168.0.2" .
However using this parameter in a URL (in this example:
), causes the following error:
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 "Block::insert". MySQL returned error "1054: Unknown column
'ipb_anon_only' in 'field list' (localhost)".
... and the database error log contains this:
Wed Jul 12 17:29:25 EST 2006 bling Block::insert localhost 1054 Unknown
column 'ipb_anon_only' in 'field list' (localhost) INSERT IGNORE INTO
VALUES (NULL,'192.168.0.2','0','10000','Your IP address has been blocked because
it is an open proxy. Please contact your Internet service provider or tech
support and inform them of this serious security
Maybe either update the query, or delete the file if it's not being used? (At
first glance it only appears to be called by includes/ProxyTools.php , but I'm
not quite clear how ProxyTools is called - and if it isn't, and there are no
plans to add it back in, perhaps deletion may be the better option).
It sounds like you just didn't update the ipblocks table
for the latest schema change on trunk. Can you run update.php
You are entirely correct, and that fixed the problem. Sorry!
Marking as resolved, status: INVALID.