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-4dfaa-1f9.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 (16073,16076,16077,16079,16961,116797,133641,133509,133508,133459,133456,133421,133420,133415,133414,133413,133412,133326,133322,133284,133008,133007,132994,132993,132992,132991,132834,132768,132765,132764,132657,132653,132403,132402,132401,132400,132399,132395,132358,132223,132222,132167,132161,132149,132144,132133,132131,132121,132119,131991,131990,131980,131974,131972,131970,131616,131592,131591,131587,131585,131584,131572,131492,131474,131472,131404,131403,131401,131390,131388,131378,131373,131372,131329,131314,131242,131241,131240,131239,131238,131237,131236,131235,131233,131232,131230,131229,131228,131209,131207,131202,131167,131059,131054,131053,131051,131030,131029,131016,131014,131012,131011,131010,131008,130834,130771,130643,130642,130636,130635,130511,130509,130470,130463,130370,130368,130367,130366,130364,130327,130326,130323,130321,130316,130313,130293,130290,130270,130262,130261,130242,130225,130224,130187,130155,130147,130144,130142,130139,130067,129890,129887,129790,129763,129762,129747,129741,129740,129738,129728,129726,129725,129724,129716,129715,129714,129713,129698,129689,129684,129679,129656,129622,129615,129570,129563,129499,129498,129493,129492,92269,92656,92657,92798,92800,93273,93277,93317,93321,93380,93388,93400,93561,93698,93893,93985,94413,94427,94428,94436,94437,94641,94645,94938,94979,95101,95120,95210,95493,95513,95754,95908,96094,96103,96104,96105,96169,96539,96543,96653,96770,96771,96899,97025,97082,97085,97090,97181,97204,97480,97581,97626,97635,97703,97980,98101,98123,98138,98142,98151,98172,98303,98304,98363,98440,98464,98465,98506,98507,98585,98887,98976,99003,99137,99154,99189,99354,99566,99569,99651,99654,99876,99927,99940,100184,100612,100766,100767,100827,101011,101268,102098,102101,102125,102126,102135,102136,102137,102139,102356,102576,102577,102615,102619,102645,102866,103213,103299,103391,103406,103852,103871,103877,103911,103966,104052,104139,104168,104174,104178,104179,104180,104202,104331,104339,104340,104512,104606,104607,104706,104851,104852,104967,104968,104977,104984,105035,105047,105054,105078,105095,105097,105098,105099,105100,105101,105135,105136,105137,105138,105420,105442,105560,105568,105639,105646,105652,105658,105966,106015,106099,106101,106422,106423,106512,106527,106555,106616,106621,106645,106655,106665,106666,106667,106668,106670,106691,106731,107120,107124,107125,107145,107165,107173,107244,107245,107337,107371,107372,107611,107731,107753,107780,107789,107791,107832,107847,107848,107914,107978,108031,108057,108683,108771,108826,108840,109383,109491,109493,109540,109543,109550,109615,110076,110087,110088,110089,110093,110094,110426,110539,110649,111031,111379,111382,111387,111419,111424,111425,111426,111680,111701,111858,111899,112070,112106,112332,112334,112405,112553,112633,112671,112672,112673,112674,112675,112677,112678,112794,112798,112801,112802,112803,112808,112893,112898,112899,112913,113052,113056,113061,113062,113116,113219,113220,113356,113357,113362,113364,113365,113366,113537,113539,113542,113543,113933,114002,114006,114014,114091,114122,114305,114323,114459,114460,114477,114478,114479,114480,114558,114567,114568,114569,114570,114571,114572,114573,114691,114712,114771,114772,114773,114774,114783,114854,114866,114867,114886,114931,114932,114933,114935,114936,114939,114943,114955,114959,114960,114968,114970,114971,114972,114973,114980,115026,115028,115029,115032,115119,115145,115146,115149,115183,115185,115510,115511,115544,115545,115546,115553,115907,115909,115910,116400,116944,116960,116962,117034,117035,117036,117038,117048,117050,117074,117075,117078,117079,117080,117083,117097,117163,117342,117343,117463,117850,117851,117854,117869,117872,117873,117875,117877,117937,117940,117964,117965,118035,118036,118037,118040,118041,118050,118056,118061,118063,118064,118065,118094,118108,118115,118121,118122,118126,118127,118201,118205,118221,118222,118223,118226,118231,118232,118233,118234,118413,118416,118417,118420,118421,118422,118429,118448,118473,118476,118477,118478,118508,118509,118511,118549,118553,118610,118639,118679,118730,118731,118740,118746,118747,118748,118775,118803,118804,118807,118808,118816,118846,118905,118914,119115,119172,119255,119259,119262,119267,119269,119281,119319,119320,119324,119427,119435,119438,119439,119441,119451,119452,119453,119459,119462,119467,119474,119475,119496,119498,119499,119500,119501,119502,119510,119536,119537,119541,119543,119640,119804,119805,119806,119808,119855,119901,119904,119979,120009,120012,120019,120021,120022,120025,120026,120040,120044,120056,120068,120070,120075,120104,120148,120156,120321,120322,120372,120377,120383,120384,120387,120388,120389,120393,120395,120396,120407,120409,120543,120550,120625,120626,120677,120678,120679,120686,120687,120688,120689,120690,120691,120692,120712,120713,120791,120792,120838,120982,120983,120995,121002,121013,121014,121015,121020,121100,121102,121128,121129,121131,121188,121216,121275,121280,121315,121377,121379,121383,121384,121385,121386,121387,121388,121390,121433,121434,121683,121693,121791,121794,121814,121815,121992,121993,121995,121996,121997,121998,122008,122009,122010,122011,122012,122026,122039,122054,122061,122067,122070,122082,122112,122113,122114,122115,122130,122131,122133,122134,122136,122137,122138,122145,122146,122147,122148,122149,122150,122151,122157,122159,122160,122161,122163,122194,122195,122204,122232,122237,122238,122239,122240,122241,122242,122243,122245,122246,122247,122249,122250,122252,122255,122256,122258,122261,122355,122376,122417,122424,122486,122487,122495,122530,122531,122532,122533,122534,122535,122538,122539,122540,122541,122626,122642,122668,122775,122776,122779,122780,122781,122782,122783,122784,122785,122798,122817,123056,123058,123064,123089,123090,123179,123180,123217,123218,123219,123238,123288,123289,123290,123302,123304,123328,123331,123333,123335,123341,123344,123347,123348,123349,123350,123351,123353,123356,123359,123360,123363,123366,123367,123368,123391,123394,123396,123397,123409,123410,123417,123418,123419,123420,123422,123423,123437,123461,123463,123504,123507,123508,123512,123666,123676,123781,123782,123784,123798,123799,123800,123875,123933,123935,123961,123962,123972,123974,123975,124008,124033,124059,124135,124210,124242,124255,124258,124272,124273,124400,124430,124431,124432,124433,124434,124435,124436,124437,124438,124439,124455,124473,124474,124475,124476,124477,124478,124479,124480,124481,124482,124483,124484,124485,124486,124487,124488,124489,124490,124491,124492,124493,124494,124495,124496,124497,124498,124499,124500,124501,124504,124682,124686,124705,124706,124709,124710,124711,124714,124715,124718,124719,124720,124724,124725,124726,124727,124730,124733,124734,124735,124736,124739,124741,124742,124763,124764,124765,124767,124768,124803,124853,124856,124859,124866,124870,124889,124891,124898,124937,125204,125205,125216,125218,125559,125563,125568,125571,125574,125575,125671,125672,125680,125681,125682,125683,125684,125695,125696,125698,125702,125703,125704,125928,126031,126085,126089,126090,126109,126113,126114,126328,126329,126330,126331,126335,126336,126337,126338,126475,126480,126545,126546,126547,126548,126549,126550,126551,126552,126553,126556,126649,126654,126661,126695,126697,126840,126979,126980,126984,126987,126988,126989,126991,127033,127072,127073,127221,127227,127317,127400,127403,127440,127442,127443,127444,127445,127446,127447,127449,127450,127494,127497,127542,127555,127579,127581,127584,127587,127588,127613,127614,127625,127626,127627,127628,127630,127645,127723,127726,127736,127737,127738,127739,127740,127744,127771,127903,127905,127906,127907,127914,127929,127948,127996,128010,128022,128031,128032,128033,128035,128039,128041,128042,128043,128047,128048,128049,128050,128079,128093,128107,128125,128189,128196,128213,128215,128216,128217,128218,128219,128309,128324,128366,128376,128378,128379,128388,128392,128413,128414,128416,128420,128421,128481,128482,128484,128487,128504,128505,128506,128517,128518,128521,128610,128614,128628,128629,128645,128646,128650,128652,128654,128655,128656,128658,128659,128660,128663,128705,128706,128709,128718,128729,128730,128731,128732,128737,128793,128807,128817,128818,128865,128866,128867,128868,128869,128877,128881,128901,128990,128991,129032,129040,129049,129060,129065,129071,129072,129085,129086,129093,129095,129096,129102,129103,129109,129142,129169,129176,129184,129186,129187,129196,129197,129211,129302,129303,129305,129314,129320,129332,129334,129384,129385,129425,129454,129457,129463,129464,129469,133767,133871,133883,133914,133983,134000,134063,134073,134246,134247,134248,134250,134251,134252,134253,134254,134256,134261,134268,134271,134273,134274,134275,134277,134278,134280,134281,134285,134291,134292,134293,134294,134295,134296,134297,134298,134305,134318,134322,134327,134328,134329,134330,134331,134334,134335,134336,134338,134340,134342,134343,134344,134345,134346,134347,134348,134349,134350,134351,134358,134453,134457,134970,134971,134972,135018,135045,135274,135277,135278,135279,135280,135292,135293,135294,135297,135298,135301,135303,135307,135308,135310,135316,135318,135319,135320,135381,135395,135403,135511,135516,135518,135802,135976,135983,135984,135985,135989,136075,136090,136183,136184,136492,136508,136511,136528,136530,136532,136534,136536,136537,136582,136592,136771,136832,136835,136938,136962,137298) AND p.approve=1 ORDER BY date DESC LIMIT 260,20