I upgraded from vbulletin suite 4.1.4 to 4.1.7 PL2 yesterday, no issues whatsoever related to spam-o-matic / blank pages, etc...

the annoying "are you sure you want to leave" prompt is something I experienced in 4.1.4, and fixed it/disabled it using a suggestion here:
http://tracker.vbulletin.com/browse/VBIV-12548

You're welcome, in the other thing I have no idea, lets hope someone else share that with you.

DELETE FROM `glowhostspamomatic_remotecache` WHERE (`data`='put in user name here')

Many thanks.Sorry im a newb, where would that reside?

Thanks again all that have helped.

admincp/Maintenance/Execute SQL Query/Manual Query

Many thanks for that, mmmm get a pop up stating i am not authorised to execute SQL queries.
What joy lol.

o.k sorted the query prob, updated config php with
$config['SpecialUsers']['canrunqueries'] = 'x';

...with x being your userid number

So i just paste this text into teh query box but include username?
DELETE FROM `glowhostspamomatic_remotecache` WHERE (`data`='put in user name here')

Many apologies in advance for being a pain, as i say im trying to learn so need spoon feeding for a while.

I'm getting the following error when you try to comment or make a post in the forum after installing this mod, I don't want to uninstall either:

Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/class_dm_threadpost.php(761) : eval()'d code on line 17

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/stufftos/public_html/forums/includes/class_dm_threadpost.php(761) : eval()'d code on line 17

Please help.

yes just put it in that box change the "put in user name here" with the user name you want to remove from the list then click continue