Upgrade to 3.8.0.. Forum/index.php is not working now -- Plzz Help

[sebil]

Hii
i just upgraded from 3.7.4 to 3.8.0
but itz seems that the forum/index , i mean the main forum home is not working.. but i can see some the threads, because i had the URL to it and its working fyn.

it is howing thi s error

Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT COUNT(*) AS countmessages FROM groupmessage WHERE groupid='1';

MySQL Error : Unknown column 'groupid' in 'where clause'
Error Number : 1054
Request Date : Wednesday, January 14th 2009 @ 09:07:14 PM
Error Date : Wednesday, January 14th 2009 @ 09:07:15 PM
Script : http://www.malludreams.com/forum/index.php
Referrer : http://www.malludreams.com/forum/adm...ex.php?do=head
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community

And after that i disabled my plugin globally
and it is working now

But all the products i installed is not working

and i contacted the vb support team..
they said.. as they aware the problem is with vbseo and i have to contact them to solve it..

After i post this thread i m going to post a thread in their support forum too..

The other thing is, i completly uninstalled the vbseo files from my admin cp and server.. and i uploaded the 3.8.0 files and runned the upgrade script aand i enabled the plugin globally..

But still it is showing the same error

Is there any chance that i can goback to 3.7.4

And anyone here who is using vbseo faced the same problem when you upgraeded to 3.8.0?

I really need in help

could anyone tell me what should i do.. please

[SEOvB]

If you've contacted them and told you the problem is with vBSEO, then I suggest trying at their forums to get a fix.

You can't easily go back to 3.7.4 unless you made a backup prior to upgrading. Next time you may want to setup a test site to make sure everything is working.

[Lynne]

could anyone tell me what should i do.. please

There is no groupid column in the groupmessage table which means that is an error due to a modification and the correct thing to do is to post in the modification thread for help, or in this case, the modification forum.

[sebil]

shall i.. uninstall all the add ons in my forum and re install it..

and i contacted vbseo..
they said itsot because of vbseo..

but vb support team is saying it is because of vbseo

i got only vbseo site map gerator installed in my forum.. and i uninstalled it already.. but still my forum not working..

[Marco van Herwaarden]

I doubt this is caused by "vBSEO" (the product with this name). It could be that the "vBSEO Sitemap generator" is the culprit.

Support is correct that this is caused by a modification. Uploading the original files and disabling your modifications should solve the problem for now.

[TimberFloorAu]

did you install the vbseo vb 3.8.0 patch ?

[Phaedrus]

It's working for me.

And yes, you need a patch for the vBSEO...

But that is just redundant.

[sebil]

Originally Posted by TimberFloorAu

did you install the vbseo vb 3.8.0 patch ?

i havent installed the patch
from where can i get it/// ?

[iojam]

That query is not being run by vBSEO Sitemap Generator, I'd recommend to try disabling all your mods one-by-one to find out which one causes the issue.

[Brandon Sheley]

it might be a vbadvanced issue to me, if the index.php is messed up
but clicking on your site, everything looks like it's up and running