PDA

View Full Version : Is my vB at the brink of crashing?

Rebelde
Sun 4th Feb '01, 4:49pm
Members are getting this message :

"There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience."

PLEASE HELP TO FIX THIS PROBLEM. ALSO, NEW THREAD POSTINGS ARE NOT SHOWING UP.

When click on a category link, this is what shows up:

"Warning: MySQL: Unable to save result set in admin/db_mysql.php on line 89

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
"
Me2Be
Sun 4th Feb '01, 5:03pm
Click "view source" and post the error message on here so we can tell you what happened and what to do to fix it.
Rebelde
Sun 4th Feb '01, 5:10pm
<br>
<b>Warning</b>: MySQL: Unable to save result set in <b>admin/db_mysql.php</b> on line <b>89</b><br>

<!-- Database error in vBulletin: Invalid SQL: SELECT COUNT(thread.threadid) AS threads FROM thread WHERE thread.visible=1 AND thread.forumid=2 AND lastpost >= 978729300
mysql error: Can't find record in 'thread'
mysql error number: 1032
Date: Sunday 04th of February 2001 03:15:00 PM
Script: /forum/forumdisplay.php?forumid=2
Referer: http://www.rebelde.com/forum/index.php
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:webmaster@rebelde.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>
chrispadfield
Sun 4th Feb '01, 5:12pm
sounds like database corruption to me. Have a look for a post by eva2000, in his signature is a link to a very very good thread on sorting out database corruption.
Rebelde
Sun 4th Feb '01, 5:14pm
{htmldoctype}
<HTML>
<HEAD><TITLE>$bbtitle - $forumtitle</title>
$cssinclude
</head>
<body>
$header

<table border="0" width="100%"><tr>
<td valign="top" align="left"><a href="http://www.rebelde.com"><img src="$titleimage" border="0" alt="Return to Rebelde.com homepage, click here."></a></td>

<td valign="middle" align="center" nowrap>
$fivelinks
</td></tr></table>

<table border="0" width="100%" cellpadding="2">
<form action="forumdisplay.php" method="get">
<tr><td width="100%">

<normalfont><b><a href="index.php">$bbtitle</A> &gt; $forumtitle</b><br><smallfont>$moderatedby</smallfont></normalfont>

</td><td valign="bottom" align="right" nowrap>
<normalfont><b>Show threads from:</b></normalfont>
<INPUT TYPE="HIDDEN" NAME="forumid" VALUE="$forumid">
<SELECT NAME="daysprune">
<OPTION value="1" $daysprune1selected>Last day
<OPTION value="2" $daysprune2selected>Last 2 days
<OPTION value="5" $daysprune5selected>Last 5 days
<OPTION value="10" $daysprune10selected>Last 10 days
<OPTION value="20" $daysprune20selected>Last 20 days
<OPTION value="30" $daysprune30selected>Last 30 days
<OPTION value="45" $daysprune45selected>Last 45 days
<OPTION value="60" $daysprune60selected>Last 60 days
<OPTION value="75" $daysprune75selected>From last 75 days
<OPTION value="100" $daysprune100selected>From last 100 days
<OPTION value="365" $daysprune365selected>From the last year
<OPTION value="1000" $daysprune1000selected>Show all threads
</SELECT>
<INPUT TYPE="SUBMIT" VALUE="Go"></smallfont>
</TD></tr></form>
</table>


<table border=0 cellpadding=4 border=0 cellspacing=1 width="100%">
<tr bgcolor="{tableheadbgcolor}">
<td colspan=3>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<A HREF="newthread.php?action=newthread&forumid=$forumid"><IMG SRC="$newthreadimage" BORDER=0 ALT="Post New Thread"></A>
</td>
<td width="100%" align="center">
<smallfont color="{tableheadtextcolor}"><B>Thread</A></B></smallfont>
</td>
</tr></table>

</td>

<td align=center nowrap><smallfont color="{tableheadtextcolor}"><B>Thread Starter</B></smallfont>
</td>
<td align=center><smallfont color="{tableheadtextcolor}"><B>Replies</B></smallfont>
</td>
<td align=center><smallfont color="{tableheadtextcolor}"><B>Views</B></smallfont>
</td>
<td align=center nowrap>

<smallfont color="{tableheadtextcolor}"><B>Last Post</A></B></smallfont>

</td></tr>

$announcement
$forumdisplaybits

<TR bgcolor="{tableheadbgcolor}">
<TD valign="middle" width="100%" colspan="7">

<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>

<td valign="middle">
<A HREF="newthread.php?action=newthread&forumid=$forumid"><IMG SRC="$newthreadimage" BORDER=0 ALT="Post New Thread"></A>
</td>

<td width="100%" valign="middle" align="right">
<smallfont color="{tableheadtextcolor}"><b>
All times are $timezone. All dates are in Month-Day-Year format.</b></smallfont>
</td>

</tr></table>

</table>

<table border="0" width="100%" cellpadding="2">
<tr><td nowrap valign="top">

$forumjump

</td><td valign="top" align="right">
<smallfont>$pagenav</TD></tr></table>

<center><table border=0><tr>
<td><img src="images/newfolder.gif" border=0 alt="New Posts"></td>
<td><b><smallfont>New Posts</smallfont></b></td>
<td><img src="images/folder.gif" border=0 alt="No New Posts"></td>
<td><b><smallfont>No New Posts</smallfont></b></td>
<td><img src="images/newhotfolder.gif" border=0 alt="Hot Thread"><img src="images/hotfolder.gif" border=0 alt="Hot Thread"></td>
<td><b><smallfont>More than $hotnumber replies</smallfont></b></td>
<td><IMG SRC="images/lock.gif" BORDER=0 ALT="Closed Thread"></td>
<td><b><smallfont>Closed thread</smallfont></b>
</tr></table></center>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td width="100%">
<p><smallfont><b>Forum Rules:</b><br>
$forumrules</smallfont></p>
</td><td nowrap>
<p><smallfont><b>Admin Options:</b><br>
<a href="moderator.php?action=viewqueue&forumid=$forumid">View Moderation Queue</a><br>
<a href="moderator.php?action=move&forumid=$forumid">Mass Move</a><br>
<a href="moderator.php?action=prune&forumid=$forumid">Mass Prune</a>
</smallfont></td></tr></table>

$footer
</body>
</html>
Rebelde
Sun 4th Feb '01, 5:19pm
It cetainly is not a question of server space as other members have replied, because I am not even using one-fourth of my 300MB. What could it be? What causes a db corruption? Is it something I did on my end, or the members, the moderators, server, or is it vB's program?????
chrispadfield
Sun 4th Feb '01, 5:25pm
perhaps you missed my post. It is database corruption. Nothing to do with the html/templates etc. Somewhere along the line a call to the database went pear shaped and not it don't work properly (apparently the "thread" table is what went wrong which is why replies work (they go to the post table).

Find a post by eva2000, look in sig for solving database corruption and use that to sort it out. It is pretty easy.
Rebelde
Sun 4th Feb '01, 5:52pm
Chris the "view source" postings are replies to Me2Be Lady Moderator. I sent you an email by the way @ Ascifi.com.
chrispadfield
Sun 4th Feb '01, 6:15pm
got mail hope it helps.