Database Errors :(

Discussion in 'MySQL' started by DsCreaTionS, Jun 21, 2008.

Thread Status:
Not open for further replies.
  1. #1
    Okay i switched hosts....I backed up my database for my forums.. But there was a problem and i already crashed the the other host. So i fixed the problem. But i keep on getting errors.. I took out attachments. site url:
    dscreations.info
    Code (markup):
    Oh and these errors are being sent to my e-mail so if anybody else wants to look in deeper i'll let them in my e-mail.. Idc about it b/c i never use it..
    One error:
    Database error in vBulletin 3.6.8:
     
    Invalid SQL:
     
    				SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
    					IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
    					attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
    				FROM vb_attachment AS attachment
    				LEFT JOIN vb_attachmenttype AS attachmenttype USING (extension)
    				WHERE posthash = '20625f331310df6b1886bbd209ecef5e'
    					AND userid = 592
    				ORDER BY attachmentid;
     
    MySQL Error  : Table 'dscreati_forum.vb_attachmenttype' doesn't exist
    Error Number : 1146
    Date         : Friday, June 20th 2008 @ 07:18:35 PM
    Script       : http://dscreations.info/newthread.php?do=postthread&f=19
    Referrer     : http://dscreations.info/newthread.php?do=newthread&f=19
    IP Address   : 67.169.174.126
    Username     : Pwnedgamer
    Classname    : vB_Database
    Code (markup):
    Theres more.. :(
     
    DsCreaTionS, Jun 21, 2008 IP
  2. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #2
    Make sure that your database has been successfully restored on the new server. Also you may try to repair your database. Please a full back before repairing it. Also check that the database table vb_attachmenttype is present in your database dscreati_forum.
     
    kailash, Jun 23, 2008 IP
Thread Status:
Not open for further replies.