Database error in vBulletin 4.1.5

**djtimon89** · 25.10.2011, 16:31

Witam jestem moderatorem globalnym na moim forum jak by to miało jakoś pomóc w mojej sprawie.

Jak kliknę na "Nowe posty" na moim forum mam taki komunikat:

Kod:

Database error in vBulletin 4.1.5:

Invalid SQL:

				SELECT thread.threadid
				FROM thread AS thread
				
				LEFT JOIN threadread AS threadread ON
					(threadread.threadid = thread.threadid AND threadread.userid = 36748)
				INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
				LEFT JOIN forumread AS forumread ON
					(forumread.forumid = forum.forumid AND forumread.userid = 36748)
			
				WHERE thread.forumid IN(3, 13, 14, 84, 63, 4, 33, 12, 31, 149, 29, 30, 34, 389, 35, 40, 370, 371, 372, 373, 374, 375, 382, 376, 377, 378, 381, 383, 384, 386, 385, 387, 388, 352, 353, 354, 50, 51, 86, 87, 88, 89, 52, 103, 104, 105, 107, 53, 90, 91, 92, 93, 83, 99, 100, 101, 102, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 207, 208, 209, 210, 211, 221, 222, 223, 224, 225, 241, 242, 243, 244, 245, 74, 94, 96, 97, 98, 318, 319, 320, 321, 322, 362, 363, 364, 365, 366, 399, 400, 401, 402, 403, 248, 291, 263, 292, 310, 65, 197, 198, 199, 200, 201, 80, 108, 109, 110, 111, 313, 314, 315, 316, 317, 357, 358, 359, 360, 361, 390, 391, 392, 393, 394, 252, 311, 253, 412, 61, 212, 294, 295, 296, 297, 75, 112, 114, 115, 116, 76, 117, 118, 120, 121, 264, 265, 266, 267, 268, 249, 250, 261, 262, 251, 55, 59, 122, 123, 124, 125, 79, 130, 131, 132, 133, 81, 134, 135, 136, 137, 190, 191, 192, 193, 194, 165, 166, 167, 168, 169, 300, 301, 302, 303, 304, 323, 324, 325, 326, 327, 407, 408, 409, 410, 411, 78, 128, 129, 126, 413, 289, 298, 60, 77, 138, 139, 140, 141, 160, 161, 162, 163, 164, 254, 255, 256, 257, 258, 305, 306, 307, 308, 309, 286, 293, 369, 179, 274, 275, 276, 277, 278, 240, 180, 181, 183, 185, 205, 234, 235, 331, 332, 333, 334, 335, 336, 337, 170, 171, 172, 173, 177, 178, 329, 330, 338, 339, 348, 397, 398, 341, 349, 367, 346, 340, 351, 343, 405, 406, 355, 356, 404, 342, 350, 345, 414, 347, 5, 215, 218, 219, 220, 10, 42, 43, 285, 7, 279, 280, 281, 282, 283, 15, 142, 143, 203, 144, 145, 146, 147, 148, 17, 18, 19, 20, 21, 22, 23, 24, 236, 237, 238, 239, 8, 25, 26, 395, 27, 270, 272, 271, 273, 204, 32, 28, 67, 202, 73, 72, 9, 186, 187, 229)
					
				AND thread.lastpost > IF(threadread.readtime IS NULL, 1318676373, threadread.readtime)
				AND thread.lastpost > IF(forumread.readtime IS NULL, 1318676373, forumread.readtime)
				AND thread.lastpost > 1318676373
			
					AND thread.open <> 10
				ORDER BY thread.lastpost desc
				LIMIT 500;

MySQL Error   : Got error 134 from storage engine
Error Number  : 1030
Request Date  : Tuesday, October 25th 2011 @ 12:59:33 PM
Error Date    : Tuesday, October 25th 2011 @ 12:59:33 PM
Script        : http://forum.xxx.xxx.pl/search.php?do=getnew&exclude=&contenttype=vBForum_Post
Referrer      : http://forum.xxx.xxx.pl/f9/
IP Address    : xxx.xxx.xxx.xxx
Username      : djtimon89
Classname     : vB_Database
MySQL Version : 5.1.58

Ten sam komunikat (podobny) mam w jednym z działów:

Kod:

Database error in vBulletin 4.1.5:

Invalid SQL:

		SELECT 
			IF(votenum >= 1, votenum, 0) AS votenum,
			IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
		 post.pagetext AS preview,
			thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
			thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
			thread.prefixid, thread.taglist, hiddencount, deletedcount,
			user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
			user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
			, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
			, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
			, threadread.readtime AS threadread
			, threadredirect.expires
			
		FROM thread AS thread
			LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
			LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 36748)
			LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
			 LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 36748 AND canview = 1)
			 LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 36748)
			LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
			
			LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			
		WHERE thread.threadid IN (0,104742,104678,104052,104032,102960,102848,60737,99143,99858,99399,99312,97313,98661,95241,94987,97697,97029,78916,96392,96527) 
		ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Got error 134 from storage engine
Error Number  : 1030
Request Date  : Tuesday, October 25th 2011 @ 12:59:25 PM
Error Date    : Tuesday, October 25th 2011 @ 12:59:25 PM
Script        : http://forum.xxx.xxx.pl/forumdisplay.php?f=307
Referrer      : http://forum.xxx.xxx.pl/
IP Address    : xxx.xxx.xxx.xxx
Username      : djtimon89
Classname     : vB_Database
MySQL Version : 5.1.58

**vBio1** · 25.10.2011, 16:44

Spróbuj wyłączyć na forum wszystkie wtyczki być może jest to wina którejś z nich, później włączaj kolejno wtyczki i sprawdzaj czy nie występuje nadal database error.

**djtimon89** · 25.10.2011, 16:55

a gdzie na forum są wtyczki? bo za bardzo nie kojarzę i się tym nie przejmowałem :P

**vBio1** · 25.10.2011, 17:02

Wszystkie wtyczki, które są zainstalowane na Twoim forum znajdziesz we "wtyczki i modyfikacje" w panelu kontrolnym administratora. Zablokuj wszystkie wtyczki i zorientuj się, która może wywoływać ten błąd.

**djtimon89** · 25.10.2011, 17:15

aj no tak

dobra narazie działa któryś admin pewnie już naprawił mi więc chyba temat rozwiązany

**vBio1** · 25.10.2011, 17:16

Ciekawi mnie jedna wiadomość w treści błędu na Twoim forum, mianowicie:

AND thread.lastpost > IF(threadread.readtime IS NULL, 1318676373, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1318676373, forumread.readtime)

Posiadasz oryginalną wersję skryptu?

**WoG** · 25.10.2011, 19:19

Zamieszczone przez vBio1

Ciekawi mnie jedna wiadomość w treści błędu na Twoim forum, mianowicie:

Kod:

AND thread.lastpost > IF(threadread.readtime IS NULL, 1318676373, threadread.readtime)
 AND thread.lastpost > IF(forumread.readtime IS NULL, 1318676373, forumread.readtime)

Posiadasz oryginalną wersję skryptu?

To jest prawidłowy fragment zapytania.
Sprawdza czy użytkownik ma nieprzeczytane tematy lub fora. Jeżeli wartości nie ma (IS NULL) to porównuje z datą ostatniego posta, a jeżeli jest (IS NOT NULL) to wstawia właśnie tą datę.
To taka ciekawostka.

**patrixon78** · 26.10.2011, 00:44

To taki język nazywa się Angielski

Narzędzia wątku

Typ wyświetlania

Database error in vBulletin 4.1.5