MySQL error in file: /engine/modules/show.short.php at line 65

Error Number: 1021

The Error returned was:
Disk full (/tmp/#sql-temptable-508dd-4e294-18e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SQL query:

SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE p.id IN (116798,116799,133626,133608,133593,133584,133580,133557,133556,133555,133554,133551,133545,133527,133411,133395,133393,133388,133387,133382,133381,133380,133359,133315,133308,133301,133299,133278,133277,133273,133255,133233,133227,133216,133176,133167,133156,133138,133114,133112,133106,133092,133084,133082,133078,133073,133059,133050,133022,133019,133012,133009,133005,133002,133001,132996,132986,132955,132951,132950,132948,132944,132943,132940,132914,132913,132905,132904,132847,132817,132796,132777,132751,132748,132744,132733,132730,132630,132582,132580,132569,132566,132557,132555,132554,132553,132544,132521,132519,132517,132485,132484,132427,132415,132414,132413,132407,132387,132386,132385,132371,132345,132329,132326,132307,132226,132220,132219,132206,132189,132157,132136,132106,132102,132099,132078,132058,132054,132052,132049,132037,132035,131996,131985,131952,131946,131943,131936,131933,131928,131923,131922,131921,131919,131915,131914,131911,131910,131909,131908,131903,131899,131896,131894,131891,131889,131888,131887,131885,131881,131849,131848,131841,131832,131811,131804,131795,131790,131785,131783,131781,131737,131726,131712,131711,131692,131691,131690,131687,131668,131663,131641,131640,131639,131620,131605,131601,131581,131568,131562,131560,131529,131523,131519,131494,131470,131467,131465,131464,131458,131456,131431,131430,131400,131383,131355,131345,131344,131337,131313,131301,131297,131291,131278,131276,131272,131270,131256,131255,131156,131149,131148,131146,131142,131129,131108,131088,131040,131039,131031,130973,130969,130963,130945,130943,130935,130934,130922,130908,130907,130886,130885,130884,130797,130796,130791,130774,130773,130743,130718,130649,130631,130625,130624,130622,130621,130554,130553,130549,130543,130536,130535,130531,130523,130517,130478,130475,130474,130444,130443,130442,130441,130438,130391,130360,130350,130348,130325,130273,130272,130264,130258,130254,130253,130252,130231,130230,130229,130228,130223,130214,130213,130212,130211,130210,130209,130151,130148,130128,130120,130119,130087,130080,130055,130019,130005,129997,129991,129974,129900,129899,129897,129896,129891,129869,129854,129853,129812,129811,129788,129785,129784,129783,129782,129776,129775,129771,129722,129721,129720,129717,129708,129706,129672,129646,129645,129644,129643,129642,129641,129561,129559,129556,129555,129538,129535,129534,129528,129526,129525,129524,129517,129512,129508,92330,92331,92394,92398,92412,92415,92473,92586,92591,92632,92649,92662,92674,92701,92703,92708,92754,92799,92837,92851,92878,92881,93028,93066,93080,93172,93271,93314,93358,93381,93402,93405,93410,93415,93484,93516,93712,93778,93860,93924,93947,93952,93953,93981,93982,93986,93997,94044,94056,94076,94267,94284,94290,94325,94336,94349,94370,94373,94398,94443,94480,94484,94507,94508,94511,94528,94549,94585,94709,94733,94738,94749,94900,94922,94930,94935,94940,94993,95014,95061,95149,95156,95167,95169,95189,95205,95248,95270,95278,95287,95310,95314,95351,95358,95431,95530,95538,95546,95609,95612,95613,95617,95661,95747,95757,95763,95830,95851,95857,95865,95870,95915,96039,96045,96137,96142,96210,96242,96247,96256,96276,96304,96376,96385,96387,96437,96447,96499,96579,96587,96596,96632,96655,96748,96783,96794,96804,96845,96848,96909,96941,96943,97018,97023,97034,97046,97123,97149,97164,97207,97210,97214,97262,97279,97373,97380,97468,97481,97490,97597,97630,97645,97660,97702,97718,97722,97799,97800,97802,97861,97866,97869,97870,97930,97959,97995,98080,98183,98219,98222,98225,98241,98262,98270,98322,98353,98358,98409,98469,98543,98551,98566,98587,98670,98677,98689,98705,98768,98801,98891,98919,98972,98978,99014,99124,99159,99163,99177,99185,99229,99366,99459,99465,99545,99555,99619,99631,99696,99716,99729,99826,99829,99839,99859,100022,100067,100165,100189,100398,100416,100488,100496,100664,100670,100671,100679,100750,100751,100840,100855,100869,100953,100975,100996,101083,101094,101121,101183,101215,101217,101221,101320,101341,101347,101387,101392,101591,101592,101600,101621,101628,101700,101744,101756,101765,101817,101837,101879,101935,102014,102015,102080,102084,102102,102226,102315,102342,102346,102360,102436,102439,102442,102443,102530,102601,102648,102672,102676,102710,102714,102717,102732,102749,102757,102821,102822,102913,102964,103049,103068,103074,103089,103200,103367,103390,103396,103746,103807,103860,104188,104247,104262,104299,104409,104652,104714,104740,104769,104778,104805,104822,104910,104939,105027,105117,105178,105179,105184,105197,105198,105202,105205,105212,105227,105233,105318,105392,105430,105468,105517,105539,105542,105759,105895,105916,105945,106035,106045,106221,106264,106315,106362,106386,106434,106454,106549,106646,106749,106762,106798,106820,106867,106879,106994,107036,107041,107058,107074,107182,107187,107219,107261,107312,107389,107398,107404,107438,107444,107510,107589,107648,107649,107709,107735,107773,107798,107861,107863,107866,107872,107891,107959,107969,108017,108036,108067,108092,108105,108286,108305,108326,108346,108353,108398,108402,108479,108538,108616,108633,108637,108653,108658,108667,108719,108746,108749,108751,108786,108794,108844,108885,108898,109026,109093,109136,109142,109145,109253,109257,109403,109414,109560,109599,109601,109641,109642,109688,109738,109745,109762,109902,109938,109977,109978,110032,110047,110062,110080,110144,110154,110155,110190,110192,110196,110281,110331,110373,110378,110478,110491,110499,110540,110551,110587,110616,110679,110759,110795,110800,110806,110874,110886,110895,110915,110954,110972,111006,111050,111122,111132,111137,111149,111171,111204,111228,111255,111315,111317,111353,111361,111363,111375,111429,111479,111550,111579,111586,111589,111621,111644,111729,111776,111824,111839,111878,111981,112017,112046,112117,112120,112304,112407,112431,112476,112494,112519,112520,112535,112589,112598,112610,112700,112703,112722,112740,112758,112825,112877,112991,113018,113038,113053,113064,113069,113070,113074,113075,113077,113082,113084,113085,113090,113100,113102,113121,113122,113123,113127,113137,113146,113155,113160,113163,113223,113224,113226,113227,113228,113229,113230,113231,113233,113237,113240,113247,113249,113253,113257,113258,113259,113260,113261,113264,113265,113266,113267,113268,113269,113270,113285,113316,113317,113320,113328,113342,113368,113401,113402,113403,113404,113418,113456,113477,113496,113529,113575,113589,113600,113603,113612,113622,113631,113639,113644,113646,113654,113655,113656,113658,113662,113665,113670,113673,113674,113676,113678,113681,113684,113709,113716,113726,113729,113744,113748,113758,113769,113771,113779,113783,113800,113803,113804,113805,113807,113812,113815,113820,113827,113833,113835,113837,113838,113839,113843,113884,113885,113887,113892,113926,113938,113939,113946,113949,113968,113996,114019,114029,114035,114049,114051,114053,114065,114090,114133,114187,114195,114214,114216,114217,114221,114222,114255,114266,114272,114289,114297,114334,114349,114360,114365,114400,114405,114416,114436,114437,114441,114463,114465,114471,114473,114475,114492,114503,114576,114619,114645,114663,114729,114735,114738,114743,114779,114793,114846,114848,114855,114885,114944,114965,114975,114976,114989,115020,115070,115086,115087,115106,115123,115215,115216,115227,115244,115250,115268,115270,115272,115284,115290,115294,115295,115307,115310,115490,115493,115494,115498,115499,115500,115501,115539,115624,115634,115635,115636,115638,115641,115651,115665,115666,115670,115671,115674,115680,115682,115683,115687,115691,115737,115760,115761,115762,115783,115787,115788,115796,115800,115801,115802,115803,115805,115806,115807,115819,115846,115848,115851,115852,115853,115857,115862,115867,115876,115880,115881,115883,115884,115888,115889,115897,115900,115902,115904,115948,116016,116028,116078,116093,116122,116123,116129,116130,116131,116132,116136,116137,116138,116139,116140,116141,116144,116195,116199,116200,116240,116282,116287,116349,116363,116370,116383,116384,116385,116389,116418,116433,116434,116436,116437,116449,116489,116492,116493,116506,116508,116512,116554,116555,116564,116566,116567,116568,116570,116580,116581,116603,116613,116614,116623,116625,116626,116641,116647,116650,116652,116653,116659,116681,116694,116695,116717,116718,116720,116724,116743,116753,116756,116782,116788,116800,116806,116857,116882,116883,116922,116923,116924,116939,116941,116997,117045,117077,117125,117147,117174,117176,117253,117254,117255,117273,117284,117288,117301,117302,117304,117306,117309,117345,117366,117406,117411,117438,117443,117445,117446,117455,117468,117532,117548,117556,117602,117688,117691,117728,117732,117754,117773,117874,117915,117927,117929,117931,117944,117972,117988,117992,118016,118032,118107,118113,118131,118173,118174,118185,118248,118255,118263,118273,118275,118293,118294,118295,118296,118336,118339,118340,118458,118462,118560,118561,118562,118596,118620,118623,118625,118628,118631,118634,118644,118648,118695,118720,118818,118824,118830,118831,118838,118839,118840,118841,118842,118843,118847,118895,118897,118919,118961,118972,118978,118986,118988,118989,119008,119026,119030,119031,119046,119049,119056,119140,119146,119149,119151,119184,119207,119208,119219,119253,119254,119270,119283,119292,119317,119355,119357,119367,119373,119381,119386,119397,119430,119431,119434,119472,119493,119516,119517,119566,119567,119569,119571,119578,119582,119584,119603,119666,119669,119670,119682,119689,119691,119706,119707,119723,119724,119726,119729,119733,119734,119736,119738,119740,119742,119743,119748,119776,119779,119789,119792,119798,119841,119858,119873,119882,119890,119891,119898,119900,119937,119943,119944,119951,119955,119965,119967,119973,119978,119984,119995,120008,120018,120030,120033,120034,120035,120047,120094,120122,120125,120137,120141,120142,120143,120155,120172,120192,120203,120217,120219,120221,120234,120244,120249,120250,120267,120294,120295,120297,120300,120422,120490,120495,120498,120499,120500,120505,120506,120507,120516,120522,120538,120541,120615,120617,120618,120621,120629,120638,120669,120682,120684,120696,120697,120700,120705,120706,120717,120718,120724,120725,120727,120728,120733,120757,120775,120807,120811,120814,120817,120819,120845,120847,120856,120867,120879,120886,120888,120899,120916,120931,120961,120966,120979,121004,121005,121018,121063,121084,121092,121103,121104,121153,121154,121155,121162,121164,121170,121173,121185,121204,121228,121229,121260,121261,121269,121271,121272,121273,121295,121296,121297,121298,121299,121333,121347,121355,121356,121357,121358,121360,121363,121371,121392,121394,121467,121468,121469,121470,121471,121472,121473,121474,121475,121476,121477,121478,121496,121497,121504,121505,121506,121523,121524,121556,121557,121559,121561,121645,121648,121650,121651,121652,121653,121654,121655,121656,121657,121659,121660,121661,121662,121663,121664,121665,121666,121668,121676,121677,121678,121680,121685,121687,121688,121689,121690,121691,121717,121720,121756,121768,121772,121774,121775,121778,121779,121781,121818,121819,121822,121836,121847,121853,121854,121915,121935,121937,121939,121942,121945,121973,122003,122004,122013,122014,122016,122020,122035,122037,122038,122049,122051,122072,122092,122120,122139,122144,122164,122173,122186,122225,122230,122271,122281,122313,122316,122354,122387,122431,122443,122507,122515,122528,122570,122571,122588,122591,122596,122598,122600,122614,122638,122652,122655,122659,122660,122666,122696,122707,122708,122710,122711,122712,122718,122725,122733,122742,122744,122745,122760,122765,122805,122808,122834,122836,122837,122838,122839,122840,122846,122848,122849,122868,122869,122887,122888,122889,122890,122893,122909,122910,122912,122913,122927,122928,122930,122935,122940,122941,122953,122983,122998,123014,123015,123016,123020,123021,123022,123023,123024,123025,123026,123028,123030,123031,123032,123033,123035,123041,123045,123047,123048,123066,123069,123070,123072,123076,123080,123087,123097,123104,123107,123128,123129,123131,123148,123149,123150,123151,123152,123153,123154,123155,123156,123157,123158,123159,123169,123178,123188,123207,123208,123209,123210,123211,123213,123222,123226,123234,123244,123253,123254,123260,123265,123283,123291,123296,123308,123322,123438,123439,123442,123445,123450,123466,123467,123468,123469,123470,123472,123479,123480,123481,123482,123483,123484,123506,123549,123550,123551,123552,123553,123554,123555,123558,123559,123560,123561,123563,123564,123567,123575,123580,123581,123582,123583,123584,123585,123586,123587,123589,123590,123591,123596,123600,123602,123603,123604,123607,123614,123619,123621,123626,123629,123630,123631,123632,123633,123634,123636,123638,123640,123641,123644,123662,123665,123671,123673,123685,123686,123687,123702,123714,123719,123737,123769,123770,123771,123793,123795,123814,123826,123835,123843,123849,123850,123851,123852,123854,123856,123881,123887,123888,123889,123890,123891,123892,123894,123895,123911,123913,123914,123920,123937,123944,123952,123956,123957,123990,123991,123997,123998,123999,124000,124001,124002,124003,124004,124005,124006,124007,124009,124011,124012,124013,124021,124022,124023,124026,124029,124030,124042,124123,124124,124125,124126,124127,124128,124129,124130,124131,124171,124172,124181,124228,124249,124252,124257,124275,124282,124293,124308,124311,124312,124313,124314,124315,124316,124317,124318,124319,124320,124335,124345,124347,124350,124351,124353,124358,124364,124365,124368,124370,124420,124514,124534,124544,124549,124555,124557,124647,124649,124656,124672,124673,124674,124675,124677,124678,124679,124690,124694,124695,124738,124748,124753,124761,124769,124772,124788,124811,124825,124831,124858,124868,124884,124906,124907,124914,124928,124929,124951,124976,124978,124979,124981,124984,124985,124986,124987,124988,124991,124993,125009,125018,125032,125045,125053,125054,125058,125060,125063,125079,125080,125088,125091,125094,125095,125096,125097,125098,125099,125107,125108,125109,125110,125111,125121,125126,125127,125128,125157,125167,125168,125169,125198,125223,125254,125270,125292,125298,125302,125307,125309,125311,125312,125338,125351,125367,125368,125371,125380,125383,125464,125465,125466,125467,125468,125476,125484,125490,125496,125502,125503,125505,125521,125522,125531,125532,125533,125534,125535,125546,125562,125582,125588,125658,125663,125675,125711,125724,125725,125729,125733,125745,125751,125753,125754,125755,125756,125781,125783,125784,125785,125800,125821,125824,125829,125830,125831,125835,125836,125837,125838,125839,125840,125841,125848,125854,125856,125857,125858,125859,125860,125874,125875,125884,125885,125888,125891,125895,125896,125902,125904,125905,125909,125913,125914,126302,126303,126304,126415,126437,126438,126439,126446,126454,126479,126482,126520,126563,126621,126644,126652,126658,126693,126759,126764,126766,126767,126769,126771,126772,126773,126774,126777,126791,126807,126813,126817,126822,126837,126879,126924,126929,126930,126935,126939,126952,126999,127001,127015,127029,127030,127031,127032,127054,127078,127080,127081,127082,127083,127086,127107,127113,127118,127133,127181,127217,127225,127263,127268,127319,127320,127321,127322,127323,127324,127387,127390,127452,127453,127454,127456,127460,127465,127466,127468,127471,127472,127473,127483,127484,127498,127540,127541,127545,127547,127552,127566,127586,129295,129299,129306,129308,129313,129318,129319,129326,129327,129336,129363,129392,129421,129422,129438,129451,133770,133783,133841,133846,133887,133889,133890,133892,133906,133908,133973,134013,134028,134070,134071,134074,134081,134152,134192,134194,134282,134375,134378,134527,134543,134545,134546,134596,134598,134625,134650,134657,134679,134682,134745,134752,134807,134851,134914,134916,134987,135032,135035,135037,135064,135065,135066,135093,135109,135110,135112,135175,135176,135177,135196,135198,135203,135255,135324,135341,135348,135349,135350,135358,135364,136250,136251,136252,136260,136262,136268,136269,136270,136271,136272,136273,136278,136279,136280,136303,136327,136328,136329,136346,136347,136351,136358,136359,136362,136363,136378,136456,136457,136459,136464,136472,136483,136496,136497,136500,136517,136520,136545,136579,136610) AND p.approve=1 ORDER BY date DESC LIMIT 1180,20