[Freerealty] problem with propview.php

[Sean]

Just did a quick check, and here is what I've found, when uploading with 
admin, the information for prop_num and owner is not being passed. If 
you look at the table you will see both those fields are filled with a 
zero whereas those uploaded with agentadmin.php show the property and 
agent id's.

john johnson wrote:

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