Random & inconsistent results page

9/18/2012 2:10 pm | #1 PaulBeta Tester

I've used the DA search wizard to build my search and results page.
For reasons unknown, my results page is responding inconsistently, occasional throwing a server shown below;

It works much of the time, however the query takes anything between 1 sec to over 2 minutes to resolve and return a response

html:

Server error!

The server encountered an internal error and was unable to complete your request.

Error message: 
Premature end of script headers: GalleryList.php

I've attached the page as im not sure where to start looking - simply because it works as expected sometimes!

The search page is here;

http://www.crazyplumhomes.co.uk/d/property/index.php

I'm using a query in my results page that joins 12 tables - is that excessive? I've no idea.

Any help appreciated.

I forgot to add, theres only a few test records in my DB and the results query is not complex by any means. So im not exactly pushing full throttle on server /mysql resource.

Thanks.

Attached Files

GalleryList.zip

9/19/2012 8:15 am | #2 Jason ByrnesWebAssist

What happens if you strip out all java scripting?

when i test your page, my javascript error console shows a number of problems:

yanonekaffeesatz-light-webfont.woff:-1Resource interpreted as Font but transferred with MIME type text/plain.
ubuntu-light-webfont.woff:-1Resource interpreted as Font but transferred with MIME type text/plain.
top-links.pngGET top-links.png 404 (Not Found)
top-links1.pngGET top-links1.png 404 (Not Found)
script.js:307[cycle] terminating; zero elements found by selector
script.js:307[cycle] terminating; zero elements found by selector

viewing source of your page, it looks like you are using a number of HTML 5 techniques, but you use the XHTML doctype:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

9/19/2012 1:39 pm | #3 PaulBeta Tester

Many thanks to Ray for his time and effort explaining and showing where this was going wrong.

It was an inefficient and poorly structured My SQL query that was causing the issue.

Problem resolved.

9/20/2012 10:05 pm | #4 PaulBeta Tester

Close to a full solution...

Ray, i've attempted to add another couple of JOINS to the following sql you showed me recently;

php:

<?php

    

mysql_select_db($database_HouseyConnect, $HouseyConnect);

$query_WADApropsubtbl = "SELECT hopicfolder, hopicimagename, propRooms, propType, propmaintbl.propVal, propSDesc FROM propmaintbl 

LEFT OUTER JOIN homepics ON PropPrimePic = hopicsidx

LEFT OUTER JOIN propRooms ON propBeds = propRoomCnt

LEFT OUTER JOIN propstyle ON propType=PropStyleCnt

LEFT OUTER JOIN propval ON propmaintbl.propVal = propValCnt

WHERE propRID = " . $row_WADApropmaintbl['propRID'];

$WADApropsubtbl = mysql_query($query_WADApropsubtbl, $HouseyConnect) or die(mysql_error());

$row_WADApropsubtbl = mysql_fetch_assoc($WADApropsubtbl);

    ?>

The first two are good, but 3 & 4 return the error; Unknown column 'propValCnt' in 'where clause' and Unknown column 'propSaleCnt' in 'where clause' instead of the results page, when i apply the respective search criteria.

I've followed the same principles as 1&2 - well at least i thought i had;

Join TABLE1 ON TABLE2_TARGET_FIELD_NAME = TABLE1_INDX_FIELD_MATCHING_TABLE2_TARGET_FIELD_NAME

Not sure why failing?

9/21/2012 9:43 am | #5 Jason ByrnesWebAssist

i would need to see the structure for the tables you are using in this query to be able to troubleshoot.

when creating join queries, it is a good practice to include the table name in the ON clause:

INNER JOIN table2 ON table1.KeyColumn = table2.RelationColumn

You may have better luck creating your query using a visual query builder like SQLYog or Navicat

9/22/2012 8:35 am | #6 PaulBeta Tester

Thanks Jason,

I've resolved.

I needed to enter the search form fields into the Server Behaviour Config page by hand in the DA Search Wizard.

I get that these are enterable when thwe wizard is run first time, however i think it would be useful to have these selectable post-edit too!
I assume it maybe difficult, since they exist on a different page tho!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Random & inconsistent results page

9/18/2012 2:10 pm | #1 PaulBeta Tester