Ive have been had Ajax Search running for about 6 months with no problems, tried my search today and BAM get hit with a Parse error. I have not made any changes to the search since it was last working
The error I get is:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Incorrect key file for table '/tmp/#sql_51b6_1.MYI'; try to repair it »
SQL: SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `modx_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `modx_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%test%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%test%') OR (sc.longtitle LIKE '%test%') OR (sc.description LIKE '%test%') OR (sc.alias LIKE '%test%') OR (sc.introtext LIKE '%test%') OR (sc.menutitle LIKE '%test%') OR (sc.content LIKE '%test%') OR (tv_value LIKE '%test%'))) ORDER BY sc.publishedon,sc.pagetitle
What has confused me even more is I have a different search call on one page of my site (this one uses ajax) and this one is working fine stil..
anyone have nay ideas?
Thanks
