[Freerealty] problem with propview.php

Wed Jul 6 10:09:15 MST 2005

Hi Sean,

Thanks so much.

Using the main admin to add photos did  not work for viewing. The pictures
did upload to the db and when I changed to use folders the images did upload
to the folders file, just nothing showed up.

When using the agent login to upload pictures it all works and the pictures
show up.

Shouldn't this work from the main admin as well?

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 Sean
Sent: Wednesday, July 06, 2005 1:01 PM
To: Continuation of Jon Roig's OR 2.x Development
Subject: Re: [Freerealty] problem with propview.php

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/adm
i
>  
>
>>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-----
>
>  
>

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