[Freerealty] problem with propview.php

[john johnson]

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

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.9/39 - Release Date: 7/4/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