Results 1 to 5 of 5

SQL Error generated possibly by Sitemap cron job

This is a discussion on SQL Error generated possibly by Sitemap cron job within the Bug Reporting forums, part of the vBSEO Google/Yahoo Sitemap category; Not sure what the problem is or caused by Whom I upgraded to vb 3.8 rc1. Since the Upgrade I ...

  1. #1
    JWL
    JWL is offline
    Senior Member JWL's Avatar
    Real Name
    John
    Join Date
    Sep 2008
    Location
    North Bay Area
    Posts
    104
    Liked
    0 times

    SQL Error generated possibly by Sitemap cron job

    Not sure what the problem is or caused by Whom

    I upgraded to vb 3.8 rc1. Since the Upgrade I am getting a single SQL error every morning about the same time. I have received the same SQL from these two points per the time stamp of the error and when these cron jobs hit.

    vbadvanced says there is not queries from thier product.

    So I am asking can Sitemap be doing this, I have the latest sitemap and latest vbSEO


    1388 vBSEO Sitemap Generator 06:06, 8th Dec 2008 Google Sitemap [Started]
    1387 vBa Dynamics Entry Cache 06:05, 8th Dec 2008
    1386 vBa Dynamics Search Cleanup 06:05, 8th Dec 2008


    PHP Code:
    ===================================================== 

    Database error in vBulletin 3.8.0 Release Candidate 1

    Invalid SQL

                     
    SELECT count(*)as cnt,max(dateline) as lastupdate 
                     FROM groupmessage 
                     WHERE groupid
    ='1'

    MySQL Error   Unknown column 'groupid' in 'where clause' 
    Error Number  1054 
    Request Date  
    MondayDecember 8th 2008 06:06:40 AM 
    Error Date    
    MondayDecember 8th 2008 06:06:43 AM 
    Script        
    http://www.sportcityrider.com/cron.php?rand=1228745197 
    Referrer      http://www.sportcityrider.com/f21/ama-sbk-daytona-tire-test-friday-afternoon-notebook-1222/ 
    IP Address    xxx.xxx.xxx.xxx 
    Username      
    Unregistered 
    Classname     
    vB_Database 
    MySQL Version 
    :  
    ===================================================== 

    Database error in vBulletin 3.8.0 Release Candidate 1

    Invalid SQL

                     
    SELECT count(*)as cnt,max(dateline) as lastupdate 
                     FROM groupmessage 
                     WHERE groupid
    ='1'

    MySQL Error   Unknown column 'groupid' in 'where clause' 
    Error Number  1054 
    Request Date  
    TuesdayDecember 9th 2008 05:43:16 AM 
    Error Date    
    TuesdayDecember 9th 2008 05:43:19 AM 
    Script        
    http://www.sportcityrider.com/cron.php?rand=1228830193 
    Referrer      http://www.sportcityrider.com/f13/ 
    IP Address    xxx.xxx.xxx.xxx 
    Username      
    Unregistered 
    Classname     
    vB_Database 
    MySQL Version 
    :  
    ===================================================== 

    Database error in vBulletin 3.8.0 Release Candidate 1

    Invalid SQL

                     
    SELECT count(*)as cnt,max(dateline) as lastupdate 
                     FROM groupmessage 
                     WHERE groupid
    ='1'

    MySQL Error   Unknown column 'groupid' in 'where clause' 
    Error Number  1054 
    Request Date  
    WednesdayDecember 10th 2008 06:41:24 AM 
    Error Date    
    WednesdayDecember 10th 2008 06:41:28 AM 
    Script        
    http://www.sportcityrider.com/cron.php?rand=839954 
    Referrer      http://www.sportcityrider.com/ 
    IP Address    xxx.xxx.xxx.xxx 
    Username      
    Unregistered 
    Classname     
    vB_Database 
    MySQL Version 
    :  
    ===================================================== 

  2. #2
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    try disabling social groups from the sitemap settings options. the tables have changed a bit in 3.8, and since it's not final software, vbseo is not final for it yet either.

  3. #3
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    You can apply this modification: Links not working after site transfer

  4. #4
    JWL
    JWL is offline
    Senior Member JWL's Avatar
    Real Name
    John
    Join Date
    Sep 2008
    Location
    North Bay Area
    Posts
    104
    Liked
    0 times
    Cool, Disabling it worked, I ran generator after no error. I will do the mod when I get home

    Thanks Oleg & Brian

  5. #5
    JWL
    JWL is offline
    Senior Member JWL's Avatar
    Real Name
    John
    Join Date
    Sep 2008
    Location
    North Bay Area
    Posts
    104
    Liked
    0 times
    I enabled it and ran and got the error

    I applied the fix and left Social Groups enabled and did not receive error

    This place is great

Similar Threads

  1. Sitemap Cron is running, but no file are generated
    By MRBarto in forum Troubleshooting
    Replies: 5
    Last Post: 07-30-2008, 10:23 PM
  2. Sitemap Cron not working
    By Mikenificent in forum Troubleshooting
    Replies: 7
    Last Post: 04-25-2008, 06:23 PM
  3. Sitemap 2.1 - 2 x cron job
    By mljask in forum General Discussion
    Replies: 2
    Last Post: 01-29-2008, 04:09 PM
  4. vBSEO Sitemap Generator generated incorrect sitemap URL
    By X1C3W5 in forum Troubleshooting
    Replies: 2
    Last Post: 01-02-2008, 11:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •