1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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.