[Freerealty] problem with propview.php

[Patrick Fleming, EA]

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
>