|
There was an error processing your request
An error occurred in the execution of this PHP page: http://www.pixelhomes.com:80/search/results.php PHP Error Occured:
| Page |
/home/iagehost/public_html/pixelhomes-com/search/results.php |
| Line |
197 |
| Error Description |
User Fatal Error (256): Error on executing SELECT
d.company,
c.member_id,
c.id,
c.beds,
c.bath,
c.price,
c.comments,
c.special,
c.stored,
c.stock,
c.zipcode,
c.laddress,
c.category,
c.mls,
c.acres,
c.sqft,
c.lcity,
c.lstate,
c.lcounty,
c.yrbuilt,
c.schools,
d.zip,
d.address,
d.state_id,
d.city,
d.website,
d.contact_name,
IF(TO_DAYS(NOW())-TO_DAYS(c.stored)<=7,'yes','no') AS is_new_listing,
d.featured AS dealer_featured,
IF(rsr.id IS NULL,'no',rsr.id) AS results_stat_id
FROM homes_listings AS c
INNER JOIN homes_sellers AS d ON d.id=c.member_id
LEFT JOIN homes_results_stat_report AS rsr ON (rsr.stock=c.stock AND rsr.member_id=c.member_id AND rsr.year = '2010' AND rsr.month = 'September')
WHERE
d.status='Active'
AND (c.mls LIKE '%%' OR ''='')
AND (c.category LIKE '%%' OR ''='')
AND (c.bath >= '' OR ''='')
AND (c.beds >= '' OR ''='')
AND (c.price >= '' OR ''='')
AND (c.price <= '' OR ''='')
AND (c.features LIKE '%%' OR ''='')
AND (c.zipcode LIKE '%%' OR ''='')
AND (c.member_id='' OR ''='') ORDER BY c.special ASC , color DESC LIMIT 0,8 |
| Context Variable Values |
GLOBALS = Array;
_ENV = Array;
HTTP_ENV_VARS = Array;
DOCUMENT_ROOT = /home/iagehost/public_html/pixelhomes-com;
GATEWAY_INTERFACE = CGI/1.1;
HTTP_ACCEPT = text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5;
HTTP_ACCEPT_CHARSET = ISO-8859-1,utf-8;q=0.7,*;q=0.7;
HTTP_ACCEPT_ENCODING = gzip;
HTTP_ACCEPT_LANGUAGE = en-us,en;q=0.5;
HTTP_CACHE_CONTROL = no-cache;
HTTP_CONNECTION = close;
HTTP_HOST = www.pixelhomes.com;
HTTP_PRAGMA = no-cache;
HTTP_USER_AGENT = CCBot/1.0 (+http://www.commoncrawl.org/bot.html);
HTTP_X_CC_ID = ccc01-02;
PATH = /bin:/usr/bin;
QUERY_STRING = SortCol=color&SortType=DESC&pageNo=1;
REDIRECT_STATUS = 200;
REMOTE_ADDR = 38.107.191.87;
REMOTE_PORT = 40855;
REQUEST_METHOD = GET;
REQUEST_URI = /search/results.php?SortCol=color&SortType=DESC&pageNo=1;
SCRIPT_FILENAME = /home/iagehost/public_html/pixelhomes-com/search/results.php;
SCRIPT_NAME = /search/results.php;
SERVER_ADDR = 67.19.112.226;
SERVER_ADMIN = webmaster@pixelhomes-com.iagehosting.net;
SERVER_NAME = www.pixelhomes.com;
SERVER_PORT = 80;
SERVER_PROTOCOL = HTTP/1.1;
SERVER_SIGNATURE = Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.pixelhomes.com Port 80
;
SERVER_SOFTWARE = Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635;
SortCol = color;
SortType = DESC;
pageNo = 1;
PHP_SELF = /search/results.php;
REQUEST_TIME = 1283854279;
argv = Array;
argc = 1;
_POST = Array;
HTTP_POST_VARS = Array;
_GET = Array;
HTTP_GET_VARS = Array;
_COOKIE = Array;
HTTP_COOKIE_VARS = Array;
_SERVER = Array;
HTTP_SERVER_VARS = Array;
_FILES = Array;
HTTP_POST_FILES = Array;
_REQUEST = Array;
HTTP_SESSION_VARS = Array;
_SESSION = Array;
site_name = Pixel Homes;
site_URL = http://www.pixelhomes.com/search/;
site_secure_URL = http://www.pixelhomes.com/search/;
upload_image_path = /home/iagehost/public_html/pixelhomes-com/search/images/;
max_image_size = 1000000;
max_image_width = 6000;
thumbnail_width = 400;
upload_image_types = 2;
logo_upload_image_path = /home/iagehost/public_html/pixelhomes-com/search/images/seller_logos/;
logo_max_image_size = 1000000;
logo_max_image_width = 6000;
logo_thumbnail_width = 150;
logo_upload_image_types = 1,2,3; ;
new_vehicle_image_name = #new_vehicle_image_name#;
new_vehicle_upload_image_path = #new_vehicle_upload_image_path#;
new_vehicle_upload_image_types = #new_vehicle_upload_image_types#;
new_vehicle_thumbnail_width = #new_vehicle_upload_image_types#;
new_vehicle_max_image_width = #new_vehicle_upload_image_types#;
new_vehicle_max_image_size = #new_vehicle_upload_image_types#;
pageSize = 8;
db_server = localhost;
db_user = iagehost_easy;
db_pass = nappy6;
db_name = iagehost_pixelportal;
db_prefix = homes_;
track_visitor_limit_time = 60;
search_model_drop_down_array = Array;
conn = Resource id #4;
success = 1;
dealer_id = ;
category = ;
mls = ;
bed = ;
bath = ;
zip = ;
ziprange = ;
zipstring = AND (c.zipcode LIKE '%%' OR ''='');
min_price = ;
max_price = ;
min_year = ;
max_year = ;
keyword = ;
filterKeyword = AND (c.features LIKE '%%' OR ''='')
;
sqlCnt = SELECT COUNT(c.id)
FROM homes_listings AS c
INNER JOIN homes_sellers AS d ON d.id=c.member_id
WHERE
d.status='Active'
AND (c.mls LIKE '%%' OR ''='')
AND (c.category LIKE '%%' OR ''='')
AND (c.bath >= '' OR ''='')
AND (c.beds >= '' OR ''='')
AND (c.price >= '' OR ''='')
AND (c.price <= '' OR ''='')
AND (c.features LIKE '%%' OR ''='')
AND (c.zipcode LIKE '%%' OR ''='')
AND (c.member_id='' OR ''='');
rsCnt = Resource id #9;
numPages = 1;
pagingStart = 0;
stats_month = September;
stats_year = 2010;
sql = SELECT
d.company,
c.member_id,
c.id,
c.beds,
c.bath,
c.price,
c.comments,
c.special,
c.stored,
c.stock,
c.zipcode,
c.laddress,
c.category,
c.mls,
c.acres,
c.sqft,
c.lcity,
c.lstate,
c.lcounty,
c.yrbuilt,
c.schools,
d.zip,
d.address,
d.state_id,
d.city,
d.website,
d.contact_name,
IF(TO_DAYS(NOW())-TO_DAYS(c.stored)<=7,'yes','no') AS is_new_listing,
d.featured AS dealer_featured,
IF(rsr.id IS NULL,'no',rsr.id) AS results_stat_id
FROM homes_listings AS c
INNER JOIN homes_sellers AS d ON d.id=c.member_id
LEFT JOIN homes_results_stat_report AS rsr ON (rsr.stock=c.stock AND rsr.member_id=c.member_id AND rsr.year = '2010' AND rsr.month = 'September')
WHERE
d.status='Active'
AND (c.mls LIKE '%%' OR ''='')
AND (c.category LIKE '%%' OR ''='')
AND (c.bath >= '' OR ''='')
AND (c.beds >= '' OR ''='')
AND (c.price >= '' OR ''='')
AND (c.price <= '' OR ''='')
AND (c.features LIKE '%%' OR ''='')
AND (c.zipcode LIKE '%%' OR ''='')
AND (c.member_id='' OR ''='') ORDER BY c.special ASC , color DESC LIMIT 0,8;
rs = ;
|
| Referer Page |
|
The Query String values (if any) are:
| Name |
Value |
| SortCol |
color |
| SortType |
DESC |
| pageNo |
1 |
The Form values (if any) are:
The Session values (if any) are:
| Name |
Value |
Session string |
|
The Cookie values (if any) are:
Thank you for your understanding and patience.
|