Announcement

Collapse
No announcement yet.

1146 and 1054 Error!! Here's the errors I'm getting. in the Admincp.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Fungsten
    replied
    I ran the sql command to make/rebuild the tables but came up with this error:


    An error occurred while attempting to execute your query. The following information was returned.
    error number: 1050
    error desc: Table 'album' already exists

    Leave a comment:


  • 1146 and 1054 Error!! Here's the errors I'm getting. in the Admincp.

    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

    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-insttal VBulletin - 404 Error on step 3. Please help!!

    TIA.


    On edit:


    Database error in vBulletin 3.8.5:
    Invalid SQL:
    SELECT albumpicture.*, album.*, user.username, user.usergroupid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM albumpicture AS albumpicture
    LEFT JOIN album AS album ON(album.albumid = albumpicture.albumid)
    LEFT JOIN user AS user ON(user.userid = album.userid)
    WHERE album.state = 'public'
    ORDER BY dateline DESC LIMIT 0, 5;
    MySQL Error : Table 'XXXXXXXX.albumpicture' doesn't exist
    Error Number : 1146
    Request Date : Thursday, March 25th 2010 @ 05:25:48 PM
    Error Date : Thursday, March 25th 2010 @ 05:25:49 PM
    Script : http://Blahblahblahforum/index.php
    Referrer : http://blahblah/forum/online.php?
    IP Address : XXX.XXX.XXX.XXX
    Username : XXXXXXXXXXXXXXX
    Classname : vB_Database
    MySQL Version : 5.0.89-community
    This error is only on the forum listings.
    Last edited by Fungsten; Thu 25 Mar '10, 2:28pm. Reason: Fixed the 1146 problem.

Related Topics

Collapse

Working...
X