I got it to work by using an empty mysql.sql from an earlier version of his block. Just make an empty text file and rename it mysql.sql and upload it to the block.
It appears that the block only searches within a course. Great start, but I really need to search all courses from home page etc.
Also: the search returns the results but only the result without the resource name, unless the resource name is what was returned. I'd like to use it for keywords in the summary field or a new Keywords filed that I can add to resources.
Still a very good start at a site wide resource search and I will continue to play with it.