Links not working after site transfer

Hi I transfered my site from one server to a new one last night and repointed the domain to the new one. I had to turn VBSEO off as on the new transfered site the post links didnt work with it on. Is the something I need to run etc after transfering the site
Home || site frontpage

Database error in vBulletin 3.8.0 Beta 1:
Invalid SQL:
SELECT count(*)as cnt,max(dateline) as lastupdate
FROM vb_groupmessage
WHERE groupid='4';
MySQL Error : Unknown column 'groupid' in 'where clause'
Error Number : 1054
Request Date : Saturday, November 1st 2008 @ 06:55:39 AM
Error Date : Saturday, November 1st 2008 @ 06:55:42 AM
Script : Log in - British Film and cinema forum - vBulletin Admin Control Panel
Referrer : Log in - British Film and cinema forum - vBulletin Admin Control Panel
IP Address : 81.79.163.188
Username : Britmovie
Classname : vB_Database
MySQL Version : 5.0.45

When i tried to run a sitemap update i got this....i think its a reinstall job?

Make sure you uploaded vBSEO .htaccess to your forum root and your server supports mod_rewrite

For the second problem
find this in vbseo_sitemap_functions.php file:

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage
                 WHERE groupid='$rrow[groupid]'
             "); 


replace with

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage AS groupmessage
                 LEFT JOIN " . TABLE_PREFIX . "discussion AS discussion ON (groupmessage.discussionid = discussion.discussionid)
                 WHERE discussion.groupid='$rrow[groupid]'
             "); 


[SECTION START] showthread [5,855.4Kb mem used] [1,841,929s (+1,841,929s)]
[archive homepage] [5,940.2Kb mem used] [1,841,931s (+2s)]
[SECTION START] forumdisplay archived [5,941.1Kb mem used] [1,841,931s (+0s)]
[SECTION START] member [5,967.8Kb mem used] [1,841,931s (+0s)]
[SECTION START] polls [6,334.3Kb mem used] [1,841,931s (+0s)]
[SECTION START] blogs [6,341.3Kb mem used] [1,841,931s (+0s)]
[SECTION START] albums [6,380.5Kb mem used] [1,841,931s (+0s)]
[SECTION START] groups [6,382.6Kb mem used] [1,841,931s (+0s)]
Database error


Database error in vBulletin 3.8.0 Beta 1:
Invalid SQL:
SELECT count(*)as cnt,max(dateline) as lastupdate
FROM vb_groupmessage
WHERE groupid='4';
MySQL Error : Unknown column 'groupid' in 'where clause'
Error Number : 1054
Request Date : Saturday, November 1st 2008 @ 02:43:46 PM
Error Date : Saturday, November 1st 2008 @ 02:43:48 PM
Script : Log in - British Film and cinema forum - vBulletin Admin Control Panel
Referrer : Log in - British Film and cinema forum - vBulletin Admin Control Panel
IP Address : 81.79.163.188
Username : Britmovie
Classname : vB_Database
MySQL Version : 5.0.45

Looks like you did not apply code modification as described above, you still have an old db query there:

Code:

Invalid SQL:
SELECT count(*)as cnt,max(dateline) as lastupdate
FROM vb_groupmessage
WHERE groupid='4';

Hi I did replace the code with the code supplied but it did not do anything at all so I reverted the file back to the existing file?

Originally Posted by Mert Gökçeimam

Make sure you uploaded vBSEO .htaccess to your forum root and your server supports mod_rewrite

For the second problem
find this in vbseo_sitemap_functions.php file:

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage
                 WHERE groupid='$rrow[groupid]'
             "); 


replace with

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage AS groupmessage
                 LEFT JOIN " . TABLE_PREFIX . "discussion AS discussion ON (groupmessage.discussionid = discussion.discussionid)
                 WHERE discussion.groupid='$rrow[groupid]'
             "); 


====================
Sorry this didnt work?

Hello,

that code modification should resolve database error that is mentioned in post #2, which is related to vBSEO Sitemap Generator.
The issue described in post #1 is not related to it, what exactly is the error you get with vBSEO enabled?

The link problem was solved I just reinstalled and it worked great.
The sitemap doesnt generate and gives

