the best way is want your hosting supporters to do it for you.
just send that query and want them to run it in your XOOPS database.

With rlankford's help I was able to get the command to execute. SQL console reported:

Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0

However, I still have a bank page with no errors. Now what?!

For #OOPS#s and giggles I moved a copy of the site to Apache. Now instead of a blank screen I get:


Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\logger.php on line 51

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\logger.php on line 52

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\logger.php on line 53

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\logger.php on line 54

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\logger.php on line 55

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\errorhandler.php on line 196

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\database\databasefactory.php on line 30

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\database\databasefactory.php on line 59

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\errorhandler.php on line 196

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\database\mysqldatabase.php on line 64

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\database\database.php on line 59

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\database\database.php on line 65

Warning: preg_replace() [function.preg-replace]: Compilation failed: unknown property name after \P or \p at offset 5 in C:\Program Files\Apache Group\Apache2\htdocs\class\errorhandler.php on line 196

Ok guys, here are some errors for ya. What the heck does this mean??

With the help of technobia on this forum (a nice lady named Jody) we found a stray semi-colon that hosed the entire site...

The complete lack of troubleshooting tools, errors or debugs of any sort are very frustrating, making XOOPS a poor choice for a comerical product, in my humble oppinion...