I upgraded to 4.0.4 and still that forumdisplay.php query is there vBulletin should check these optimization and if it is fine then they should do it too. But Thank you for your help.
Hi Shawn I asked this question over at vbulletin but didn't get and answer..... do the majority of these changes need to be done in 4.0.4 or have they used what you came up with in the stock product?
Is this section still valid in 4.0.4: Setting SQL Mode It looks like this feature has already been commented out by vB.
Thanks Shawn, seems VB still won't listen to basic improvements to their product. I also saw your point on MyISAM vs InnoDB about fixing instead of workarounds. Found out the same thing when I moved from a shared host to my own server and needed to fix apache's setup instead of just adding power and memory.....
There is a change in the functions_socialgroup.php file they added: AND socialgroupmember.type = 'member'
I did the forumdisplay.php improvement, find the correct code and replaced it with the suggestion in this article. While it worked fine on most forums, it caused problem in some others. Some forums appeared empty, with vb saying there was no post. So I reverted the change and is now working 100% again. Maybe I did something wrong, but just to make you aware.
Hey thanks i tried that Tricks for forumdisplay.php and it really worked i thank full and now will try the next one also
Hi shawn this info is so great...didn't realise how flawed vB4 really was...I'm using v4.0.3 I'm stuck at this tutorial: can you please give me a step by step on how to apply this change in phpMyAdmin? thank you so much!