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

Error Number: 1021

The Error returned was:
Disk full (/tmp/#sql-temptable-4718d-d7f12-1a234.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 (16,20,24,1121,1285,1366,1406,1415,1419,1431,1616,1778,1820,1944,3423,3448,3522,3707,3712,4305,4637,4691,4874,6868,6869,6870,6871,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,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,7044,7045,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,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,7142,7143,7144,7145,7146,7147,7149,7150,7151,7152,7157,7158,7159,7160,7161,7162,7163,7164,7165,7167,7168,7169,7170,7171,7172,7173,7174,7175,7176,7177,7178,7179,7180,7181,7182,7183,7185,7186,7187,7188,7189,7190,7191,7192,7193,7194,7195,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,7232,7233,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,7278,7280,7281,7282,7283,7284,7285,7286,7287,7288,7289,7290,7291,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,7368,7367,7369,7370,7371,7372,7373,7374,7375,7376,7377,7378,7379,7380,7381,7382,7383,7384,7385,7386,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,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,7496,7498,7499,7500,7502,7501,7503,7504,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,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,7693,7694,7706,7707,7724,7725,7931,8148,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,8270,8271,8272,8274,8276,8277,8278,8279,8280,8282,8283,8284,8285,8286,8295,8301,8319,8320,8321,8322,8339,8350,8351,8354,8355,8359,8366,8367,8368,8369,8406,8409,8410,8411,8425,8487,8531,8532,8533,8534,8535,8555,8556,8560,8561,8563,8610,8611,8612,8613,8614,8616,8617,8618,8619,8641,8643,8645,8647,8649,8650,8651,8653,8654,8655,8657,8659,8660,8661,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,8731,8733,8734,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,8861,8864,8867,8877,8879,8884,8885,8886,8889,8890,8907,8909,8910,8924,8925,8926,8927,8928,8929,8939,8940,8941,8942,8948,8960,8961,8962,8963,8979,8980,8981,8982,8983,8984,8994,8995,8996,8998,8999,9001,9011,9013,9014,9031,9032,9034,9043,9044,9055,9056,9057,9069,9078,9080,9097,9107,9110,9112,9116,9120,9121,9123,9125,9128,9130,9132,9137,9139,9141,9143,9145,9147,9149,9150,9156,9158,9323,9165,9167,9170,9175,9177,9179,9180,9182,9184,9185,9187,9188,9190,9192,9193,9195,9197,9198,9199,9201,9203,9204,9209,9214,9216,9218,9219,9220,9221,9223,9224,9226,9228,9229,9230,9230,9232,9235,9238,9240,9242,9244,9246,9247,9250,9254,9255,9262,9264,9266,9267,9269,9273,9276,9278,9280,9283,9294,9296,9298,9303,9305,9308,9310,9312,9313,9315,9319,9321,9327,9329,9331,9333,9338,9340,9346,9352,9355,9362,9379,9384,9387,9390,9397,9399,9401,9403,9410,9412,9415,9421,9424,9428,9440,9446,9448,9450,9452,9455,9457,9460,9470,9471,9473,9476,9477,9480,9482,9486,9487,9492,9494,9497,9501,9505,9507,9509,9511,9517,9519,9521,9525,9528,9538,9540,9544,9546,9549,9553,9556,9561,9562,9564,9566,9569,9570,9573,9574,9576,9579,9582,9589,9592,9597,9599,9602,9604,9608,9614,9616,9619,9621,9624,9630,9637,9639,9641,9642,9645,9649,9650,9659,9664,9668,9676,9678,9680,9693,9697,9699,9701,9703,9708,9710,9712,9715,9721,9722,9726,9727,9730,9731,9734,9736,9737,9739,9741,9743,9744,9746,9748,9750,9760,9762,9767,9769,9770,9774,9780,9785,9787,9788,9791,9793,9794,9798,9802,9807,9811,9813,9815,9817,9818,9822,9915) AND p.approve=1 AND date < '2025-06-25 07:45:50' ORDER BY date DESC LIMIT 1000,20