Error: Table './bizguide_data/v2305_listings' is marked as crashed and should be repaired
SELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC
Debug backtrace:
#0 esynDatabase->query(SELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC ) called at [/home/bizguide/public_html/includes/classes/esynDatabase.php:259]
#1 esynDatabase->getAll(SELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC ) called at [/home/bizguide/public_html/includes/classes/esynListing.php:952]
#2 esynListing->getListingsByCategory(0, 10, , , 0) called at [/home/bizguide/public_html/feed.php:67]
Database query error: Error: Table './bizguide_data/v2305_listings' is marked as crashed and should be repairedSELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC
Debug backtrace:
#0 esynDatabase->query(SELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC ) called at [/home/bizguide/public_html/includes/classes/esynDatabase.php:259]
#1 esynDatabase->getAll(SELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC ) called at [/home/bizguide/public_html/includes/classes/esynListing.php:952]
#2 esynListing->getListingsByCategory(0, 10, , , 0) called at [/home/bizguide/public_html/feed.php:67]
:: eSyndiCat Directory Software 2.3.05
Database query error: Error: Table './bizguide_data/v2305_listings' is marked as crashed and should be repairedSELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC
Debug backtrace:
#0 esynDatabase->query(SELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC ) called at [/home/bizguide/public_html/includes/classes/esynDatabase.php:259]
#1 esynDatabase->getAll(SELECT 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`, '0' `account_id_edit` , IF((`t2`.`category_id` = '0'), '1', '0') `crossed`, '0' `favorite` FROM `v2305_listings` `t1` LEFT JOIN `v2305_listing_categories` `t2` ON `t1`.`id`= `t2`.`listing_id` WHERE (`t2`.`category_id` = '0' OR `t1`.`category_id` = '0') AND `t1`.`status` = 'active' ORDER BY `listing_type` DESC, `t1`.`title` ASC ) called at [/home/bizguide/public_html/includes/classes/esynListing.php:952]
#2 esynListing->getListingsByCategory(0, 10, , , 0) called at [/home/bizguide/public_html/feed.php:67]
If you are not sure what this error means you can always visit eSyndiCat Support Forums or try these solutions.