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!!