Results 1 to 3 of 3

Lost connection

This is a discussion on Lost connection within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; Ok seems to happen on the 44 file when doing 20,000 and 21 file when doing 40,000 per file. Anyway ...

  1. #1
    Junior Member
    Join Date
    Aug 2005
    Location
    Glasgow, Scotland
    Posts
    21
    Liked
    0 times

    Lost connection

    Ok seems to happen on the 44 file when doing 20,000 and 21 file when doing 40,000 per file. Anyway to sort this?
    Code:
    Database error in vBulletin 3.5.3:
    
    Invalid SQL:
    
                        SELECT p.dateline,p.postid,p.threadid
                        FROM post AS p
                        WHERE p.threadid = 37480
                        ORDER BY p.dateline;
    
    MySQL Error  : Lost connection to MySQL server during query
    Error Number : 2013
    Date         : Monday, March 6th 2006 @ 08:42:48 AM
    Script       : http://www.altnation.com/forums/admincp/cronadmin.php?do=runcron&cronid=26
    Referrer     : http://www.altnation.com/forums/admincp/cronadmin.php?do=modify
    IP Address   : 86.144.181.212

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

    you can setup the system cron job (using crontab) instead of using vB scheduler for sitemap generation.
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  3. #3
    Junior Member
    Join Date
    Aug 2005
    Location
    Glasgow, Scotland
    Posts
    21
    Liked
    0 times
    Found the problem mysql was timing out because we have over 2,000,000 posts and it was taking so long.

Similar Threads

  1. lost google ranking :(
    By piepo in forum Analysis: Traffic & SERPS
    Replies: 3
    Last Post: 01-07-2006, 05:19 PM
  2. Lost about 50,000 pages in google
    By MentaL in forum General Discussion
    Replies: 17
    Last Post: 11-19-2005, 03:06 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
  •