[RESOLVED] Weird problem after upgrade.

[Eq4bits]

I upgraded my vB4 today to most current version and have been experiencing some very weird behaviour by the forum since then. Not just me, my members as well. Any time a topic/thread gets to be 20 posts (total) long when someone posts the 21st post it 'disappears', the thread will show as having 3 pages (20 posts per page) but if you click 'page 3' then page 2 simply reloads, the post shows in the vB_posts table in the d/b, but no matter what we try we can not 'see' the post (or any replies attempted after the 21st one) in the forum.

It's weird because it's ONLY the 21st post, everything works a charm until a thread gets to that point.

--------------- Added 12 Feb 2014 at 01:24 ---------------

new or rather 'last' posts are also not being shown as the last post in a thread on Forum Home, Forum view/sub forum view, nor the Activity Stream.

[ForceHSS]

Try disabling all plugins via the config and wait until someone posts there 21st post

To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[Lynne]

Maintenance > General Update Tools > Rebuild Thread Information and then Rebuild Forum Information

[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 = '';
        }
    } 


[Lynne]

Out of Memory? That is a server issue and you will need to show the error to your host in order for them to fix it.

[RichieBoy67]

If you are using a dedicated server you need to configure your my.cnf file among other things.

You may get away with being able to run the counter update though using a smaller amount of posts. i think default is 2,000 at a time. Try like 100 or something. It will take longer but you may have the memory to support it.

[Eq4bits]

I then ran 'rebuild forum information' in general tools, it seemed to do the rebuild but this displays on my general tools page between 'fix broken user profiles' and ''rebuild search index':

Warning: Declaration of vBForum_Item_SocialGroupMessage::getLoadQuery() should be compatible with that of vB_Model::getLoadQuery() in ..../packages/vbforum/item/socialgroupmessage.php on line 261

Warning: Declaration of vBForum_Item_SocialGroupDiscussion::getLoadQuery() should be compatible with that of vB_Model::getLoadQuery() in ..../packages/vbforum/item/socialgroupdiscussion.php on line 337

.../packages/vbforum/item/socialgroupmessage.php line 261 reads:

PHP Code:

} 


.../packages/vbforum/item/socialgroupdiscussion.php line 337 reads:

PHP Code:

} 


[RichieBoy67]

This is what works best for me though there are a few ways to fix

includes/class_core.php

Find

PHP Code:

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


and add

PHP Code:

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


As found here

http://www.vbulletin.com/forum/forum...81#post4000681

[Eq4bits]

Originally Posted by RichieBoy67

This is what works best for me though there are a few ways to fix

includes/class_core.php

Find

PHP Code:

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


and add

PHP Code:

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


As found here

http://www.vbulletin.com/forum/forum...81#post4000681

tried this, still getting the error page when I try to run maintenance>general update tools> rebuild thread information =S

[RichieBoy67]

That fixes the depreciation issue. Not the issue with being out of memory. For that you need to configure your server or talk to your host.

Are you still seeing

Warning: Declaration of vBForum_Item_SocialGroupMessage::getLoadQuery() should be compatible with that of vB_Model::getLoadQuery() in ..../packages/vbforum/item/socialgroupmessage.php on line 261

Warning: Declaration of vBForum_Item_SocialGroupDiscussion::getLoadQuery() should be compatible with that of vB_Model::getLoadQuery() in ..../packages/vbforum/item/socialgroupdiscussion.php on line 337