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-4deb2-10d.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 (14926,14967,16149,16154,16268,16274,16657,16674,16675,16696,16716,16720,16739,16822,16838,16916,16930,16993,16995,16998,17172,17228,17241,17252,17331,17414,17441,17562,17635,17771,17793,20289,20526,20603,20647,20839,20922,21009,21053,21061,21172,21246,21339,21382,21531,21542,21590,21636,21659,21876,22014,22056,22062,22089,22148,22175,22253,22288,22314,22377,22648,22671,22672,22808,133688,133670,133651,133425,133136,133134,133019,132926,132924,132860,132849,132727,132683,132675,132672,132670,132632,132615,132139,131954,131953,131907,131840,131804,131775,131305,131285,131206,131064,131047,131022,130920,130919,130328,130174,129996,129995,129911,129708,129542,129496,92254,92255,92445,92446,92457,92458,92459,92493,92494,92499,92501,92588,92653,92720,92721,92723,92732,92735,92761,92763,92806,92808,92809,92810,92894,92896,92899,93035,93053,93078,93095,93166,93242,93370,93432,93438,93599,93600,93602,93606,93641,93725,93726,93727,93728,93734,93758,93833,93842,94015,94114,94119,94162,94166,94170,94178,94222,94223,94224,94225,94226,94227,94360,94362,94381,94384,94385,94387,94394,94397,94494,94658,94673,94674,94675,94677,94678,94694,94699,94701,94728,94778,94846,94886,94887,94918,94946,95012,95086,95343,95349,95356,95364,95365,95405,95407,95408,95409,95410,95412,95476,95481,95522,95526,95584,95605,95663,95669,95688,95693,95707,95753,95783,95786,95788,95859,95929,95934,95940,95965,95966,95968,96081,96089,96090,96091,96141,96161,96191,96255,96296,96316,96375,96394,96395,96517,96559,96560,96561,96562,96565,96567,96694,96713,96733,96816,96973,96977,97192,97301,97309,97316,97340,97349,97355,97357,97881,98028,98059,98061,98101,98104,98105,98108,98129,98133,98146,98161,98206,98234,98291,98347,98361,98386,98425,98488,98490,98492,98493,98498,98499,98501,98549,98589,98590,98632,98695,98696,98726,98792,98852,99016,99018,99141,99168,99205,99208,99227,99251,99253,99321,99359,99360,99398,99403,99513,99519,99658,99659,99670,99855,99857,99858,99885,99910,99915,99927,99936,99986,100051,100116,100229,100296,100301,100332,100333,100335,100336,100354,100466,100580,100598,100625,100696,100800,100866,100868,100894,100899,100941,100944,100989,101111,101157,101232,101256,101301,101315,101355,101384,101437,101439,101450,101451,101460,101605,101606,101608,101966,101969,102034,102056,102391,102592,102698,102792,102796,102799,102922,102929,102931,102942,102976,102977,103093,103110,103192,103193,103194,103195,103216,103218,103300,103530,103531,103538,103540,103575,103630,103637,103637,103639,103640,103641,103683,103716,103799,103800,103905,103914,103917,104014,104041,104041,104057,104093,104094,104095,104096,104111,104199,104354,104358,104446,104459,104460,104461,104464,104513,104532,104584,104585,104587,104608,104612,104614,104616,104617,104645,104648,104669,104684,104731,104746,104748,104795,104810,104875,104876,104915,104974,104979,104981,104982,105038,105119,105169,105170,105171,105172,105174,105192,105242,105243,105245,105246,105248,105249,105253,105254,105364,105365,105453,105474,105491,105553,105554,105555,105730,105732,105736,105742,105888,106118,106123,106212,106256,106257,106258,106271,106276,106477,106478,106483,106485,106502,106517,106523,106761,106770,106788,106869,106871,107139,107140,107293,107295,107557,107566,107576,107618,107624,107690,107693,107918,107946,108051,108103,108106,108186,108194,108222,108274,108277,108296,108337,108365,108383,108384,108419,108513,108514,108546,108548,108552,108678,108680,108685,108933,108966,108982,109039,109043,109044,109052,109121,109124,109219,109220,109273,109278,109290,109293,109308,109309,109313,109319,109333,109335,109336,109337,109338,109339,109340,109341,109342,109343,109344,109345,109346,109349,109358,109359,109369,109370,109373,109375,109402,109492,109533,109734,109747,109911,109912,109931,109970,109986,110007,110008,110111,110157,110226,110230,110252,110722,110723,110732,110897,110900,110907,110964,111116,111180,111182,111299,111300,111301,111302,111303,111304,111309,111439,111470,111608,111763,111767,111945,111946,111997,111998,112086,112113,112158,112180,112185,112216,112217,112244,112246,112355,112883,112885,112886,112887,113040,113042,113105,113108,113418,113420,113472,113473,113588,113596,113658,113681,113968,114071,114082,114139,114140,114141,114142,114143,114144,114145,114146,114147,114148,114149,114151,114152,114155,114156,114157,114158,114172,114176,114177,114178,114179,114204,114227,114379,114380,114447,114790,114790,114793,114811,114811,114812,114812,114813,114813,114819,114821,114823,114828,114923,114924,114926,114929,114930,114931,114932,114933,114935,114936,114939,114943,114954,114955,114959,114960,115315,115498,115811,115829,115831,115836,115837,115848,115879,115984,115985,116214,116844,116866,116867,117099,117110,117505,117506,117507,117510,117511,117512,117513,117514,117540,117793,117798,117878,117890,117891,117895,117896,117897,117899,117900,118059,118066,118123,118339,118420,118469,118478,118499,118673,118676,118781,118852,118854,118855,118856,118857,118859,119216,119216,119221,119222,119223,119224,119225,119227,119239,119241,119243,119244,119245,119307,119311,119364,119370,119466,119689,119699,119800,120141,120143,120417,120420,120421,120422,120502,120503,120521,120544,120545,120546,120663,120665,120713,120869,120871,120894,120896,120922,120927,120937,120939,120942,121084,121142,121335,121371,121395,121467,121468,121469,121472,121473,121474,121548,121551,121566,121672,121673,121691,121732,121733,121734,121735,121819,121847,121902,122020,122034,122118,122124,122139,122144,122157,122253,122254,122257,122361,122366,122431,122562,122569,122685,122691,122692,122703,122705,122706,122707,122709,122712,122719,122729,122737,122745,122790,122791,122799,122800,122830,122869,122871,122939,123159,123187,123250,123256,123257,123264,123265,123269,123280,123714,123718,123720,123721,123722,123723,123723,123724,123753,123756,123756,123819,123820,123874,123883,123898,123909,123990,124053,124072,124201,124225,124226,124254,124489,124680,124695,124791,124795,124820,124850,124864,124933,125082,125090,125120,125184,125185,125203,125500,125547,125549,125587,125712,125720,125912,125914,126032,126039,126040,126059,126060,126064,126066,126128,126131,126299,126300,126301,126305,126309,126310,126312,126313,126351,126383,126384,126386,126391,126433,126436,126465,126674,126769,126771,126774,126777,126848,126858,126866,126868,127118,127127,127434,127600,127601,127625,127627,127628,127705,127726,127764,128065,128091,128092,128129,128130,128257,128500,128626,128627,128734,128926,128994,129043,129054,129067,129180,129323,129324,134609,134665,134915,135407,135410,135461,135595,135605,135634,135663,135682,135683,135686,135795,135818,136035,136052,136149,136150,136307,136522,136524,136624,136625,136628,136629,136829,136865,136866,136867,136868,136869,136876,136907,137063,137064,137067,137069,137071,137094,137178,137386) AND p.approve=1 ORDER BY date DESC LIMIT 220,20