Getting this 1054 Error in the ACP.

[Fungsten]

Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT SUM(filesize) AS size FROM attachment;
MySQL Error : Unknown column 'filesize' in 'field list'
Error Number : 1054
Request Date : Thursday, March 25th 2010 @ 04:09:47 PM
Error Date : Thursday, March 25th 2010 @ 04:09:47 PM
Script : http://blahblahblah/forum/admincp/index.php?do=home
Referrer : http://www.blahblahblah.com/forum/ad...dex.php?do=nav
IP Address : XXX.XXX.XXX.XXX
Username : XXXXXXXXX
Classname : vB_Database
MySQL Version : 5.0.89-community

Here's some background on what happened:

What happened was I was updating one website and had inadvertantly used the username, passwords, etc. from another site I own! After I noticed that the update stalled so I checked the PW, database name, etc and corrected them and that site's working fine. Now I am still getting the above error in the AdminCP from which I erroneously took the PW's from; the other site that I tried to update - the one that had the wrong passwords is fine! It's the site that I got the wrong PWs from that I'm having the problems with. Also I tried to reinstall VBulletin and I cannot get past step two when choosing to update; 404 Error. In the AdminCP I can access items from the CP but I cannot get the forum's listing or re-install VBulletin - 404 Error on step 3. Please help!!

TIA.

[Lynne]

I'm not sure what you did, but there is supposed to be a field called filesize in the attachment table. If you don't have it, then you need to add it.

filesize INT UNSIGNED NOT NULL DEFAULT '0'

[Fungsten]

Originally Posted by Lynne

I'm not sure what you did, but there is supposed to be a field called filesize in the attachment table. If you don't have it, then you need to add it.

filesize INT UNSIGNED NOT NULL DEFAULT '0'

Where should I add it in the template? TIA.

On Edit:

I put it at the top of the template but it didn't work.

[Lynne]

That is information for you to add the field in your database. You did something and it got deleted. You need to add it back. If you don't know how to do this, you may have to ask your host.

[Fungsten]

Originally Posted by Lynne

That is information for you to add the field in your database. You did something and it got deleted. You need to add it back. If you don't know how to do this, you may have to ask your host.

:up:

--------------- Added [DATE]1269727890[/DATE] at [TIME]1269727890[/TIME] ---------------

Originally Posted by Lynne

That is information for you to add the field in your database. You did something and it got deleted. You need to add it back. If you don't know how to do this, you may have to ask your host.

This is the error I got when I ran it:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'filesize INT UNSIGNED NOT NULL DEFAULT '0'' at line 1

[Fungsten]

Lynne. Did you want to make a few bucks and try to fix the DB problems?

[Lynne]

You cannot just run that one line since it doesn't have the table information in it. I thought you were just gonna add it manually through phpMyAdmin and that is the information needed for the field.

[Fungsten]

Originally Posted by Lynne

You cannot just run that one line since it doesn't have the table information in it. I thought you were just gonna add it manually through phpMyAdmin and that is the information needed for the field.

It didn't work though. Is there a way to re-build/add the table info?

[Fungsten]

Originally Posted by Lynne

You cannot just run that one line since it doesn't have the table information in it. I thought you were just gonna add it manually through phpMyAdmin and that is the information needed for the field.

Lynne, did you want to make a few bucks fixing the problem?