Results 1 to 2 of 2

sql error sitemap generator

This is a discussion on sql error sitemap generator within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; Hi, Several days to generate the sitemap sql gives me these errors. The hosting provider says it is a problem ...

  1. #1
    Junior Member
    Real Name
    jorge
    Join Date
    Jan 2009
    Posts
    3
    Liked
    0 times

    sql error sitemap generator

    Hi,
    Several days to generate the sitemap sql gives me these errors. The hosting provider says it is a problem with vbseo / sitemap generator.

    I have vbulletin 3.8.2,vbseo 3.3 and sitemap 2.5. The errors:

    HTML Code:
    Database error in vBulletin 3.8.2:
    
    Invalid SQL:
    
                    SELECT count(*) as cnt
                        ,max(views) as maxv,avg(views) as avgv
                        ,max(replycount) as maxre,avg(replycount) as avgre
                    FROM vbulletin_thread 
                    WHERE forumid = 399
                        AND visible = 1;
    
    MySQL Error   : MySQL server has gone away
    Error Number  : 2006
    Request Date  : Friday, May 1st 2009 @ 09:27:46 AM
    Error Date    : Friday, May 1st 2009 @ 09:28:56 AM
    Script        : http://www.xxxx/admincp/cronadmin.php?do=runcron&cronid=40
    Referrer      : http://www.xxxx/admincp/cronadmin.php?do=modify
    HTML Code:
    Invalid SQL:
     
                    SELECT count(*) as cnt
                        ,max(views) as maxv,avg(views) as avgv
                        ,max(replycount) as maxre,avg(replycount) as avgre
                    FROM vbulletin_thread 
                    WHERE forumid = 156
                        AND visible = 1;
     
    MySQL Error   : MySQL server has gone away
    Error Number  : 2006
    Request Date  : Thursday, April 30th 2009 @ 08:50:13 AM
    Error Date    : Thursday, April 30th 2009 @ 08:54:18 AM
    Script        : http://www.xxxxxxx/admincp/cronadmin.php?do=runcron&cronid=40
    Referrer      : http://www.xxxxx/admincp/cronadmin.php?do=modify
    IP Address    : xxx
    Username      : xxxx
    Classname     : vB_Database
    MySQL Version :
    HTML Code:
    Database error in vBulletin 3.8.2:
     
    Invalid SQL:
     
                    SELECT count(*) as cnt
                        ,max(views) as maxv,avg(views) as avgv
                        ,max(replycount) as maxre,avg(replycount) as avgre
                    FROM vbulletin_thread 
                    WHERE forumid = 344
                        AND visible = 1;
     
    MySQL Error   : MySQL server has gone away
    Error Number  : 2006
    Request Date  : Thursday, April 30th 2009 @ 02:00:23 AM
    Error Date    : Thursday, April 30th 2009 @ 02:02:10 AM
    Script        : http://www.xxxxxx/cron.php?rand=1241049605
    Referrer : xxxxxx
    IP Address    : xxxxx
    Username      : No Registrado
    Classname     : vB_Database
    MySQL Version :
    

  2. #2
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,744
    Liked
    169 times
    Hello,

    you should increase wait_timeout setting in MySQL configuration on your server to avoid that.

Similar Threads

  1. Another error during Run Sitemap generator
    By hg_snake in forum Troubleshooting
    Replies: 2
    Last Post: 02-01-2009, 11:01 AM
  2. Vbseo Sitemap Generator gives error.
    By Future in forum Troubleshooting
    Replies: 7
    Last Post: 07-26-2008, 04:08 AM
  3. Running sitemap generator gives database error
    By T2DMan in forum Troubleshooting
    Replies: 2
    Last Post: 07-01-2008, 08:39 AM
  4. sitemap 2.1 Generator DB Error!
    By Fragmaster in forum Troubleshooting
    Replies: 2
    Last Post: 05-13-2008, 12:36 AM
  5. Run Sitemap Generator error
    By Cos in forum Troubleshooting
    Replies: 2
    Last Post: 07-22-2007, 03:17 PM

Posting Permissions

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