database problems?

Hill-Shatar · Post by **Hill-Shatar** » Mon Apr 10, 2006 12:46 am

An additional error -- in the Oblivion forum I noticed a new member who had posted two threads with a postcount of zero. Postcount is no longer working.

Ashen · Post by **Ashen** » Mon Apr 10, 2006 4:23 am

I am getting the same ones as Hill Shatar in the Oblivion forums this morning, they seem to be heavily hit - people who are not on line, seem to be, no post counts, no show of posts.

Invalid SQL:

REPLACE INTO postindex
(wordid, postid, score, intitle)
VALUES
(1924432, 818509, 1, 0), (1918274, 818509, 1, 0), (1926964, 818509, 1, 0), (1924137, 818509, 1, 0), (1923534, 818509, 1, 0), (1918400, 818509, 1, 0), (1919992, 818509, 1, 0), (1921961, 818509, 1, 0), (1918042, 818509, 1, 0);

MySQL Error : Can't open file: 'postindex.MYI' (errno: 144)
Error Number : 1016
Date : Monday, April 10th 2006 @ 06:21:18 AM
Script : http://www.gamebanshee.com/forums/newreply.php

dj_venom · Post by **dj_venom** » Mon Apr 10, 2006 4:39 am

[QUOTE=Hill-Shatar]EDIT- A link for Athena's username as last poster of the SS has taken me to DJV's profile. DJV is not the last poster there either.[/QUOTE]

That's what Athena mentioned earlier. It's not showing the pages after 1136. I am in fact the latest poster, after about 20 posts by Athena.

Fiona · Post by **Fiona** » Mon Apr 10, 2006 4:54 am

I just got a new trick. I posted in the SS and the front page shows me as last poster, but the post itself is not there. What is this, quality control?

Ravager · Post by **Ravager** » Mon Apr 10, 2006 5:21 am

[QUOTE=Hill-Shatar]and the last poster in the SS was Athena, even though Lestat triple posted last.

That's what I get. In SYM it shows a post today as the latest post, I go into the thread and is shows Lestat's triple post. So, I go to reply and below the reply window it shows newer replies, but when I try to post I get the Database Error followed by the Invalid Thread. So, that locks me out from posting in the SS thread.

Ravager · Post by **Ravager** » Mon Apr 10, 2006 5:22 am

Accidental D.P.

Ravager · Post by **Ravager** » Sun Apr 23, 2006 2:54 pm

GB seems to be slowing down again tonight...and I received another Database Error not so long ago.

mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (11)
/home/gbadmin/htdocs/forums/includes/class_core.php on line 279

Kipi · Post by **Kipi** » Mon Aug 28, 2006 10:05 am

I got DB errors again today, and the site seems to be rather slow now.
I'm getting the error only when trying to go the forums main page.

Here is the code:

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<title> Database Error</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
	<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="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
	<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">The  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.gamebanshee.com</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 www.gamebanshee.com forum technical staff have been notified of the error, though you may <a href="mailto:bucksatan@gamebanshee.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
	<td class="bodytext" colspan="2"> 
We apologise for any inconvenience.</td>
</tr>
</table>


<!--
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
/usr/local/apache/sites/gamebanshee.com/htdocs/forums/includes/class_core.php on line 271

MySQL Error  : 
Error Number : 
Date         : Monday, August 28th 2006 @ 11:00:22 AM
Script       : http://www.gamebanshee.com/forums/
Referrer     : http://www.gamebanshee.com/forums/non-rpg-game-discussion-15/
IP Address   : 88.192.33.165
Username     : 
Classname    : vB_Database
-->


</body>
</html>