vBulletin Search Engine Optimization
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 ...
| |||||||
Enhancing 80 million pages. | Register | FAQ | Members List | Social Groups | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
| |||
| |||
| 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
| ||||
| ||||
| Re: Lost connection
Hello, you can setup the system cron job (using crontab) instead of using vB scheduler for sitemap generation.
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#3
| |||
| |||
| Re: Lost connection
Found the problem mysql was timing out because we have over 2,000,000 posts and it was taking so long.
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| lost google ranking :( | piepo | Analysis: Traffic & SERPS | 3 | 01-07-2006 05:19 PM |
| Lost about 50,000 pages in google | MentaL | General Discussion | 17 | 11-19-2005 03:06 PM |