Database Error After Upgrade

Hi,

Looking for help after i Converted sitemap to vB4, now recieve this DB error...

Running on Version vB 4.1.1

Hello James,

Please try to look up at the source code to find the exact error message you are seeing, and then paste it here for further troubleshooting.

Thanks for the reply Andrés, is this the source you mean?

Code:

<title>Football Forums Database Error</title>
 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
 <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
 <style type="text/css">

Thanks...

No James, at the very end of the source page you'll see a database error commented out. Please copy and paste it here.

Without even seeing the DB error in full, 111,000 seconds of run time means that it isn't completing. You're likely seeing mysql gone away errors, which means you need to increase your wait_timeout setting in my.cnf, or remove some bloat from the sitemap so that it runs faster.

Hope this helps guys ..

Code:

MySQL Error   : Table 'football_forum.tagthread' doesn't exist
Error Number  : 1146
Request Date  : Saturday, January 29th 2011 @ 01:41:23 PM
Error Date    : Saturday, January 29th 2011 @ 01:41:23 PM
Script        : http://www.***********.com/forum/vbs...eo_sitemap.php
Referrer      : http://www.***********.com/forum/vbs...emap/index.php
IP Address    : ***********
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Also i emptied all logs, now the top reading is this ...

Code:

[SECTION START] tags [9,538.8Kb mem used] [129,226s (+20,355s)]

Thanks ..

vBulletin doesn't create a table called 'tagthread' on a default vB installation, so that your issue seems to be coming from another modification. Disabling adding tags to your sitemap might fix your issue .

Originally Posted by Andrés Durán Hewitt

vBulletin doesn't create a table called 'tagthread' on a default vB installation, so that your issue seems to be coming from another modification. Disabling adding tags to your sitemap might fix your issue .

Thats it Matey ...

Excellent work .. Thanks ...

You're welcome! .

We are glad to help.