423,336 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,336 IT Pros & Developers. It's quick & easy.

Damaged SQL file how to repair?

P: 1
what caused this error? it seems to be a failure was not, and cleaning antivirus.

Database error in vBulletin 3.8.4:

Invalid SQL:

Expand|Select|Wrap|Line Numbers
  1. SELECT 
  2. IF(votenum >= 1, votenum, 0) as votenum, 
  3. IF (votenum >= 1 and votenum > 0, votetotal/ votenum, 0) AS voteavg, 
  4. post.pagetext AS preview, 
  5. thread.threadid, thread.title AS threadtitle, thread.forum, pollid, open, postusername, postuserid, thread.iconid AS threadiconid, 
  6. thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF (thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views, 
  7. thread.prefixid, thread.taglist, hiddencount, deletedcount 
  8. , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed 
  9. , deletionlog.userid as del_userid, deletionlog.username as del_username, deletionlog.reason AS del_reason 
  10.  
  11. , threadredirect.expires 
  12.  
  13. FROM vb_thread AS thread 
  14. LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid and deletionlog.type = 'thread') 
  15. LEFT JOIN vb_subscribethread AS subscribethread on (subscribethread.threadid = thread.threadid and subscribethread.userid = 1 AND canview = 1) 
  16.  
  17. LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid) 
  18.  
  19. LEFT JOIN vb_threadredirect AS threadredirect ON (thread.open = 10 and thread.threadid = threadredirect.threadid) 
  20.  
  21. WHERE thread.threadid IN (0,9839,6392,6391,1981,1473,88,1375) 
  22. ORDER BY sticky DESC, lastpost DESC;
SQL Error : Table './ klon/vb_post' is marked as cracked and should be repaired
Error Number : 145
IP Address: 90.188.220.91
Username : xD
Classname : vB_Database
SQL Version : 5.1.54
Jul 11 '18 #1

✓ answered by psammite

To restore the Project Server database, you can use the restore feature of Microsoft SQL Server. To do this, follow these steps:
1. Click Start, click AllPrograms, click Microsoft SQL Server, and then click SQL Server Management Studio.
2. In the Connect to Server dialog, the Server Type should be "Database Engine". Check the Server name and Authentication and make changes if needed, then click the Connect button.
3. Expand SQL Server if needed and then expand Databases.
4. Right-click the database, point to All Tasks, and then click Restore then click Database…. or you can try to use a paid service
5. From the list of backups, click the backup to restore, and then click OK to start the restore.
6. Click OK to confirm that the restore completed successfully.

Share this Question
Share on Google+
1 Reply


P: 2
To restore the Project Server database, you can use the restore feature of Microsoft SQL Server. To do this, follow these steps:
1. Click Start, click AllPrograms, click Microsoft SQL Server, and then click SQL Server Management Studio.
2. In the Connect to Server dialog, the Server Type should be "Database Engine". Check the Server name and Authentication and make changes if needed, then click the Connect button.
3. Expand SQL Server if needed and then expand Databases.
4. Right-click the database, point to All Tasks, and then click Restore then click Database…. or you can try to use a paid service
5. From the list of backups, click the backup to restore, and then click OK to start the restore.
6. Click OK to confirm that the restore completed successfully.
Jul 27 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.