2
First, welcome to XOOPS!
I believe the problem you are having is related to your PHP and MySQL versions. As of present, XOOPS and related modules have not been confirmed to work with MySQL 5.0. Support for PHP 5 is iffy on XOOPS versions prior to 2.2.x and even more so on modules, unless stated otherwise.
Hope this clarifys things a bit. Sorry it doesn't solve your problem.
Best Regards,
James
Insanity can be defined as "doing the same thing over and over and expecting different results."
Stupidity is not a crime. Therefore, you are free to go.