Greetings soconfused -

Well it looks like you found something that is incorrect with the module. This would indicate that hopefully your database is okay. But there seems to be something incorrect with the first SQL statement.

It seems that some developers do not turn on debug at the end of their development cycle, after they think the module is ready for a release, to check for errors they have missed.

I also have a XOOPS test installation that is permanently set on debug mode. I test new modules that I am interested in this test system. Most of the time I find undefined constants.

You might want to report this error to the module developer to see if he can resolve it.