[Freerealty] problem with propview.php

[Patrick Fleming, EA]

Ah... that makes all kinds of problems. Two things to fix ;)
I had copied a working common.php file to common.sample.php and then 
added comments... don't remember if I had seen this problem before or 
not. It will be fixed in the next pre-release.

Welcome to FreeRealty btw.

john johnson wrote:
> Great troubleshooting!
> 
> Actually here is what was happening, the original code from
> common.sample.php line 76 -77:
> 
> /** Maximum number of properties to list at once:
> $properties_per_page = 10;
> 
> I had made the common.sample.php my common.php file, I have now changed  the
> original to close out the comment:
> 
> /** Maximum number of properties to list at once: */
> $properties_per_page = 10;
> 
> Now it is working.
> 
> Thank you,
> 
> John  
> 
> John Johnson,
> IT Support & Web Development
> Mitchell & Company
> john at mitchco.com
> 706.272.4771
> 
> 
> -----Original Message-----
> From: freerealty-bounces at lists.rwcinc.net
> [mailto:freerealty-bounces at lists.rwcinc.net] On Behalf Of Patrick Fleming,
> EA
> Sent: Wednesday, April 06, 2005 2:19 PM
> To: Continuation of Jon Roig's OR 2.x Development
> Subject: Re: [Freerealty] problem with propview.php
> 
> I suspect that you do not have $properties_per_page set in common.php 
> and that you are not displaying errors to the screen/browser.
> Try setting $properties_per_page = "10"; (standard) and I will build 
> that into my install script :)
> 
> john johnson wrote:
> 
>>Thank you for your swift reply,
>>
>>I am using FR-2.9-pre2
>>
>>The site is up on:
>>http://realty1.chattanooga-web.net/or1/index.php
>>
>>Interesting when linking from featured listings: 
>>http://realty1.chattanooga-web.net/or1/propview.php?view=1
>>
>>all is normal, but going to:
>>
>>http://realty1.chattanooga-web.net/or1/propview.php from browse listings
> 
> or
> 
>>from the search page I get the error.
>>
>>Thank you,
>>
>>John 
>>
>>John Johnson,
>>IT Support & Web Development
>>Mitchell & Company
>>john at mitchco.com
>>706.272.4771
>>
>>-----Original Message-----
>>From: freerealty-bounces at lists.rwcinc.net
>>[mailto:freerealty-bounces at lists.rwcinc.net] On Behalf Of Patrick Fleming,
>>EA
>>Sent: Wednesday, April 06, 2005 1:51 PM
>>To: Continuation of Jon Roig's OR 2.x Development
>>Subject: Re: [Freerealty] problem with propview.php
>>
>>Hi John,
>>
>>Which version of FreeRealty do you have running? And is there a web 
>>accessible site that this is on right now?
>>
>>john johnson wrote:
>>
>>
>>>problem with propview.php
>>>
>>>
>>>
>>>Home listings are not displayed, i get this error:
>>>
>>>
>>>
>>>You have an error in your SQL syntax. Check the manual that corresponds to
>>>your MySQL server version for the right syntax to use near '' at line 4
>>>
>>>
>>>
>>>I am using:
>>>
>>>PHP Version 4.3.10 MySql 4.0.21 
>>>
>>>
>>>
>>>Thank you
>>>
>>>
>>>
>>>
>>>
>>>John Johnson,
>>>
>>>IT Support & Web Development
>>>
>>>Mitchell & Company
>>>
>>>john at mitchco.com
>>>
>>>706.272.4771
>>>
>>>
>>>
>>>
>>>
>>>
>>>------------------------------------------------------------------------
>>>
>>>_______________________________________________
>>>FreeRealty mailing list
>>>FreeRealty at lists.rwcinc.net
>>>http://lists.rwcinc.net/mailman/listinfo/freerealty
>>>FreeRealty web site: http://www.rwcinc.net/freerealty
>>
>>_______________________________________________
>>FreeRealty mailing list
>>FreeRealty at lists.rwcinc.net
>>http://lists.rwcinc.net/mailman/listinfo/freerealty
>>FreeRealty web site: http://www.rwcinc.net/freerealty
>>
> 
> _______________________________________________
> FreeRealty mailing list
> FreeRealty at lists.rwcinc.net
> http://lists.rwcinc.net/mailman/listinfo/freerealty
> FreeRealty web site: http://www.rwcinc.net/freerealty
>