The updater.inc script does use 'infinity' as the pr_expiry value, as does
updateRestrictions.php

Ok, /trunk does, I see 1.10 is still behind there.

MediaWiki wrote:

I actually ran both scripts from the Windows command line (cmd.exe), using the
commands 'php update.php' and 'php updateRestrictions.php' in the
C:\apache\htdocs\w\maintenance directory, where MediaWiki maintenance scripts
are stored. I ended up changing the few protected rows manually with phpMyAdmin,
but I have a small wiki with less than 20 protected pages (currently), and it's
only on my computer. Still, for larger wikis, this could be a problem. Will this
be changed in the next release (1.10.1)?

The default NULL value should be perfectly fine here.

Why, exactly, would it be a problem?

MediaWiki wrote:

(In reply to comment #4)

The default NULL value should be perfectly fine here.

Why, exactly, would it be a problem?

I tried using the default after upgrading and none of the protected pages showed up in the list. It was old entries that were messed up; new protections made in MW 1.10.0 were just fine.

The update script was changed. Also, the GROUP BY clause was removed. Both would solve this problem.

*** Bug 10700 has been marked as a duplicate of this bug. ***