Hi,
I just got a database error. This occured about 10 minutes after making a CPanel Backup. I upgraded to 3.7.0 about 12 hours ago.
Here's the source of the error message:
I can access my Admincp, but it also displays this message:
Can anyone help?
Thanks in advance
I just got a database error. This occured about 10 minutes after making a CPanel Backup. I upgraded to 3.7.0 about 12 hours ago.
Here's the source of the error message:
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL]http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd[/URL]"> <html> <head> <title>**** Database Error</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" /> <style type="text/css"> <!-- body { background-color: white; color: black; } #container { width: 400px; } #message { width: 400px; color: black; background-color: #FFFFCC; } #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; } .bodytext { font: 8pt/11pt verdana, arial, sans-serif; } a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; } a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; } --> </style> </head> <body> <table cellpadding="3" cellspacing="5" id="container"> <tr> <td><img src="[URL]http://www.***/forums/image.php?type=dberror[/URL]" alt="Database Error" width="48" height="48" /></td> <td id="bodytitle" width="100%">Database error</td> </tr> <tr> <td class="bodytext" colspan="2">*** database has encountered a problem.</td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td class="bodytext" colspan="2"> Please try the following: <ul> <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li> <li>Open the <a href="/">www.****</a> home page, then try to open another page.</li> <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li> </ul> </td> </tr> <tr> <td class="bodytext" colspan="2">The [URL="http://www.****"]www.****[/URL] forum technical staff have been notified of the error, though you may <a href="[EMAIL="admin@****">contact"]mailto:admin@****">contact[/EMAIL] them</a> if the problem persists.</td> </tr> <tr> <td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td> </tr> </table> <!-- Database error in vBulletin 3.7.0: Invalid SQL: SELECT user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext , pagetext_html, postparsed.hasimages FROM thread AS thread LEFT JOIN post AS post ON (post.postid = thread.firstpostid) LEFT JOIN user AS user ON (user.userid = post.userid) LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1) WHERE thread.threadid IN(7461,7435,7370) ORDER BY thread.dateline DESC LIMIT 3; MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed Error Number : 1195 Request Date : Wednesday, April 30th 2008 @ 03:56:31 PM Error Date : Wednesday, April 30th 2008 @ 03:56:33 PM Script : [URL]http://www.***/forums/index.php[/URL] Referrer : IP Address : **** Username : Unregistered Classname : vb_database MySQL Version : --> </body> </html>
Code:
Database error in vBulletin 3.7.0: Invalid SQL: SELECT COUNT(*) AS count FROM attachment AS attachment INNER JOIN post AS post USING (postid) WHERE attachment.visible = 0; MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed Error Number : 1195 Request Date : Wednesday, April 30th 2008 @ 04:17:34 PM Error Date : Wednesday, April 30th 2008 @ 04:17:35 PM Script : [URL]http://www.****/forums/admincp/index.php?do=home[/URL] Referrer : [URL]http://www.****/forums/admincp/[/URL] IP Address : ** Username : **** Classname : vb_database MySQL Version : 4.1.22-standard
Thanks in advance
Comment