[Freerealty] problem with propview.php

[Sean]

That worked for me! Thanks.

Patrick Fleming developer FreeRealty wrote:

>-----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-----
>  
>
>_______________________________________________
>FreeRealty mailing list
>FreeRealty at lists.rwcinc.net
>http://lists.rwcinc.net/mailman/listinfo/freerealty
>FreeRealty web site: http://www.rwcinc.net/freerealty
>