PDA

View Full Version : listings filters addon



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...

Viktor
December 24, 2012, 03:44 AM
Hello Petrache Nicolae,

I have checked your site and filter block working properly.

Petrache Nicolae
December 24, 2012, 07:11 AM
Hello Petrache Nicolae,

I have checked your site and filter block working properly.

hello Viktor. the error apear random. it hapens when i accesed links from google, or when i have provided a page link wich at me looked ok and at the client was not or it happened when i navigated the site as you can see in the image. i know is hard to trace the error without it manefesting to you but i hoped you have a clue

Petrache Nicolae
December 24, 2012, 07:28 AM
Hello Petrache Nicolae,

I have checked your site and filter block working properly.

it happened now to another client

http://www.piese-laptop.ro/piese-laptop/acumulatori-laptop/pentru-laptop-tableta-marca:producator_fujitsu/

MYSQL ERROR
Error: Got error 9 from storage engine
Query: SELECT SQL_CALC_FOUND_ROWS DISTINCT IF (FIND_IN_SET('230', `T1`.`Crossed`) > 0, 1, 0) AS `Crossed_listing`, `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Key` AS `Key`, `T3`.`Type` AS `Listing_type`, IF( `T1`.`Sub_status`='invisible' OR `T1`.`Sub_status` = 'visible', `T1`.`Main_photo`, CONCAT( SUBSTRING_INDE`T1`.`Main_photo`, '.', 1), '_', `T1`.`Sub_status` ,'_ro', '.', SUBSTRING_INDE`T1`.`Main_photo`, '.', -1))) AS `Main_photo` ,IF(TIMESTAMPDIFF(HOUR, `T1`.`Featured_date`, NOW()) <= `T4`.`Listing_period` * 24 OR `T4`.`Listing_period` = 0, '1', '0') `Featured` FROM `fl_listings` AS `T1` LEFT JOIN `fl_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` LEFT JOIN `fl_listing_plans` AS `T4` ON `T1`.`Featured_ID` = `T4`.`ID` LEFT JOIN `fl

he refreshed the page and worked ok after

i woulded uninstalled the addon but all the combinations of links are cached by google and will be a nightmare to remove them

Viktor
December 24, 2012, 08:21 AM
Hello Petrache Nicolae,

I cannot find this error :( all working good for me.

Petrache Nicolae
December 24, 2012, 08:28 AM
Hello Petrache Nicolae,

I cannot find this error :( all working good for me.

any sugestions what to do for you when it happens to me. or what to do withe all the page links that will be obsolete if i disable the addon? this worked fine and just lately i have an increase no of such errors

Petrache Nicolae
December 26, 2012, 10:28 PM
Hello Petrache Nicolae,

I cannot find this error :( all working good for me.


another example....what is happening? how can i fix it?


after page refresh i received this

Lost connection to MySQL server at 'reading authorization packet', system error: 104