Error: Incorrect key file for table '/tmp/#sql_1ff1_0.MYI'; try to repair it
SELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10

Debug backtrace:

#0 esynDatabase->query(SELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10) called at [/home/daftarto/public_html/includes/classes/esynDatabase.php:243] #1 esynDatabase->getAll(SELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10) called at [/home/daftarto/public_html/includes/classes/esynListing.php:940] #2 esynListing->getListingsByCategory(99, 0, 10, , 1) called at [/home/daftarto/public_html/index.php:253]
Database query error: Error: Incorrect key file for table '/tmp/#sql_1ff1_0.MYI'; try to repair itSELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10 Debug backtrace: #0 esynDatabase->query(SELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10) called at [/home/daftarto/public_html/includes/classes/esynDatabase.php:243] #1 esynDatabase->getAll(SELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10) called at [/home/daftarto/public_html/includes/classes/esynListing.php:940] #2 esynListing->getListingsByCategory(99, 0, 10, , 1) called at [/home/daftarto/public_html/index.php:253] :: eSyndiCat Directory Software 2.3.04

Database query error: Error: Incorrect key file for table '/tmp/#sql_1ff1_0.MYI'; try to repair itSELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10 Debug backtrace: #0 esynDatabase->query(SELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10) called at [/home/daftarto/public_html/includes/classes/esynDatabase.php:243] #1 esynDatabase->getAll(SELECT SQL_CALC_FOUND_ROWS DISTINCTROW `t1`.`id`, `t1`.*, IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`,IF((`t1`.`sponsored` = '1'), '3', IF((`t1`.`featured` = '1'), '2', IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , IF((`t2`.`category_id` = '99'), '1', '0') `crossed`, '0' `favorite` FROM `v2304_flat_structure` `t10` LEFT JOIN `v2304_listings` `t1` ON `t10`.`category_id`=`t1`.`category_id` LEFT JOIN `v2304_categories` `t11` ON `t11`.`id`=`t1`.`category_id` LEFT JOIN `v2304_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '99' OR `t10`.`parent_id` = '99' OR `t1`.`category_id` = '99') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`date` ASC LIMIT 0, 10) called at [/home/daftarto/public_html/includes/classes/esynListing.php:940] #2 esynListing->getListingsByCategory(99, 0, 10, , 1) called at [/home/daftarto/public_html/index.php:253]

 

If you are not sure what this error means you can always visit eSyndiCat Support Forums or try these solutions.