database ของ thaiopensource error สาเหตุมาจาก พี่ปุ๋ยเก็บไฟล์จนล้นฮาร์ดดิสก์ แล้วมันเก็บข้อมูลไม่ได้ ก็เลยขึ้นเออเรอร์ ทีนี้พี่อ้นเคลียร์พื้นที่ฮาร์ดดิสก์ให้แล้ว restart mysql แล้ว เออเรอร์ยังไม่หาย
เออเรอร์ขึ้นตามนี้
Warning: Table './web3_db1/newtos_sessions' is marked as crashed and should be repaired query: SELECT u.*, s.* FROM newtos_users u INNER JOIN newtos_sessions s ON u.uid = s.uid WHERE s.sid = 'cbc5e6404866947d36187a1ca5303361' in /var/www/web3/web/includes/database.mysql.inc on line 172
Warning: Table './web3_db1/newtos_cache_page' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM newtos_cache_page WHERE cid = 'http://thaiopensource.org/' in /var/www/web3/web/includes/database.mysql.inc on line 172
Warning: Table './web3_db1/newtos_watchdog' is marked as crashed and should be repaired query: INSERT INTO newtos_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table './web3_db1/newtos_sessions' is marked as crashed and should be repaired\nquery: SELECT COUNT(sid) AS count FROM newtos_sessions WHERE timestamp >= 1203050307 AND uid = 0 in /var/www/web3/web/includes/database.mysql.inc on line 172.', 2, '', 'http://thaiopensource.org/', '', '124.120.152.149', 1203051207) in /var/www/web3/web/includes/database.mysql.inc on line 172
Warning: Table './web3_db1/newtos_watchdog' is marked as crashed and should be repaired query: INSERT INTO newtos_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table './web3_db1/newtos_sessions' is marked as crashed and should be repaired\nquery: SELECT u.uid, u.name FROM newtos_users u INNER JOIN newtos_sessions s ON u.uid = s.uid WHERE s.timestamp >= 1203050307 AND s.uid > 0 ORDER BY s.timestamp DESC in /var/www/web3/web/includes/database.mysql.inc on line 172.', 2, '', 'http://thaiopensource.org/', '', '124.120.152.149', 1203051207) in /var/www/web3/web/includes/database.mysql.inc on line 172
* user warning: Table './web3_db1/newtos_sessions' is marked as crashed and should be repaired query: SELECT COUNT(sid) AS count FROM newtos_sessions WHERE timestamp >= 1203050307 AND uid = 0 in /var/www/web3/web/includes/database.mysql.inc on line 172.
* user warning: Table './web3_db1/newtos_sessions' is marked as crashed and should be repaired query: SELECT u.uid, u.name FROM newtos_users u INNER JOIN newtos_sessions s ON u.uid = s.uid WHERE s.timestamp >= 1203050307 AND s.uid > 0 ORDER BY s.timestamp DESC in /var/www/web3/web/includes/database.mysql.inc on line 172.
สุกรีบอกผมเป็นภาษา shell ว่า
mysqlcheck -re -uuser -ppass web3_db1




Post new comment