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

Error Number: 1021

The Error returned was:
Disk full (/tmp/#sql-temptable-3b3-aa4be-17181.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 (8,9,10,11,13,14,15,16,17,18,19,20,21,22,23,24,25,28,29,30,31,32,34,35,36,37,38,39,40,41,42,45,46,48,419,488,1001,1093,1100,1112,1115,1117,1118,1119,1121,1136,1146,1149,1152,1159,1169,1174,1175,1176,1177,1178,1179,1180,1181,1183,1185,1186,1187,1189,1192,1193,1196,1204,1206,1208,1211,1213,1215,1217,1220,1222,1224,1227,1228,1231,1236,1238,1241,1243,1245,1249,1251,1254,1255,1256,1259,1262,1264,1267,1276,1279,1282,1285,1288,1289,1291,1298,1301,1302,1306,1309,1325,1329,1339,1350,1352,1357,1366,1371,1381,1385,1391,1392,1395,1399,1403,1405,1406,1408,1409,1412,1413,1415,1416,1418,1419,1421,1422,1425,1426,1428,1429,1431,1437,1438,1440,1466,1468,1470,1473,1475,1482,1507,1508,1512,1522,1524,1532,1534,1541,1545,1547,1555,1565,1567,1568,1570,1573,1577,1590,1611,1616,1629,1635,1636,1641,1645,1657,1778,1796,1806,1814,1815,1818,1820,1822,1824,1877,1879,1901,1906,1910,1912,1914,1916,1917,1926,1935,1944,1945,1951,1955,1957,1959,1975,2207,2231,2239,2373,2376,2504,2505,2509,2512,2519,2522,2524,2633,2801,2819,2822,2825,2828,2829,2851,2873,2894,2921,3016,3020,3032,3032,3074,3402,3404,3410,3423,3433,3439,3440,3441,3448,3458,3461,3472,3478,3494,3498,3503,3509,3522,3551,3555,3592,3619,3624,3627,3641,3642,3643,3664,3678,3696,3707,3712,3731,3731,3785,3794,3812,3814,3868,3871,3908,3921,3924,4014,4064,4094,4101,4105,4117,4120,4128,4152,4192,4220,4221,4226,4240,4242,4257,4258,4259,4261,4285,4291,4305,4308,4332,4333,4340,4363,4366,4398,4401,4402,4403,4404,4407,4413,4427,4445,4511,4545,4569,4583,4611,4636,4637,4638,4659,4733,4858,4941,4947,6431,6583,6869,6870,6871,6872,6873,6874,6875,6876,6877,6878,6879,6880,6881,6882,6883,6884,6885,6886,6887,6888,6889,6890,6891,6892,6893,6894,6895,6896,6897,6898,6899,6900,6901,6902,6903,6904,6905,6906,6907,6908,6909,6911,6910,6912,6913,6914,6915,6916,6917,6919,6918,6920,6921,6922,6923,6924,6925,6926,6927,6928,6929,6930,6931,6932,6933,6934,6935,6936,6937,6938,6939,6940,6941,6942,6943,6944,6945,6946,6947,6948,6949,6950,6951,6952,6953,6954,6955,6956,6957,6958,6959,6960,6961,6962,6963,6964,6965,6966,6967,6968,6969,6970,6971,6972,6973,6974,6975,6976,6977,6978,6980,6979,6981,6982,6983,6984,6985,6986,6987,6988,6989,6990,6992,6991,6993,6994,6995,6996,6997,6998,6999,7000,7001,7002,7003,7004,7005,7006,7007,7008,7009,7010,7011,7012,7013,7014,7015,7016,7017,7018,7019,7020,7021,7022,7023,7024,7025,7026,7027,7028,7029,7030,7031,7032,7034,7033,7035,7036,7037,7038,7039,7040,7041,7042,7043,7044,7045,7046,7047,7048,7049,7050,7051,7052,7053,7054,7055,7056,7057,7058,7059,7060,7061,7062,7063,7064,7065,7066,7067,7068,7069,7070,7071,7072,7073,7074,7075,7076,7077,7078,7079,7080,7081,7082,7083,7084,7085,7086,7087,7088,7089,7090,7091,7092,7093,7094,7095,7096,7098,7099,7100,7101,7102,7103,7104,7105,7106,7107,7108,7109,7110,7111,7112,7114,7113,7115,7116,7117,7118,7119,7120,7121,7122,7123,7124,7126,7125,7127,7128,7129,7130,7131,7132,7133,7134,7135,7136,7137,7138,7139,7140,7141,7142,7143,7144,7145,7146,7147,7149,7150,7151,7152,7157,7158,7159,7160,7161,7162,7163,7164,7165,7166,7167,7168,7169,7170,7171,7172,7173,7174,7175,7176,7177,7178,7179,7180,7181,7182,7183,7184,7184,7185,7186,7187,7188,7189,7190,7191,7192,7193,7194,7195,7196,7197,7198,7199,7200,7201,7202,7203,7204,7205,7206,7207,7208,7209,7210,7211,7212,7213,7214,7215,7216,7217,7218,7220,7222,7221,7223,7224,7225,7226,7227,7229,7230,7231,7232,7233,7234,7236,7235,7238,7237,7239,7240,7241,7242,7243,7244,7245,7246,7247,7248,7250,7249,7251,7252,7253,7254,7255,7256,7257,7258,7260,7261,7262,7263,7264,7265,7266,7267,7268,7269,7270,7271,7272,7273,7274,7276,7275,7277,7278,7279,7280,7281,7282,7283,7284,7285,7286,7287,7288,7289,7290,7291,7292,7293,7294,7295,7296,7297,7298,7299,7300,7302,7301,7303,7304,7305,7306,7307,7308,7309,7310,7312,7313,7314,7315,7316,7311,7317,7318,7319,7320,7321,7322,7323,7325,7324,7326,7328,7327,7329,7330,7331,7332,7333,7334,7335,7336,7337,7338,7339,7340,7341,7342,7343,7344,7345,7346,7347,7348,7349,7350,7351,7352,7353,7354,7355,7356,7357,7358,7359,7360,7361,7362,7363,7364,7365,7366,7368,7367,7369,7370,7371,7372,7373,7374,7375,7376,7377,7378,7379,7380,7381,7382,7383,7384,7385,7386,7387,7388,7389,7390,7391,7392,7393,7394,7395,7396,7397,7398,7399,7400,7401,7402,7403,7404,7405,7406,7407,7408,7409,7410,7411,7412,7413,7414,7415,7416,7417,7419,7418,7420,7421,7422,7423,7424,7425,7426,7427,7428,7429,7430,7431,7432,7433,7434,7435,7436,7437,7438,7439,7440,7441,7442,7443,7444,7446,7445,7447,7448,7449,7450,7451,7452,7453,7454,7455,7456,7457,7458,7460,7461,7462,7463,7464,7465,7466,7467,7468,7469,7470,7471,7472,7473,7474,7475,7476,7477,7478,7479,7480,7481,7482,7483,7484,7485,7486,7487,7488,7489,7490,7491,7492,7493,7494,7495,7497,7496,7498,7499,7500,7502,7501,7503,7504,7505,7506,7507,7508,7509,7510,7511,7512,7513,7514,7516,7517,7518,7519,7520,7521,7522,7523,7524,7526,7525,7527,7528,7529,7530,7531,7532,7533,7534,7535,7536,7537,7538,7539,7540,7541,7542,7543,7544,7545,7546,7548,7549,7550,7551,7552,7553,7554,7555,7556,7557,7558,7559,7560,7561,7562,7563,7564,7566,7565,7567,7568,7569,7570,7571,7572,7573,7574,7575,7576,7577,7578,7579,7580,7581,7583,7582,7584,7585,7586,7587,7588,7589,7590,7591,7592,7593,7594,7595,7596,7597,7598,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7617,7618,7619,7620,7621,7622,7623,7624,7625,7626,7627,7628,7629,7630,7632,7631,7633,7634,7635,7636,7637,7638,7639,7640,7641,7642,7643,7644,7645,7646,7647,7648,7649,7650,7651,7653,7652,7654,7655,7656,7657,7658,7659,7660,7661,7663,7664,7665,7666,7667,7668,7669,7670,7671,7672,7673,7674,7676,7677,7678,7679,7681,7680,7682,7683,7684,7687,7688,7691,7693,7694,7700,7702,7705,7706,7707,7724,7725,7821,7822,7823,7824,7826,7827,7828,7829,7831,7832,7833,7835,7839,7841,7842,7846,7848,7850,7852,7856,7858,7927,7928,7931,7939,8148,8169,8171,8174,8180,8184,8188,8192,8219,8220,8225,8227,8229,8234,8235,8236,8237,8238,8239,8240,8241,8242,8243,8244,8245,8246,8247,8248,8249,8250,8251,8252,8253,8254,8255,8257,8259,8260,8261,8262,8263,8264,8267,8269,8270,8271,8272,8274,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8289,8290,8295,8301,8303,8317,8319,8320,8321,8322,8339,8348,8350,8351,8354,8355,8359,8366,8367,8368,8369,8385,8386,8388,8389,8406,8409,8410,8411,8421,8422,8424,8425,8426,8450,8451,8452,8473,8475,8476,8477,8478,8487,8500,8502,8504,8518,8522,8531,8532,8533,8534,8535,8536,8537,8556,8557,8558,8559,8560,8561,8562,8563,8610,8611,8612,8613,8614,8616,8617,8618,8619,8620,8641,8643,8645,8647,8649,8650,8651,8653,8654,8655,8657,8659,8660,8663,8665,8666,8667,8670,8682,8683,8684,8687,8688,8690,8691,8692,8694,8696,8697,8704,8705,8707,8712,8713,8714,8715,8716,8717,8719,8721,8723,8729,8730,8731,8732,8733,8734,8735,8736,8737,8744,8748,8749,8750,8753,8754,8765,8766,8769,8770,8771,8772,8773,8784,8786,8788,8787,8789,8790,8792,8793,8796,8800,8801,8802,8803,8804,8805,8806,8817,8818,8819,8820,8821,8822,8823,8824,8833,8834,8835,8836,8837,8838,8839,8860,8861,8864,8867,8877,8879,8880,8884,8885,8886,8889,8890,8898,8907,8909,8910,8917,8918,8923,8924,8925,8926,8927,8928,8929,8932,8939,8940,8941,8942,8948,8949,8960,8961,8962,8963,8979,8980,8981,8982,8983,8984,8991,8994,8995,8996,8997,8998,8999,9000,9001,9011,9012,9013,9014,9022,9031,9032,9034,9039,9043,9044,9046,9054,9055,9056,9057,9069,9076,9077,9078,9080,9086,9092,9097,9101,9107,9110,9112,9116,9120,9121,9123,9125,9127,9128,9130,9132,9137,9139,9141,9143,9145,9147,9149,9150,9156,9158,9162,9323,9164,9165,9167,9170,9175,9177,9179,9180,9182,9184,9185,9187,9188,9190,9192,9193,9195,9197,9198,9199,9201,9203,9204,9206,9207,9209,9212,9214,9216,9218,9219,9220,9221,9223,9224,9226,9228,9230,9232,9235,9236,9238,9240,9242,9244,9246,9247,9250,9254,9255,9257,9262,9264,9266,9267,9269,9273,9276,9278,9280,9283,9294,9296,9298,9300,9302,9303,9305,9308,9310,9313,9315,9317,9319,9327,9329,9331,9333,9338,9340,9346,9352,9355,9358,9362,9372,9379,9384,9385,9387,9390,9393,9397,9399,9401,9403,9408,9410,9412,9414,9415,9417,9421,9424,9426,9434,8256,9440,9446,9448,9450,9452,9453,9455,9457,9460,9462,9470,9471,9473,9476,9477,9480,9482,9485,9486,9487,9490,9492,9494,9495,9497,9501,9503,9505,9509,9511,9517,9519,9521,9523,9525,9528,9532,9534,9536,9538,9540,9544,9546,9549,9551,9553,9556,9559,9561,9562,9564,9566,9569,9570,9573,9574,9576,9578,9579,9582,9589,9592,9594,9597,9599,9602,9604,9608,9614,9616,9619,9624,9626,9630,9635,9637,9639,9641,9642,9645,9646,9649,9650,9655,9659,9664,9668,9670,9672,9674,9676,9678,9680,9682,9693,9696,9697,9698,9699,9701,9703,9705,9706,9708,9710,9712,9715,9718,9721,9722,9726,9727,9730,9731,9734,9736,9737,9739,9741,9743,9744,9746,9748,9750,9755,9759,9760,9762,9767,9769,9770,9773,9774,9777,9779,9780,9785,9787,9788,9791,9793,9794,9798,9802,9807,9809,9811,9813,9815,9817,9818,9822,9915,9923,9924) AND p.approve=1 AND date < '2024-11-01 08:36:16' ORDER BY date DESC LIMIT 640,20