Yuvraj
11-09-2013, 09:19 PM
hello there, my forum was working fine and suddenly I got this
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT data.tagid, data.tagtext, SUM(data.searchcount) AS searchcount
FROM
(
SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent
INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid) INNER JOIN thread AS thread ON (tagcontent.contentid = thread.threadid)
WHERE tagcontent.contenttypeid IN (2) AND
tagcontent.dateline > 1352498348 AND thread.open <> 10 AND thread.visible = 1 AND thread.forumid IN (1,2,4,5,6,7,8,9,10,11,18,19,20,21,22,12,13,14,273 ,15,16,256,274,17,23,25,26,27,28,275,29,30,31,32,3 3,34,35,36,37,38,40,41,42,43,44,39,24,45,46,47,48, 49,50,51,159,52,53,57,58,59,60,417,61,62,63,64,66, 67,68,69,54,55,448,56,259,261,260,262,263,264,265, 266,267,70,71,72,94,95,96,97,98,99,100,101,73,102, 103,104,105,459,107,108,109,110,111,112,113,457,11 5,458,254,116,106,114,74,118,121,122,123,125,126,1 27,128,129,130,452,460,462,446,467,131,117,119,120 ,124,75,138,132,133,134,135,136,137,139,140,141,14 2,143,144,145,463,447,146,76,445,461,148,149,150,1 51,152,153,154,155,156,157,272,158,147,77,160,161, 162,163,164,165,166,167,450,468,168,78,170,171,172 ,173,174,175,176,177,178,179,180,181,182,449,183,1 69,79,184,416,185,186,187,188,464,189,190,191,192, 193,194,195,196,271,255,80,197,198,199,200,201,202 ,203,204,205,206,207,81,451,208,209,210,211,213,21 4,215,469,466,216,212,82,217,218,219,220,415,413,4 70,221,83,222,223,224,225,226,227,228,229,230,84,2 31,232,233,234,235,236,414,237,85,238,239,240,241, 242,243,244,245,246,247,248,249,444,594,476,580,58 1,583,584,586,587,589,483,485,486,487,488,489,490, 491,492,493,494,478,495,496,497,498,499,500,501,50 2,503,504,505,506,507,484,509,510,511,512,513,514, 515,516,517,518,520,521,523,524,525,526,527,529,53 0,532,533,534,535,537,539,541,543,544,545,547,549, 550,551,554,482,508,522,528,531,536,538,540,542,48 1,546,553,557,548,552,555,560,480,556,558,559,561, 562,563,564,565,566,567,568,569,570,479,572,573,57 4,575,577,578,579,582,585,588,590,591,592,477,576, 250,251,252,253,281,282,300,301,302,303,304,305,30 6,307,308,309,310,311,312,313,314,315,316,317,318, 319,320,321,322,323,324,325,326,327,328,329,283,33 0,331,332,333,334,335,336,337,338,339,340,341,342, 343,344,345,346,347,348,284,349,350,351,352,353,35 4,355,356,357,358,359,360,361,362,363,364,365,366, 367,368,369,370,371,372,285,373,374,375,376,286,37 7,378,379,380,381,382,383,384,385,386,387,388,389, 390,391,287,392,393,394,395,396,397,398,399,400,40 1,402,403,288,289,404,405,406,407,408,409,410,411, 290,412,291,292,293,294,295,296,297,298,299,472,47 3,471,86,87,88,89,474,475)
GROUP BY tagcontent.tagid, tag.tagtext
) AS data
GROUP BY data.tagid, data.tagtext
ORDER BY searchcount DESC
LIMIT 30;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Saturday, November 9th 2013 @ 09:59:08 PM
Error Date : Saturday, November 9th 2013 @ 09:59:55 PM
Script : http://www.xxxxxxxxxxxx.net/
Referrer :
IP Address : 60.242.209.34
Username : Boss
Classname : vB_Database
MySQL Version :
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT data.tagid, data.tagtext, SUM(data.searchcount) AS searchcount
FROM
(
SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent
INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid) INNER JOIN thread AS thread ON (tagcontent.contentid = thread.threadid)
WHERE tagcontent.contenttypeid IN (2) AND
tagcontent.dateline > 1352498348 AND thread.open <> 10 AND thread.visible = 1 AND thread.forumid IN (1,2,4,5,6,7,8,9,10,11,18,19,20,21,22,12,13,14,273 ,15,16,256,274,17,23,25,26,27,28,275,29,30,31,32,3 3,34,35,36,37,38,40,41,42,43,44,39,24,45,46,47,48, 49,50,51,159,52,53,57,58,59,60,417,61,62,63,64,66, 67,68,69,54,55,448,56,259,261,260,262,263,264,265, 266,267,70,71,72,94,95,96,97,98,99,100,101,73,102, 103,104,105,459,107,108,109,110,111,112,113,457,11 5,458,254,116,106,114,74,118,121,122,123,125,126,1 27,128,129,130,452,460,462,446,467,131,117,119,120 ,124,75,138,132,133,134,135,136,137,139,140,141,14 2,143,144,145,463,447,146,76,445,461,148,149,150,1 51,152,153,154,155,156,157,272,158,147,77,160,161, 162,163,164,165,166,167,450,468,168,78,170,171,172 ,173,174,175,176,177,178,179,180,181,182,449,183,1 69,79,184,416,185,186,187,188,464,189,190,191,192, 193,194,195,196,271,255,80,197,198,199,200,201,202 ,203,204,205,206,207,81,451,208,209,210,211,213,21 4,215,469,466,216,212,82,217,218,219,220,415,413,4 70,221,83,222,223,224,225,226,227,228,229,230,84,2 31,232,233,234,235,236,414,237,85,238,239,240,241, 242,243,244,245,246,247,248,249,444,594,476,580,58 1,583,584,586,587,589,483,485,486,487,488,489,490, 491,492,493,494,478,495,496,497,498,499,500,501,50 2,503,504,505,506,507,484,509,510,511,512,513,514, 515,516,517,518,520,521,523,524,525,526,527,529,53 0,532,533,534,535,537,539,541,543,544,545,547,549, 550,551,554,482,508,522,528,531,536,538,540,542,48 1,546,553,557,548,552,555,560,480,556,558,559,561, 562,563,564,565,566,567,568,569,570,479,572,573,57 4,575,577,578,579,582,585,588,590,591,592,477,576, 250,251,252,253,281,282,300,301,302,303,304,305,30 6,307,308,309,310,311,312,313,314,315,316,317,318, 319,320,321,322,323,324,325,326,327,328,329,283,33 0,331,332,333,334,335,336,337,338,339,340,341,342, 343,344,345,346,347,348,284,349,350,351,352,353,35 4,355,356,357,358,359,360,361,362,363,364,365,366, 367,368,369,370,371,372,285,373,374,375,376,286,37 7,378,379,380,381,382,383,384,385,386,387,388,389, 390,391,287,392,393,394,395,396,397,398,399,400,40 1,402,403,288,289,404,405,406,407,408,409,410,411, 290,412,291,292,293,294,295,296,297,298,299,472,47 3,471,86,87,88,89,474,475)
GROUP BY tagcontent.tagid, tag.tagtext
) AS data
GROUP BY data.tagid, data.tagtext
ORDER BY searchcount DESC
LIMIT 30;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Saturday, November 9th 2013 @ 09:59:08 PM
Error Date : Saturday, November 9th 2013 @ 09:59:55 PM
Script : http://www.xxxxxxxxxxxx.net/
Referrer :
IP Address : 60.242.209.34
Username : Boss
Classname : vB_Database
MySQL Version :