[Semediawiki-user] ApprovedRevs busted SMW database?

[Neill M. <ne...@nl...>]

Hi.

I'm running MW 1.16 beta 3, SMW 1.5.0 and ApprovedRevs 1.3.

I installed the extension and then ran approveAllPages.php script to 
approve all the latest revs. The script ran okay without errors. 
However, strange things started happening.

I started getting hundreds of page create email notifications for pages 
that already existed.

Even weirder, SMW queries just started going crazy. For example, I have 
a query that pulls out all people whose name begins with, say, N:
{{ #ask:
[[Category:People]]
[[Name::~N*]]
| ?Name
| ?Company Name
| ?Position
| ?Telephone
| ?Mobile
| ?Email
| format=template
| template=Business Card
| mainlabel=-
| offset=0
| limit=250
}}

and it consistently returns people like Peter Smith, John Jones etc. No 
"N" is sight! It also returned Company Names that started in N e.g. 
Nokia even though Company Name is not a query parameter. It's as if the 
SMW property links are just totally bust. Other queries that were 
returning data simply stopped returning anything even though the values 
could be seen in the properties specified.

Luckily I took a snapshot of the database before running the script and 
when I restored that everything was fine. I ran the script again and the 
odd behaviour happened again.

Any idea what might be happening?

Many thanks
Neill.