Code:

vBSEO Sitemap Generator 
[SECTION START] showthread [6,321.1Kb mem used] [1,937,610s (+1,937,610s)]
[archive homepage] [6,430.1Kb mem used] [1,937,611s (+1s)]
[SECTION START] forumdisplay archived [6,431.1Kb mem used] [1,937,611s (+0s)]
[SECTION START] member [6,457.0Kb mem used] [1,937,611s (+0s)]
[SECTION START] polls [6,825.8Kb mem used] [1,937,611s (+0s)]
[SECTION START] blogs [6,832.9Kb mem used] [1,937,611s (+0s)]
[SECTION START] albums [6,872.4Kb mem used] [1,937,611s (+0s)]
[SECTION START] groups [6,874.5Kb mem used] [1,937,611s (+0s)]
		Database errorThe British Film and cinema forum database has encountered a problem.Please try the following: 
Load the page again by clicking the Refresh button in your web browser.
Open the www.britmovie.net home page, then try to open another page.
Click the Back button to try another link.
The Home || site frontpage forum technical staff have been notified of the error, though you may contact them if the problem persists. 
We apologise for any inconvenience.

and in a subframe

Code:

Database error in vBulletin 3.8.0 Beta 1:
Invalid SQL:
           SELECT count(*)as cnt,max(dateline) as lastupdate
           FROM vb_groupmessage
           WHERE groupid='4';
MySQL Error   : Unknown column 'groupid' in 'where clause'
Error Number  : 1054
Request Date  : Sunday, November 2nd 2008 @ 12:25:53 PM
Error Date    : Sunday, November 2nd 2008 @ 12:25:54 PM
Script        : Log in - British Film and cinema forum - vBulletin Admin Control Panel
Referrer      : Log in - British Film and cinema forum - vBulletin Admin Control Panel
IP Address    : 81.79.163.188
Username      : Britmovie
Classname     : vB_Database
MySQL Version : 5.0.45

This is with the code you gave me?

If you look at the query it is showing that it is still the old format of the query. Make sure that you download that file, make the edits, save it, then reupload it. If that still does not work, please open a support ticket with your FTP info as well as your admincp info so we can look into it for you.

Originally Posted by Mert Gökçeimam

Make sure you uploaded vBSEO .htaccess to your forum root and your server supports mod_rewrite

For the second problem
find this in vbseo_sitemap_functions.php file:

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage
                 WHERE groupid='$rrow[groupid]'
             "); 


replace with

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage AS groupmessage
                 LEFT JOIN " . TABLE_PREFIX . "discussion AS discussion ON (groupmessage.discussionid = discussion.discussionid)
                 WHERE discussion.groupid='$rrow[groupid]'
             "); 


I had the same problem, and that code fixed it. Thank you very much!

Merhaba Mert bey.

Açtığım ticket'in cevabı burdaymış ingilizcem ileri derecede zayıf ama attım tuttu galiba .htaccess dosyasını değiştirip vermiş olduğunuz kodları değiştirdim şuanda bir sorun görünmüyor teşekkür ederim

Originally Posted by Mert Gökçeimam

For the second problem
find this in vbseo_sitemap_functions.php file:

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage
                 WHERE groupid='$rrow[groupid]'
             "); 


replace with

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "groupmessage AS groupmessage
                 LEFT JOIN " . TABLE_PREFIX . "discussion AS discussion ON (groupmessage.discussionid = discussion.discussionid)
                 WHERE discussion.groupid='$rrow[groupid]'
             "); 


This is the solution for my problem after the vbulletin update 3.7.4 to 3.8.

Thanks

I've got exactly the same db issue after upgraded to 3.8.0
It was kind of though found out what was causing this. Finally I saw sitemap generator was not working any longer.
Searched here I found Mert's patch for this.

Just used it and solved the problem at all.

This patch is mandatory for who upgraded to 3.8.0 and have Social Groups enabled because there are some differences on Social Groups db from 3.7.X to 3.8.0

Thanks

why hasnt there been created a new working sitemap generator in the downloads section yet? we shouldnt hunt bugs and patch them ourselves should we?