[Freerealty] problem with propview.php

[Sean]

Hi,

I've submitted this question previously and intended on following up 
when I had a firm grasp on it, but maybe this info will help John.

When I login as admin and upload a file, the file is reported to be 
uploaded but I get a "Photo Not Available" when previewing. When I use 
the agent login, the image is uploaded and displays correctly.

The site I am building is for a single agent so it made sense to have 
just an admin login and I had customized the admin listing interface 
(add/edit) for Canada. So for a work around, I created an agent my user 
uses to upload images.

I hope this helps.

Sean.

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
>
>
>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
>
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>
>
>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
>
>iD8DBQFCy/zxGzHR7DxVKWIRAvqNAKCuSe1TQ2miz76vcf37BxWn6CoKVQCgjzYA
>b1rx4j1NyB+dp57is/ewkak=
>=KSIg
>-----END PGP SIGNATURE-----
>
>  
>