[Freerealty] problem with propview.php

Thu Jul 7 03:32:19 MST 2005

Hi Patrick

Here is the url,

http://showplacerealty.org/residential/

It is now set to use folders and everything is working. This is a project I
am sub contracting for an ad agency and can only work onsite, Mondays and
Wednesdays. 

Thank you for your assistance. 

By the way, we did research quite a few realty packages and yours was the
best for features and ease of putting the code into a custom design. Thanks
for all your efforts and hard work.

John Johnson
Web Design & Development
WSDNPO.COM
johnjohnson at wsdnpo.com
phone: 706.935.8564
fax: 706.935.9059

-----Original Message-----
From: freerealty-bounces at lists.rwcinc.net
[mailto:freerealty-bounces at lists.rwcinc.net] On Behalf Of Patrick Fleming
developer FreeRealty
Sent: Wednesday, July 06, 2005 8:15 PM
To: Continuation of Jon Roig's OR 2.x Development
Subject: Re: [Freerealty] problem with propview.php

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Oh... I know this one!
What was the url again?

john johnson wrote:
> Another challenge,
> 
> When using folders for images everything works as it should (using agent
> login) 
> 
> When using db for images I get broken links where the pictures should be.
> Images are in the db with number and owner OK.
> 

> 
> -----Original Message-----
> From: john johnson [mailto:john at mitchco.com] 
> Sent: Wednesday, July 06, 2005 2:00 PM
> To: 'Continuation of Jon Roig's OR 2.x Development'
> Subject: RE: [Freerealty] problem with propview.php
> 
> This worked for prop number, does it also have to change for owner, also
> agentnumb and owner?
> 

There should be an agent number placed into the db... I must have missed
it when switching things over to a function. I will have to look through
the code a bit to make it work. If I remember right the agent id only
affects an agent trying to delete an image... but it may not be used at
all. I'll have to rummage through it a bit :)

> 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
> developer FreeRealty
> Sent: Wednesday, July 06, 2005 1:30 PM
> To: Continuation of Jon Roig's OR 2.x Development
> Subject: Re: [Freerealty] problem with propview.php
> 
> 
> 
> john johnson wrote:
> 
>>>Hi Patrick,
>>>
>>>I erased all the files on the site along with the database. Loaded the
>>>2.9.0.4 files, reinstalled the database and put up my coded common.php
> 
> file
> 
>>>with images set for db.
>>>
>>>Adding a listing, then adding images I get the "images uploaded" text in
> 
> the
> 
>>>admin, but when viewing the listings I get the Photo not available.
>>>
>>>Here is the listing from the database tbl_Files:
>>>
>>>  id_files bin_data description filename filesize filetype height width
>>>prop_num owner thumb thumb_size thumb_filetype image_order 
>>>      1 [BLOB - 46.8 KB] test house_sample1.jpg 46989 image/pjpeg NULL
> 
> NULL
> 
>>>0 0 [BLOB - 2.4 KB] 2375 image/pjpeg NULL 
>>>      2 [BLOB - 41.8 KB] test 2 house_sample2.jpg 41867 image/pjpeg NULL
>>>NULL 0 0 [BLOB - 2.4 KB] 2350 image/pjpeg NULL
>>>
> 
> 
> Crap. I thought this was fixed... or maybe this is a different problem
> than we fixed :( the upload isn't setting a property number or owner....
> it won't display properly without these two fields. You are doing this
> in admin/admin.php right?
> 
> All right on line 196 of admin.php change this section ...
> "propnum"=>"$propnum", to "propnum"=>"$edit",
> Let me know if that's it... and I'll get the fix out.
> 
> 
> 0 0 [BLOB - 2.4 KB] 2375 image/pjpeg NULL
> ^ ^
> 
> 
>>>I hope this will be easier to troubleshoot and I can get it 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
>>>developer FreeRealty
>>>Sent: Wednesday, July 06, 2005 11:47 AM
>>>To: Continuation of Jon Roig's OR 2.x Development
>>>Subject: Re: [Freerealty] problem with propview.php
>>>
>>>
>>>
>>>john johnson wrote:
>>>
>>>
>>>>>Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
>>>
>>>result
>>>
>>>
>>>>>resource in
>>>>>
>>>
>>>
>
/home/hsphere/local/home/showplac/showplacerealty.org/residential/admin/admi
> 
>>>>>n.php on line 399
>>>>>
>>>>>Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
>>>
>>>result
>>>
>>>
>>>>>resource in
>>>>>
>>>
>>>
>
/home/hsphere/local/home/showplac/showplacerealty.org/residential/propview.p
> 
>>>>>hp on line 111
>>>>>
>>>
>>>
>>>In 2.9 pre 3 the option to store images in either the db or folders was
>>>introduced. You probably need to do step 4 here:
>>>http://showplacerealty.org/residential/doc
>>>Also make sure that if you are going to use the folders method that the
>>>folders are writable by the web server - by default these are
>>>/images/listings and /images/agents.
>>>Note that the exportimages.php script does *not* drop images from the
>>>database, it merely pulls the image data from the database and places it
>>>in the corresponding images folder.
>>>
>>>
>>>
>>>
>>>>>Originally setting up version 2.9 pre 2 and having it run properly,
when
>>>>>upgrading to 2.9.0.4 I get the above error messages in regard to the
>>>>>thumbnails and no thumbnail show.
>>>>>
>>>>>When using browse listings or search homes the thumbnail shows up.
>>>>>
>>>>>Also I was  not able to use the install.php for any version other than
> 
> 2.9
> 
>>>>>pre 2. All the newer versions reported that I didn't have a writable
>>>
>>>folder,
>>>
>>>
>>>>>however 2.9 pre 2 didn't have any problem writing to the folder.
>>>
>>>
>>>install.php should not be used - and probably won't work on existing
>>>folder/common.php file. Use the upgrade scripts in /upgrades instead.
>>>
>>>
>>>
>>>
>>>>>Site is  http://showplacerealty.org/residential/index.php
>>>>>
>>>>>Thanks for any help!
>>>
>>>
>>>Hope I was :)
>>>
>>>
>>>
>>>>>
>>>>>John Johnson,
>>>>>IT Support & Web Development
>>>>>Mitchell & Company
>>>>>john at mitchco.com
>>>>>706.272.4771
>>>>>
>>>>>
>>>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (Cygwin)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCzHQPGzHR7DxVKWIRAhuAAJwO62DBQa/tFxj8QXQAZ4Q9VFTT6ACff34l
YBMeqgZ3O3EP0zXEAKZW6Qw=
=S6dO
-----END PGP SIGNATURE-----

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.9/42 - Release Date: 7/6/2005

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.9/42 - Release Date: 7/6/2005