Interesting bug found in Resource Reservations template from version 7 til version 9

The database script function QueryDocumentDelete and the script beneath the “Delete Site” button produce both an error the following scenario.

Assume you have created a site which name contains a stressed characters like letter à, é, è, …
Let’s now imagine you first misspelled the site name: “Musèe” instead of “Musée”.
Some resources have been created and numerous room reservations are already recorded in the database.

When asked to correct the misspelled site name, the first thought is to create a new site, to create new ressources referring to the new site and to prevent booking further reservation for the old site. The old site will be deleted  when all reservations will become outdated.

Then, problem come:
“You cannot delete this Site Profile because there are still rooms, resources or online meeting places referencing this site in the Address Book.  You need to delete the rooms, resources or online meeting places using the Delete action provided in the resource form before deleting this site profile.”

A look in the code shows the problem.
There is a call - in fact more than one - to a @DbLookup formula:
RoomLookup=Evaluate (|@IsError(@DbLookup("":"NoCache";Server:"names.nsf";"($Rooms)";Site;1))|, note)

So deleting the “Musèe” site will always fail as @DbLookup will make no difference between “Musée”, “Musée” or even “Musee”.

It should be more reliable to use a GetDocumentByKey(key,True) against a NotesView object…
This problem doesn’t seem to have occurred many times as IBM didn’t notice (or didn’t do) anything since Domino 7.