[Freerealty] problem with propview.php

Thu Jul 7 06:37:56 MST 2005

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

john johnson wrote:
> Hi Patrick
> 
> Here is the url,
> 
> http://showplacerealty.org/residential/
> 
> It is now set to use folders and everything is working. This is a project I
> am sub contracting for an ad agency and can only work onsite, Mondays and
> Wednesdays. 

That does make it a bit harder to tweak at it when neccessary :)

> 
> Thank you for your assistance. 

Glad to know that we (myself and others on the list) could help.
> 
> By the way, we did research quite a few realty packages and yours was the
> best for features and ease of putting the code into a custom design. Thanks
> for all your efforts and hard work.

Trying to say that it's "simple"? ;) I'm glad it works for you.

BTW as far as images go, I did make some changes/fixes to admin.php AND
includes/func.php on the way to some expanded functionality. The changes
are in the latest snapshot, but aren't packaged as a release. If I get
time today, I have to run through the code to make sure nothing is
substantially broken and turn it out.

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

iD8DBQFCzTAzGzHR7DxVKWIRAukgAJ9j/mu0J5Yfktnw29CtFUXD0qvtKACggJiS
ITNmi2z+sgGyNujLJYqf0g8=
=rik4
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3383 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.rwcinc.net/pipermail/freerealty/attachments/20050707/59c8c566/smime.bin