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-d7f16-8110.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 (3104,3106,3107,3109,3111,3113,3116,3117,3122,3124,3126,3129,3132,3134,3145,3147,3148,3150,3152,3154,3155,3157,3158,3160,3162,3163,3165,3174,3176,3178,3180,3181,3183,3184,3186,3188,3192,3195,3199,3201,3206,3209,3228,3231,3232,3235,3236,3238,3239,3240,3242,3245,3244,3246,3258,3259,3260,3261,3264,3266,3268,3269,3272,3274,3277,3278,3280,3283,3284,3287,3289,3292,3294,3295,3296,3297,3298,3306,3307,3308,3310,3311,3312,3313,3315,3323,3324,3325,3327,3330,3334,3337,3338,3339,3341,3342,3343,3347,3348,3351,3352,3353,3356,3359,3363,3364,3368,3369,3370,3372,3374,3380,3383,3384,3387,3388,3391,3392,3394,3395,4596,6675,6682,6681,6683,6686,6688,6691,6693,6697,6698,6701,6707,6710,6713,6714,6717,6718,6720,6722,6723,6724,6725,6726,6732,6733,6734,6735,6737,6747,6748,6750,6751,6752,6753,6769,6770,6773,6775,6777,6778,6779,6781,6782,6783,6784,6785,6786,6787,6788,6790,6793,6794,6796,6797,6798,6800,6803,6809,6811,6814,6815,6816,6817,6818,6820,6821,6824,6825,6827,6828,6833,6836,6838,6842,6869,6871,6872,6876,6878,6879,6881,6884,6886,6888,6889,6891,6892,6894,6895,6896,6897,6900,6902,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,6973,6974,6975,6976,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,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,7693,7694,7706,7707,7724,7725,7857,7930,7931,7932,7933,7934,7935,7936,7941,7943,7944,7945,7946,7947,7948,7949,7950,7951,7952,7953,7954,7955,7956,7957,7958,7960,7961,7962,7963,7964,7965,7966,7968,7969,7970,7971,7972,7973,7974,7976,7977,7978,7979,7983,7984,7985,7987,7988,7989,7990,7991,7992,7993,7994,7995,7996,7998,7999,8000,8001,8002,8003,8005,8006,8007,8008,8009,8010,8012,8014,8015,8016,8017,8018,8019,8020,8021,8027,8029,8030,8031,8032,8033,8035,8036,8037,8038,8040,8042,8043,8044,8045,8047,8048,8050,8052,8053,8054,8055,8058,8059,8060,8062,8063,8064,8065,8066,8067,8068,8069,8070,8071,8072,8073,8074,8075,8076,8079,8080,8081,8082,8083,8084,8085,8086,8088,8089,8090,8092,8093,8094,8096,8097,8098,8099,8100,8103,8105,8106,8107,8109,8112,8113,8114,8115,8118,8119,8121,8122,8123,8124,8125,8126,8127,8128,8130,8131,8132,8133,8134,8135,8136,8137,8227,8229,8249,8250,8251,8260,8267,8269,8270,8272,8276,8277,8278,8279,8285,8286,8301,8320,8321,8322,8348,8349,8350,8351,8352,8353,8354,8355,8360,8367,8385,8386,8387,8388,8389,8421,8422,8424,8425,8426,8427,8429,8431,8432,8557,8660,8697,8704,8716,8719,8727,8766,8770,8772,8784,8786,8787,8789,8790,8796,8800,8801,8802,8804,8805,8806,8824,8835,8837,8838,8960,8979,8993,8994,9001,9011,9053,9057,9067) AND p.approve=1 AND date < '2025-06-25 07:46:06' ORDER BY date DESC LIMIT 420,20