[Freerealty] problem with propview.php

Wed Jul 6 17:15:12 MST 2005

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Oh... I know this one!
What was the url again?

john johnson wrote:
> Another challenge,
> 
> When using folders for images everything works as it should (using agent
> login) 
> 
> When using db for images I get broken links where the pictures should be.
> Images are in the db with number and owner OK.
> 

> 
> -----Original Message-----
> From: john johnson [mailto:john at mitchco.com] 
> Sent: Wednesday, July 06, 2005 2:00 PM
> To: 'Continuation of Jon Roig's OR 2.x Development'
> Subject: RE: [Freerealty] problem with propview.php
> 
> This worked for prop number, does it also have to change for owner, also
> agentnumb and owner?
> 

There should be an agent number placed into the db... I must have missed
it when switching things over to a function. I will have to look through
the code a bit to make it work. If I remember right the agent id only
affects an agent trying to delete an image... but it may not be used at
all. I'll have to rummage through it a bit :)

> 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 1:30 PM
> To: Continuation of Jon Roig's OR 2.x Development
> Subject: Re: [Freerealty] problem with propview.php
> 
> 
> 
> 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

iD8DBQFCzHQPGzHR7DxVKWIRAhuAAJwO62DBQa/tFxj8QXQAZ4Q9VFTT6ACff34l
YBMeqgZ3O3EP0zXEAKZW6Qw=
=S6dO
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pat.vcf
Type: text/x-vcard
Size: 219 bytes
Desc: not available
Url : http://lists.rwcinc.net/pipermail/freerealty/attachments/20050706/062718aa/pat.vcf