2
got it.
only post methods are allowed any queries other then 'select' by default. if you need to enable other queries uncomment the line that says
define('XOOPS_DB_PROXY', 1);
that should let you develop in peace, and turn it back on after you are done.
gosh i spent a good few hours just working this out...