Petrache Nicolae
December 22, 2012, 01:15 PM
listings filters throws often errors like this
Error: Can't seek in file '/tmp/#sql_c932_0.MYI' (Errcode: 9)
Query: SELECT COUNT(`T1`.`judet`) AS `Number`, SUM(IF(`T1`.`Category_ID` = '311' OR (FIND_IN_SET('311', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET('311', `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_311`, `T1`.`judet` FROM `fl_listings` AS `T1` LEFT JOIN `fl_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `fl_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` WHERE (UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T2`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T2`.`Listing_period` = 0) AND `T1`.`judet` <> '' AND `T1`.`judet` NOT LIKE '%+%' AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T7
what is happening? it happened sometimes to me, other times the customers contact me to tell me this. it is unreal...
Error: Can't seek in file '/tmp/#sql_c932_0.MYI' (Errcode: 9)
Query: SELECT COUNT(`T1`.`judet`) AS `Number`, SUM(IF(`T1`.`Category_ID` = '311' OR (FIND_IN_SET('311', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET('311', `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_311`, `T1`.`judet` FROM `fl_listings` AS `T1` LEFT JOIN `fl_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `fl_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` WHERE (UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T2`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T2`.`Listing_period` = 0) AND `T1`.`judet` <> '' AND `T1`.`judet` NOT LIKE '%+%' AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T7
what is happening? it happened sometimes to me, other times the customers contact me to tell me this. it is unreal...