[Freerealty] problem with propview.php

Wed Jul 6 11:31:05 MST 2005

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.

John Johnson,
IT Support & Web Development
Mitchell & Company
john at mitchco.com
706.272.4771

-----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?

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

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

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

iD8DBQFCzBUXGzHR7DxVKWIRAjVQAJ4kn6/QvO0iF1ok0U4Wn/p36Fc3mgCgrhQG
DIGw4WRYokgK4azvzmonvgg=
=7jbB
-----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

-- 
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