ERROR: http://www.mygreendirectory.info/deal/results.php

Query: SELECT distinct Promotion.* FROM Promotion 
											left outer join Listing_Summary Listing_Summary on Listing_Summary.promotion_id = Promotion.id
											left outer join Listing_Category ON (Listing_Category.listing_id = Listing_Summary.id) WHERE (Listing_Summary.status = 'A' OR Promotion.added_sitemgr = 'y') AND Promotion.end_date >= DATE_FORMAT(NOW(), '%Y-%m-%d') AND Promotion.start_date <= DATE_FORMAT(NOW(), '%Y-%m-%d') AND  ((Promotion.visibility_start <= 1390 AND Promotion.visibility_end >= 1390 ) OR (Promotion.visibility_start = 24 AND Promotion.visibility_end = 24))  AND (Listing_Summary.promotion_id > 0 OR Promotion.added_sitemgr = 'y') AND (Listing_Summary.level IN (70,10,50) OR Promotion.added_sitemgr = 'y') AND (Listing_Summary.location_1 = 235 AND Listing_Summary.location_2 = 8) AND Promotion.name LIKE 'x%' LIMIT 0,10

 Errno: 144
 Error: Table './mygreen_domain_1/Listing_Summary' is marked as crashed and last (automatic?) repair failed
_SERVER data
    REMOTE_ADDR : 54.205.176.107
    REMOTE_PORT : 41322
SCRIPT_FILENAME : /home/mygreendir/public_html/deal/results.php
 REQUEST_METHOD : GET
   QUERY_STRING : letter=x&location_1=235&location_2=8&status=A
    REQUEST_URI : /deal/results.php?letter=x&location_1=235&location_2=8&status=A

ERROR: http://www.mygreendirectory.info/deal/results.php

Query: SELECT COUNT(distinct(Promotion.id)) as row_amount FROM Promotion 
											left outer join Listing_Summary Listing_Summary on Listing_Summary.promotion_id = Promotion.id
											left outer join Listing_Category ON (Listing_Category.listing_id = Listing_Summary.id) WHERE (Listing_Summary.status = 'A' OR Promotion.added_sitemgr = 'y') AND Promotion.end_date >= DATE_FORMAT(NOW(), '%Y-%m-%d') AND Promotion.start_date <= DATE_FORMAT(NOW(), '%Y-%m-%d') AND  ((Promotion.visibility_start <= 1390 AND Promotion.visibility_end >= 1390 ) OR (Promotion.visibility_start = 24 AND Promotion.visibility_end = 24))  AND (Listing_Summary.promotion_id > 0 OR Promotion.added_sitemgr = 'y') AND (Listing_Summary.level IN (70,10,50) OR Promotion.added_sitemgr = 'y') AND (Listing_Summary.location_1 = 235 AND Listing_Summary.location_2 = 8) AND Promotion.name LIKE 'x%'

 Errno: 144
 Error: Table './mygreen_domain_1/Listing_Summary' is marked as crashed and last (automatic?) repair failed
_SERVER data
    REMOTE_ADDR : 54.205.176.107
    REMOTE_PORT : 41322
SCRIPT_FILENAME : /home/mygreendir/public_html/deal/results.php
 REQUEST_METHOD : GET
   QUERY_STRING : letter=x&location_1=235&location_2=8&status=A
    REQUEST_URI : /deal/results.php?letter=x&location_1=235&location_2=8&status=A
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mygreendir/public_html/classes/class_PageBrowsing.php on line 594 Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mygreendir/public_html/classes/class_PageBrowsing.php on line 606 Search results in United Kingdom, Devon | My Green Directory - The Eco/Green Directory
EnglishFrançaisEspañolDeutschItaliano
 

Found records

Order by:

No results were found for the search criteria you requested. Please try your search again.