Hello
i had a site who was going well.
In the cpanel from my host, i went to "databases"
There you can do a "checkup"
next to some table names, there was a warning error :"Warning : 1 clients hasn't used or hasn't closed the table properly."
i had a repair button, so i hit it.
All went well, status changed to "ok".
After some minutes all went wrong.
a new warning sign next to the 4images_sessionvars table : "table is marked as crashed."
no backup from previous database helps me out , nor does the repair button.....
all i see is this :
DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1128672221 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Got error 127 from table handler
DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ('826fe1a4eb92c6ccc2801135a679570c', 'cdb4662f7de6c7cdf612b427706a2fc0', 'fa35fd5f2bc84ddcc87bf49117c79c9f', '94fc95453e389b60ea584b488d4a81f8', 'defea214014723b9a37751b917e66fce', 'd38056bafcd5edf4d9d41b25c7bd1a8f', 'f3bb5930bdcdf6d0048f6c8d64998218', '933ad3fd7c2d11ab98273deced4b1098', 'a0d9bdf466780fbe67f5ce07af616763', '8d39feb11f8e2b10227e120fc3053736', '45466d725d27b9fbe1a68f6ee9c65124', '3783867b9182d6f514188a16831f5dfb', 'd143b499c2d513394ceabfac0bf34c92', 'fd614a7fdbee7b480b265ac1b3f376ff', 'd996c699a78d697106a154151b83aa3b', 'd17c53a592d2baef4e416161733d8e19', 'e40401e96030fa6d094db12d5e2a1351', '4f2aadc786188e43cc9785a8f5f28a47', '4b55060900b590e47c184d9387bf5a36', 'de66b4ca34e89a28962ddf09773af4c3', '912899feb41efeb487cb172c13a446ea', '28ae21082a9f94125d307a2f48308b59', 'c79d20fa29565c35433da36e7b220ffe', '5fdbd64b4eba9baffb98af9a0f0f2c5e', 'cd84d7270df2c0868c51450298f89b80', 'c98ed9c95293e6814aa891b5a2338720', '3078bc940e37c54d27ae1db4db2db4af', '1935de08b61dae27aa35cb99dbff4a77', 'bf3d9a30d684a674525f0c8fb6c905f7', '5053f557b8bf890ba8b03b366e344f66', '6c6a34a03b0d51e80f0806182618ec6d', 'f387ea165385fdf88a6bbea9484d89f6', 'ddcd9342df669327b0de1c27e8ce08bf', '2fa58c732d2ad22a570bd673d4023e76', 'a5cd8e044e64997ce9a319d18313e3d3', 'c063bd384fbc5cea5619fb97dfc751cd', '6cd9b3bed24e1a82060d274b0c2a4476', 'd4f4645b2fa986f0764413dff95f3eee', 'e9874aad68b0059884b280515e707d51', 'cdcd580d680138d58dcf872e1988a4ba', 'a79020f3394e6a38d59df95fe3b7d254', '8b409d09661893145dc0a9c4f6702736', '5ab539e0302dbaa835994d108c1a1588', '59f4f3f43b8c648a4863269070f0ca3c', '5939636fd70c5a11ec9fd32a7e78a2b6', '9ca28cd720a7a3e81af92ccc5c2e1fd4', '946892b2b300e977b9f213e1f008787f', '00667f084930d3e50bb7f16226d3cb00', '8a846d75e6bd6219d3002f228cfb1711', 'e65050a0ad92da656510af883d9a137c', '2f35bb1644eed572044091a347d53a83', '190d3a450949511df034c5963166fec5', '18e67863ddf09184c9a47e19c7752cce', '61448f9c354ed18458d6d17e78305fe1', '4217d7bb17b8ac95748dfd7284dcd98f', '50462fab904e21c8677ea6b1218f8907', 'cab55d17e6a634d90fbed8e5ff7413e5', '663d47963cb497479a5081238d8b0b12', 'bace41547716a690284107bdcb47aff2', '27789e06cd5992414f3478413653825c', 'fde224651c7ad93406979b2acfff1d6c', '397f7d09c494cb50785d8d4878f639f4', 'bde464e90ee22d4a297a29fe3c2bcd91', '7609c9ab03e063bc9a259bfd9604f9bb', 'ca085aecf8d0efc9fb1bab0dd6581a23', '8774905ccaf0ede2b5cd2ba9861f0ee8', 'b6e981c3e56d62d666730e1050102984', '70380035825d47adf38887684fb55212', '357380e60ff7f0c322b9628b649a4983', 'b7cc2b510c508926c564325f5fcb9a5e', '44d652efa56c871df527c08c197fb82d', 'b8234c2f1aa0063198faba35a18bbd6d', '1e45875ac50cf63ecfec6275c5c00c69', '670d036ea516ad7758b2237fd1c1c910', '2ed851e102c4b89c1548170ba600cb39', '652b9dff3e61f6c886993f48ae860d1a', '2f37a265ac897e4947537a8140c2f93a', 'bce63e0401ec2484485c2b84b4d3b5f3', '3c7d20f0e4ee83d401d3d5c41be8a509', 'e91684ee4c2ed2521915dd1a4651bd93', '2b968d167155bf2f0d0c7c6e61e28b71', 'e02e2fa8df32c9fb533268b227c1be1b', '1c10d8656ec0ca99952686159b22f12c', '2fd8768a19ba75d1029eb84dcfff4def', '6524cd90dc832b3dca7422787c48f170', '7beb36f5132603729ff9fba1851a7ead', 'e0bb82ac4b2b17e2f3e94adacba50e89', '10a4b65e00755cad7156cee967816a10', '385314ec426cec0e4c65aaac13cc024f', '27faf89fae3da72740202f226657fb21', 'bda97673b8a6b61993fc0e556a17861c', 'ae0b9f8668b1ec8bcde4f7d457c0ff57', '67ed843536a44cab7ae76fad155d36b4', '135d60aa2da20e1ce6da183492504ad2', '2015562e95b16bdb77b75b191a381add', '7875129ad0c96720a6120d74af4530e9', 'a470ff92a4a32c307d5c5534854e773a', '54a5105931e230a4ac9d5f97c78a4a1b', '09fa40f494c9f7b0088a9295212855ec', '99f47923b0e5b5ef526f0de1b0bba5f2', 'b0d3e3e4c31bf42de2c92f9a7f265030', 'ded9992b4610faa76a0b3a7250e21b37', '80aaa04d75150b04dc60821173a11f02', 'e53e5952b0971e837586338498715ded', '8862d580a5b41915944fcdc29505cec9', 'f59b065226c5d98d3f516d419e13773b', 'f1e575825b6b826243c207f1d1fc1305', '6ff218463f9e07005db83142e017a9ff', 'c895ce9828f7b8de9ed92d6b762d9bfb', '0ec8a805a14c20a042805302b7792e59', 'f496d32ac1135867b7232bc5944bcc68', '3540ad4b0843d090143ace57dce0b293', '2bc2d3d4589d2921e0039313b85ddcfb', '7c82f15844c979ba809576810ec0745a', '3a17cb164e78cc9a307168c58bf7b45c', 'd1a0160c23107596d00f6428069fd167', 'f939344966f8daf46410f333e6d52031', '8ab7f6e75b7cc21833beebb135731131', 'b85532ae9b3e418af9d94d51b2758de4', '0502e536d4d9aac48ac0cdb4b85ac8db', 'b5814625163d565de6bf3ecc2c6cf54d', '19f3df1a8eee0883d628561b4075a1c2', 'ab71e4c5d38cb02ffd84775017f81d47', 'd8b8c74c6d371037db92fc506f540af1', '811f4f6fcd09cd6a43f8685d11c44db2', 'cd188993f28278f205517bcf595784c8', '0961cbb71cd76ac05a3d8070a20f9c81', 'b326abbc2dcc09ed2bab06a10c6d0050', 'bffc9b1ed07bedcd235da609e57fac7a', 'b4cf83f59005f72b924d620cb0e6d467', '5d344a02883cd07caa5eee7e045217d6', '096a5b555a2676956731ef298917f40c', '0a6d76de33e02e449f6fd97a5b3dbc39', '33124147f7ca774262fd6274258d6c8a', 'becfa5908df2ee610766168ce6a46d70', 'ba1575a891f8b35514d55106a4c32d06', '2df5f894afb821cc30cac0458d4b1ce9', '23bcecc2e9fe1b70b9bffb2e37342ccf', 'd86811c61160264e17d2b6ed62aae758', '4b8871687c7cdefe44d02c795c9c08e0', '29a2d9894669b16516961abc4e23d117', 'bbe5261e929e722bb8f158cce3eb9478', '744f6c3f0b9096c6226b4c8dbc21a267', 'd77c44ee93f94bfcb9af006f1cf34331', 'ebb7ee1ec36d16e3878d8417edc7568a', 'c86c6a2f39ad2bd603571db405987c7f', '77b65b37a060e2979ec7c9ab1b38ca87', 'f82389db6f89caf553a23ad4ccda0632', '12db6f7f7ae8667b8615b7f264df3ecd', '3d227321d0d312ea361484c88ac5cdf4', '0e82089ca7c4a3dc8e2f72a679730481', '91d6629970c11d42b4b0cb88edd1fdc1', 'c97d835f69b1692009511449ab7c8b41', '5ae31ef2d59f42c8599c53d9817ee360', '02c92aa75164de343dab2c631050fdaa', 'da7481c3db04962fe8387d423249e91c', 'a621696d3202a2383b1ff75589d65eba', '7f972811df5f20680f47ec4bb628037d', 'e4d4cc1a5761bb8f8c1d0d08d4c2763f', '229f162d1d290bb2690148ee2f3424c6', 'e66d177b2c0e2ea135f83e65f7fce5fa', '635fcc3d112ab6b7bf5e06b830898e21', '0e00deec062d3822353dfb23406079c1', '4013bf6e9889409b4f5882e32536f55e', 'a7269156856fac0afba5d4ada8aa5e40', '3ca83e5d350f84fede3b13f78eb5353b', '4eca2c54fcf38ec563d23ae685ecf539', '0cc6ed201c0047669d849b4b53453d56', '22cc1182525f02bf3037d12fd5f232ff', '52c437cf7fd12aa2fa3af90a25c941ef', 'af24a6bfc9a3420cb613f75b49fcfe48', '92482fcaf1fb860714055883bf948249', '8b9e3e77c055daa1a6d9cfa7f4448fed', '6cb4a7d5ba27b572c9da49f62489a054', '23814daa471f1aed4fd864ba093419ec', '7ed3679a2421629e302e6788ac42ce4d', '137ee07ce52c015745ae92e1023f22e8', '0bc3d488ac412f4b0754b9ff8ba9aea1', 'ff7d2b8a7d851ba51a9641a505692a52', 'b7e28baf0b5bc6c4491dbaab453cd01d', '00d8e500ad91b4d74f98e89f29870d37', '5bbcd84aa5be24756ca25f2ca2079cdc', 'cf468d8e7e9096454fcca21acba0ca8e', '10914caaa53f01105ba5b4d8a257e61c', 'cb0e7f976ddefdfa1d3ebebe874f1e1d', '9b854ae73ae7968f8ab5ce1113a707a2', 'ca55411d183f465d44966baf362ee8a9', 'bc395d8dd8bd9cb9ae78ca81cd2e670e', 'bfd089c49aa151464fee9548cc89cb87', 'f49b9119d1e66d363f459050dfdaffcd', 'ce3776fda2a6a753b34da64a84afa093', 'e54df90d2c6628dacb6b65ae4ac91a6a', 'c283253956f5791252ede9fab1841c38', 'e25c9edcf6fbbfc37c497abd8cf76b57', '8de214428634db951357f84b87b974f3', 'e10ade94d1d88ab7e15a07a229ac7f04', 'ab53e28a3e521cf10e57ba8b850a403d', 'd274024fcf5267ead8a2164466fa182d', '02a1e377e10025f63b57669e5fd33ab7', 'ed05d7c8664381d5ae0949d82431cca3', '336e9fce23d4e03ecf5b2eaca3720875', '5b50d8559e7d5857da3cb11073b5b357', '18f067af753a9fcb73225a924a40b79f', '6dc46bff5a23a8c91e9521035659793e', 'ef3f704d4c5cdee61c2fcea4ea440722', '5eda965a2fa992b93315e210bc2a34cf', '075cac71c5c46019e8c3c0c6c8a02de6', '41f2cd45a7925fee07c64a8312d0619d', 'e6850c45738af46f58bd478238f16cbb', '5fef9a6830a096931da5b9aae0131b8a', '090519151a8d7b9022ad1ba94d235e0b', '731f47aefb7ecbd5c41a62ddc1af7710', '276e2801ba91a9ceaffa8d71e433d7c2', '62124eb19b9f993e427c05a02414db86', '983f8d6b846aaf1fc5c4424bbf642fe9', '20ffb4a05481b92a51bcebd3a983744c', '24fc8627162117e06e3268e6dfd6626d', 'b8eaec514f4663d5a2c286a8d3865c7d', '68dd9a4abefe51baf853cf22ae50c5d3', '0c8fea6e3a79a5b8731fd5a64f6bc4d8', '7e5a3d8fd749207a9123c1325ce282e0', '1cabd632914cf845ed17c06a8fc3ef46', 'd1de663b318e4981cfa29e043027d8fb', '0da379ee06370726eff5990aea56d3aa', 'c4bcf77794d3ee27f7065772aa126384', '148471b32c57525008357c2d16f51788', 'a692356db4f2a98e9b0ce5f54dc97124', '8573f948e630063b399a649803c5bd4f', 'ae633c955ee40d127e1410fa729a4099', '3e4de23d10ea14c74e31dccd4a53211a', 'e535846ffe48886286ceb4ce2872dc6a', '9b053af8a1cfad9384b7b29f33ec307b', '9d14855451d35d8d2c5c37159e660591', '71d100a6953fae99b8945870437e1d82', '5818f941c3a5ecce3e3558b42f914646', '8b282281e4527805e7997616786a8c24', '7c55771729e44d4fdb242db66ee58ccd', 'c2edaa3099b4dbf0ca12a582d144f8f5', 'f4a8fa7daa9e3dc094dcdd65f2f475d9', '9b862e3d50d7c6ba035b67f0aab94151', 'a8673c4bde5f80cfba84c7c5356d0b1d', '3d3fe06cdcf8122500317c91a4993f75', 'd335e205a41b7d7b7cfa3b72f6ac971a', '94b49758127e09ab1676c637d7a71692', 'e8062a021da51460a5864821500a34b0', '22a90a7de448eeb37ae5f2fe7398c841', 'a09b4203c027b2141173796da969722f', '10ab508661f41875f67c507232b992d8', '9516c0cf93bf6d87f1e473ff99deefb8', 'ca8908f23f0fb3b04c8835e520e7b6ad', '6837076d45ef3de32943cc9f47e353dd', '6a540cf3d86ae9a76de4fe57e40dd984', '11c0f7e3f08d080b0a33757b989ec60d', '155714bcaa84a0b2c5716cb01ba680de', '1603d99d8e6451fef4e6db3ee9ff1d3f', '87a0b5cfd8d0b38db314cea65298b53b', '7cd9ec2ba686c7d509051ccb9ee0f4cd', '222d4e7baa97cf2d4f6571e8bedbe382', '142df4391f412383932770811f878797', 'e713e801036b42ca6b6ed495c1930e71', '52ee344da7464368aca276d2ee16eff9', 'b399bf893742bde6c166ce460da2583b', 'c83f2fa4114021577b8666d1dbc1c39b', 'aac1e485710b7d927da3f93d868a243b', 'dcba040200c55ed2261ef534320acd31', '39b3e897c230e887925ea6a150394d43', 'bee59bc84d5ff878f6f96d3aaae857c7', '30af9a5228d9a643239375f18f4b21ee', '0bd82ff1e15b0d0716b53d59a06531b8', 'c4f79c95a5f8a130fb4ac25f8756aef3', '7406f390ddcf90cb59d2e5bf06258dd8', '48d67c6ba3a2e1055d86ed85edec41f2', '306883f7d69fc6b14e4dd5da6ddb0f02', 'beee692c3a8dbd52f0dd393843314ec8', 'bc61e442e26b40b5d24c58a566117f5b', 'c880bcff695f1b43b1d14cae35202a6d', 'fa817a8260499be42a08a28f309a3817', '4feb0406f6781edfb207f11434157317', '306f2ee58c2e33c9a423c3bef8eedacd', '8f44cbb57f894c08c3209f41f55d8fa6', '2d8939301e7fc729c08c466db6a2e3a3', '2af181bfbca5bb9317ad807d6a7fecec', 'df4cd513c30eb6fb6e9488784c109003')
Incorrect key file for table: '4images_sessionvars'. Try to repair it
Warning: Cannot modify header information - headers already sent by (output started at /home/schoolpl/public_html/includes/db_mysql.php:188) in /home/schoolpl/public_html/includes/sessions.php on line 102
Warning: Cannot modify header information - headers already sent by (output started at /home/schoolpl/public_html/includes/db_mysql.php:188) in /home/schoolpl/public_html/includes/sessions.php on line 102
Warning: Cannot modify header information - headers already sent by (output started at /home/schoolpl/public_html/includes/db_mysql.php:188) in /home/schoolpl/public_html/includes/sessions.php on line 102
DB Error: Bad SQL Query: SELECT SUM(image_hits) AS sum FROM 4images_images
Got error 127 from table handler
DB Error: Bad SQL Query: SELECT SUM(image_votes) AS sum FROM 4images_images
Got error 127 from table handler
DB Error: Bad SQL Query: SELECT SUM(image_downloads) AS sum FROM 4images_images
Got error 127 from table handler
DB Error: Bad SQL Query: SELECT SUM(image_comments) AS sum FROM 4images_images
Got error 127 from table handler
DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0, 67, 69, 70, 73, 75, 76, 77, 78, 82, 83, 84, 85, 87, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 113, 114, 115, 116, 123, 125, 127, 128, 129, 130, 131, 133, 134, 135, 136, 143, 144, 145, 146, 147, 149, 150, 151, 152, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 168, 169, 170, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 202, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 215, 216, 217, 218, 219, 220, 221, 224, 226, 227, 228, 229) AND c.cat_id = i.cat_id ORDER BY RAND()
Got error 127 from table handler
DB Error: Bad SQL Query: INSERT INTO 4images_sessionvars (session_id, sessionvars_name, sessionvars_value) VALUES ('0c0baa65075f31c70235ef0ff59fb546', 'perpage', '40')
Got error 22 from table handler
anyone knows what is going on here ? and how to solve it ?
thx
