[Eq4bits]

That helped for the first 15 minutes then things went wonky again. I re-downloaded vB4.2.2, extracted it, and ftp'd all the 'upload' files to my server/forum directory, re-ran upgrade script, deleted 'install' folder from server/forum directory, I have disabled in admincp the forumrunner, panjo, postrelease, cms products & plugins. I ran 'Repair & Optimize' database tables. Then I tried running 'maintenance>general update tools>rebuild threads' and got the following error:

Updating Threads

Warning: mysql_query() [function.mysql-query]: Unable to save result set in ..../includes/class_core.php on line 417

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
COUNT(DISTINCT(userid)) AS postercount,
SUM(IF(visible = 1, attach, 0)) AS attachsum,
SUM(IF(visible = 1, 1, 0)) AS visible,
SUM(IF(visible = 0, 1, 0)) AS hidden,
SUM(IF(visible = 2, 1, 0)) AS deleted
FROM vB_post AS post
WHERE threadid = 1;

MySQL Error : Out of memory (Needed 16777188 bytes)
Error Number : 5
Request Date : Wednesday, February 12th 2014 @ 01:42:34 PM
Error Date : Wednesday, February 12th 2014 @ 01:42:34 PM
Script : http://*****.***/***/forum/***adminc...o=updatethread
Referrer : http://*****.***/***/forum/***adminc...php?do=chooser
IP Address : **.**.**.**
Username : *******
Classname : vB_Database
MySQL Version : 5.5.35-33.0

--------------- Added [DATE]1392231168[/DATE] at [TIME]1392231168[/TIME] ---------------

the following are lines 417-431 of the above mentioned file 'includes>class_core.php'

PHP Code:

        if ($queryresult = $this->functions[$buffered ? 'query' : 'query_unbuffered']($this->sql, $link))
        {
            // unset $sql to lower memory .. this isn't an error, so it's not needed
            $this->sql = '';

            return $queryresult;
        }
        else
        {
            $this->halt();

            // unset $sql to lower memory .. error will have already been thrown
            $this->sql = '';
        }
    }