[Freerealty] problem with propview.php

[john johnson]

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

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.3 - Release Date: 4/5/2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.3 - Release Date: 4/5/2005