My forum is not working when i upgraded to vb 3.8.0 , because of vbseo

[sebil]

Hii

I am in a big trouble..
and i really need your help
I m here as the VB support team advised..

Yesterday i upgraded my forum from 3.7.4 to 3.8.0 and everything went fine i runned the upgrade scipt and everything

but
i cant open my site.
it is showing data base error..

itz showing this 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 i contacted the vb support teamm
they said it becasue of the Vbseo

You need to contact vBSEO, this is an issue with their addons. Once you've patched the issue you can re-enable your addons...

My plugins are globally disabled now..

I need it to be enabled.. but when i enable it the site is not working

Could you please help me to fix this problem

Pleaaaaaaasseeeeee

[Ace Shattock]

Hi Sebil,

Before we can assist, we'll need to associate your User Account with your License.

Can you please PM me your transaction ID/other information that might assist?

[sebil]

i just have only the free version u published in the vbulletin.org i havent purchased the software..

:(

Please

[Michael Biddle]

Hello, this is an issue with the sitemap generator, not vBSEO itself.

Please see here: Links not working after site transfer

[sebil]

I followed the instruction said in Links not working after site transfer ..

but it still giving me the same error.. :(

i cant enable my plugins now.. if i do

itz showing this error message..

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 : Thursday, January 15th 2009 @ 03:28:58 PM
Error Date : Thursday, January 15th 2009 @ 03:28:58 PM
Script : http://www.malludreams.com/forum/index.php
Referrer : Log in - MalluDreams - vBulletin Admin Control Panel
IP Address : 86.146.12.136
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.67-community

:(

What should i do.. plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

[Mert Gökçeimam]

I followed the instruction said in Links not working after site transfer ..

but it still giving me the same error.. :(

i cant enable my plugins now.. if i do

itz showing this error message..



:(

What should i do.. plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

Hello ,

The error you receive clearly states that you didnt apply the fix. You need to apply the fix and upload the modified file back to your server.

[sebil]

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 : Thursday, January 15th 2009 @ 04:27:16 PM
Error Date : Thursday, January 15th 2009 @ 04:27:19 PM
Script : Welcome To MalluDreams::.. The Ultimate Mallu Community Of Friendship And Love
Referrer : Log in - MalluDreams - vBulletin Admin Control Panel
IP Address : 86.146.12.136
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.67-community

i made the changes..
im also attching a copy of the php file i edited as instructed..


please have a luk

did i made any mistake?

[sebil]

Please anyone could help me...... Please

[Oleg Ignatiuk]

Hello,

that error is not related to vBSEO Sitemap Generator (I see that it happens on your forums home, which is not affected by sitemap generator). You should open a ticket with vBulletin to resolve the issue.

[sebil]

okke i will do that