1
Discussion & Troubleshooting / Error = Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it?
« on: January 01, 2007, 04:39:21 PM »
Hallo
bekomme immer diese fehlermeldung obwohl gar nichts geändert wurde:
DB Error: Bad SQL Query: SELECT 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 c.cat_id = i.cat_id AND i.cat_id IN (0, 1, 6, 17, 24, 10, 5, 16, 13, 15, 8, 22, 3, 38, 12, 2, 39, 11, 9, 4, 7, 18, 14, 23, 21, 20) ORDER BY i.image_rating DESC, i.image_votes DESC
Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it
DB Error: Bad SQL Query: SELECT 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 c.cat_id = i.cat_id AND i.cat_id IN (0, 1, 6, 17, 24, 10, 5, 16, 13, 15, 8, 22, 3, 38, 12, 2, 39, 11, 9, 4, 7, 18, 14, 23, 21, 20) ORDER BY i.image_votes DESC, i.image_rating DESC
Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it
DB Error: Bad SQL Query: SELECT 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 c.cat_id = i.cat_id AND i.cat_id IN (0, 1, 6, 17, 24, 10, 5, 16, 13, 15, 8, 22, 3, 38, 12, 2, 39, 11, 9, 4, 7, 18, 14, 23, 21, 20) ORDER BY i.image_hits DESC, i.image_name ASC
Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it
DB Error: Bad SQL Query: SELECT 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 c.cat_id = i.cat_id AND i.cat_id NOT IN (0) ORDER BY i.image_date DESC LIMIT 3
Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/users/timerex/4images1/includes/db_mysql.php on line 116
bekomme immer diese fehlermeldung obwohl gar nichts geändert wurde:
DB Error: Bad SQL Query: SELECT 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 c.cat_id = i.cat_id AND i.cat_id IN (0, 1, 6, 17, 24, 10, 5, 16, 13, 15, 8, 22, 3, 38, 12, 2, 39, 11, 9, 4, 7, 18, 14, 23, 21, 20) ORDER BY i.image_rating DESC, i.image_votes DESC
Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it
DB Error: Bad SQL Query: SELECT 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 c.cat_id = i.cat_id AND i.cat_id IN (0, 1, 6, 17, 24, 10, 5, 16, 13, 15, 8, 22, 3, 38, 12, 2, 39, 11, 9, 4, 7, 18, 14, 23, 21, 20) ORDER BY i.image_votes DESC, i.image_rating DESC
Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it
DB Error: Bad SQL Query: SELECT 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 c.cat_id = i.cat_id AND i.cat_id IN (0, 1, 6, 17, 24, 10, 5, 16, 13, 15, 8, 22, 3, 38, 12, 2, 39, 11, 9, 4, 7, 18, 14, 23, 21, 20) ORDER BY i.image_hits DESC, i.image_name ASC
Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it
DB Error: Bad SQL Query: SELECT 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 c.cat_id = i.cat_id AND i.cat_id NOT IN (0) ORDER BY i.image_date DESC LIMIT 3
Incorrect key file for table '/tmp/#sql_426_0.MYI'; try to repair it
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/users/timerex/4images1/includes/db_mysql.php on line 116