1. - GetLoadQuery function edit the files "socialgroupmessage.php" and "socialgroupdiscussion.php" found in "packages/vbforum/item/"

2. - The original function reads:


3. - Change the function to this:

Yeah, that is another way to fix it but the class_core should also do it. I think he is now referring to the database error he gets when rebuilding the post cache but not sure.

just looked at the class_core.php agin should mine, after adding that bit read like this?

if he downloaded a new 4.2.2 the fix in the class_core should already be in there

Made changes, get this when I run rebuild thread info:
error page with:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in ..../includes/class_core.php on line 417

and the out of memory stuff

when I run rebuild forum info it 'runs' but on the tools page this is displayed:
Parse error: syntax error, unexpected ')', expecting ';' or '{' in /home/******/public_html/****/forum/packages/vbforum/item/socialgroupdiscussion.php on line 129


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

Yes I downloaded vB4.2.2 this morning

Like this I believe

case E_NOTICE:
case E_STRICT;
case E_DEPRECATED;
// Just ignore these completely //
break;

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

Yeah I thought that too but have installed a couple new sites since and have still had to fix.

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

Did you make the changes to the socialgroup files too?

I had sent in a ticket to my host and their reply was to optimize my d/b (which I had been doing approx. 10/hour for several hours) and advised to use specific vB 'optimiztion plugins' (which were for vB3.x and I'm running 4.2.2)
I followed the suggestions HERE and made the appropriate changes, saved, cleared cache, tried running general update tools again, and still having issues.

the natives are getting restless as I've had the forum disabled all morning. I'm afraid they may burn me out LOL

What are you using for a host? A shared hosting account? is this a new server you are on or something?

You are using vb3 plug ins on a vb4.2.2 site?

Don't use Yahoo yui. Use Google or nothing in that setting.

As for the rest they are not going to really impact this issue much that happens when rebuilding a database table.

Did you try rebuilding thread/post cache using a smaller amount of posts at a time?

just checked ur right not in there was sure i seen it

it needs to be like this

case E_NOTICE:
case E_STRICT:
case E_DEPRECATED:
// Just ignore these completely //
break;

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

if you want to send me the 3 files i will make the changes for you but going to bed in 5 mins so be quick

Yes, sir ;)

I'm submitting ticket to host. Same host I've used the past 10 years with only 1 issue as problematic as this one seems to be, so don't suggest changing hosts - these guys have excellent customer service and response times avg. 15 minutes.

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

Are you still up? I can send the files but where do I send them? Can do so quickly once I know where to send