Database error hatasını ücret karşılığı düzeltecek

09-06-2009, 18:37:07

Database error
The ........ database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.............home page, then try to open another page.
Click the Back button to try another link.

The www................ forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

---------------------------
ücreti karşılığında hatayı düzeltecek ve sitenin yedeğini alabilecek,iş bankası hesabı olan arkadaş aranıyor.
istediğiniz ücreti pm ile iletirseniz sevinirim.iyi günler diliyorum.

09-06-2009, 18:43:56

#2

Elazığlı168

sunucuoptimizasyon.com

Ücrete gerek yok arkadaşım sayfanın kaynak kodlarını koyarsan hatanın ne olduğu konusunda fikir yürütebiliriz.

09-06-2009, 18:55:31

#3

ncetin

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<title>bestoFFrm 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="http://www.bestoffrm.com/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 bestoFFrm 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.bestoffrm.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.bestoffrm.com forum technical staff have been notified of the error, though you may <a href="mailto:dbmaster@example.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>


<!--
Database error in vBulletin 3.7.4:

Invalid SQL:

				SELECT *
				FROM session
				WHERE userid = 0
					AND host = '78.161.99.157'
					AND idhash = 'fc9c2b82a54e2e6f07ea946a27862511'
				LIMIT 1;

MySQL Error   : Table 'best.session' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, June 9th 2009 @ 06:52:39 PM
Error Date    : Tuesday, June 9th 2009 @ 06:52:39 PM
Script        : http://www.bestoffrm.com/
Referrer      : 
IP Address    : 78.161.99.157
Username      : 
Classname     : vB_Database
MySQL Version : 
-->


</body>
</html>

09-06-2009, 19:02:35

#4

Elazığlı168

sunucuoptimizasyon.com

Hatada session tablosunun olmadığından bahsediyor.
Aşağıdaki sorguyu phpmyadmin üzerinden çalıştırınız.

Alıntı

CREATE TABLE IF NOT EXISTS best.session (
sessionhash varchar(32) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
host varchar(15) NOT NULL default '',
lastactivity int(10) unsigned NOT NULL default '0',
styleid smallint(5) unsigned NOT NULL default '0',
location varchar(255) NOT NULL default '',
althash varchar(32) NOT NULL default '',
badlocation tinyint(3) unsigned NOT NULL default '0',
inforum smallint(5) unsigned NOT NULL default '0',
inthread int(10) unsigned NOT NULL default '0',
incalendar int(10) unsigned NOT NULL default '0',
loggedin smallint(5) unsigned NOT NULL default '0',
idhash varchar(32) NOT NULL default '',
useragent varchar(100) NOT NULL default '',
bypass smallint(6) NOT NULL default '0',
PRIMARY KEY (sessionhash)
) TYPE=HEAP;

09-06-2009, 19:02:47

#5

Ozcan_SARICA

sanırım vb kurulu .. vb'yi upgrade edin hocam düzelecektir.

09-06-2009, 19:04:14

#6

Onurss

Kurumsal Üye

phpmyadmin'den aşağıdaki sorguyu çalıştırın,

CREATE TABLE IF NOT EXISTS `session` (
  `sessionhash` char(32) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `host` char(15) NOT NULL default '',
  `idhash` char(32) NOT NULL default '',
  `lastactivity` int(10) unsigned NOT NULL default '0',
  `location` char(255) NOT NULL default '',
  `useragent` char(100) NOT NULL default '',
  `styleid` smallint(5) unsigned NOT NULL default '0',
  `languageid` smallint(5) unsigned NOT NULL default '0',
  `loggedin` smallint(5) unsigned NOT NULL default '0',
  `inforum` smallint(5) unsigned NOT NULL default '0',
  `inthread` int(10) unsigned NOT NULL default '0',
  `incalendar` smallint(5) unsigned NOT NULL default '0',
  `badlocation` smallint(5) unsigned NOT NULL default '0',
  `bypass` tinyint(4) NOT NULL default '0',
  `profileupdate` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`sessionhash`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

09-06-2009, 19:10:06

#7

ncetin

phpmyadminden sorguyu çalıştırdım ama düzelmedi arkadaşlar

09-06-2009, 19:12:41

#8

Elazığlı168

sunucuoptimizasyon.com

Yeni hata kodlarını koyunuz.

09-06-2009, 19:17:51

#9

ncetin

phpmyadminde sorgunuz başarıyla çalıştırılmıştır yazıyor.

site adresi : www.bestoffrm.com