Visualizzazione Stampabile
-
Database Error
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)
-
Ho risolto riparando le tabelle sql col tool in Admincp.. ma da cosa è stato provocato?
-
probablimente da un crash del server del database o una interruzione di connessione.
-
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:
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???! :confused::confused::confused::confused:
-
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?
-
Posta l'errore in chiaro ;)
Click destro, visualizza sorgente o html (se usi IIE)
-
-
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"> <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&logouthash=1224321820-ad8170926187ad32002ea237e59400a9dc22e11c
IP Address : 85.18.14.17
Username : Non registrato
Classname : vB_Database
MySQL Version :
-->
</body>
</html>
-
Una curiosità sono andato su GUEST_VIEWS e nella tabella SQL mi dice
in uso!!!
ma è normale??
:confused::confused::confused::confused::confused:
http://img508.imageshack.us/img508/146/84177134pe3.jpg
-
e mi sa che qui il problema vero???
http://img508.imageshack.us/img508/1156/crash1mb1.jpg
:cop: datemi un segno ...
