Database Error

**Valerio80** · 13-10-2008, 14:36

Non so cosa sia successo..

ma adesso fa questo errore:

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagthread AS tagthread
INNER JOIN tag AS tag ON (tagthread.tagid = tag.tagid)
INNER JOIN thread AS thread ON (tagthread.threadid = thread.threadid)
WHERE thread.open <> 10
AND thread.visible = 1
AND thread.forumid IN (348,190,290,214,10,53,46,172,144,400,360,461,459, 413,395,158,98,192,393,441,440,146,430,437,431,432 ,433,434,435,436,397,398,306,411,5,16,352,353,349, 17,439,438,443,66,406,418,407,247,408,419,18,68,29 4,85,289,262,263,274,285,288,287,286,275,277,278,2 79,281,276,333,4,44,69,70,71,19,55,399,57,292,52,2 8,251,372,254,253,252,291,73,74,245,246,21,86,362, 405,83,111,307,159,268,269,270,271,347,20,6,24,22, 60,389,244,249,147,386,43,219,403,318,319,320,322, 391,7,29,153,49,26,42,264,76,77,54,27,256,30,257,7 8,355,356,359,357,358,365,369,385,376,366,379,367, 368,370,371,375,9,34,346,45,32,378,377,351,354,79, 238,218,56,35,36,40,315,37)
AND tagthread.dateline > 1192365977
GROUP BY tagthread.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 55;

MySQL Error : Table './Sql85750_5/thread' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Monday, October 13th 2008 @ 02:46:17 PM
Error Date : Monday, October 13th 2008 @ 02:46:17 PM
Script : http://www.sciax2.it/forum/index.php
Referrer : http://www.sciax2.it/forum/admincp/index.php?do=head
IP Address : 87.17.108.148
Username : Valerio
Classname : vb_database
MySQL Version : 5.0.66a-log

Cosa è? Come risolvo?

(Riesco ad entrare in AdminCP)

**Valerio80** · 13-10-2008, 15:14

Ho risolto riparando le tabelle sql col tool in Admincp.. ma da cosa è stato provocato?

**y2ksw** · 13-10-2008, 20:00

probablimente da un crash del server del database o una interruzione di connessione.

**Roberto1978** · 18-10-2008, 10:16

Ragazzi non so ma non capisco che succede da stamattina ho questo messaggio:

Database error The Forum Associazione Bernacca 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.associazionebernacca.com home page, then try to open another page.
Click the Back button to try another link.

The www.associazionebernacca.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.

il fatto è che comunque la home page funziona .. sto verificando la SQL ma sembra OK... che cosa potrebbe essere???!

**Roberto1978** · 18-10-2008, 10:30

Ragazzi ho scoperto che nel database tutto è ok, ho provato ad accedere da un link preciso ad esempio:

http://www.associazionebernacca.com/...splay.php?f=16

e il forum si apre... allora il problema è l'index.php

però ho notato che se riesco a loggarmi mi funziona tutto il problema quindi è che quando un utente "guest" entra nel link da l'errore...

cosa potrei fare?

**Danny** · 18-10-2008, 11:03

Posta l'errore in chiaro

Click destro, visualizza sorgente o html (se usi IIE)

**Roberto1978** · 18-10-2008, 11:14

intendi questo??

**Roberto1978** · 18-10-2008, 11:15

o forse questo:

Codice:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<title>Forum Associazione Bernacca 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.associazionebernacca.com/forum/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 Forum Associazione Bernacca 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.associazionebernacca.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.associazionebernacca.com forum technical staff have been notified of the error, though you may <a href="mailto:info@weatherlazio.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.3:

Invalid SQL:

		INSERT INTO ab_guestviews
		(guestid, forumid, threadid, dateline, ipaddress)
		VALUES
		('888d96924c0048b31494b117c8b6a85f', 0, 0, 1224321829, '85.18.14.17');

MySQL Error   : Table './associazionebernaccacom195/ab_guestviews' is marked as crashed and should be repaired
Error Number  : 145
Request Date  : Saturday, October 18th 2008 @ 11:23:49 AM
Error Date    : Saturday, October 18th 2008 @ 11:23:49 AM
Script        : http://www.associazionebernacca.com/forum/index.php
Referrer      : http://www.associazionebernacca.com/forum/login.php?do=logout&amp;logouthash=1224321820-ad8170926187ad32002ea237e59400a9dc22e11c
IP Address    : 85.18.14.17
Username      : Non registrato
Classname     : vB_Database
MySQL Version : 
-->


</body>
</html>