PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro How Do I...? (http://www.photopost.com/forum/photopost-pro-how-do-i/)
-   -   Switching to no medium-size photos (http://www.photopost.com/forum/photopost-pro-how-do-i/110044-switching-no-medium-size-photos.html)

memobug September 27th, 2004 09:36 PM

Switching to no medium-size photos
 
I would like to make a change in the way my photopost gallery operates so that I will only have a single size photo.

I have been running like this for years:

Max allowable image width=800
Max allowable image height=640
Trigger medium height & width=641
Save and display medium and large images?=yes

Q1: If I turn off "Save and display medium and large images?" what happens to existing medium size images?

Q2: Will I need to rebuild images or manually delete intermediate sizes from the database, or what?

Regards

Matt

Chuck S September 28th, 2004 12:43 PM

Try setting medium to 0 and then run a rebuild medium scan.

I would have to do further testing to see the ramifications of doing something like this midstream on how it effects or the way to get rid of mediums

memobug September 28th, 2004 08:32 PM

Quote:

Originally Posted by omegatron
I would have to do further testing to see the ramifications of doing something like this midstream on how it effects or the way to get rid of mediums

I would appreciate it!

Regards,

Matt

MonchaVX January 2nd, 2005 09:45 PM

Any word on this?? I'd sure like to rid my site of the medium images.

Chuck S January 3rd, 2005 10:22 AM

You can have no medium is you set medium threshold to 0 but your not going to get rid of mediums already built unless you edit the sql in the photos table

memobug January 4th, 2005 02:15 AM

Hi Chuck,

Do you mean no NEW mediums will be generated but the existing mediums and links to them will remain?

Regards,

Matt

Chuck S January 4th, 2005 10:27 AM

I mean if you set medium to 0 no mediums will be created for new images correct but as always existing mediums will show

If your familar with sql you can use phpmyadmin and issue a command to set all mediums to 0 so they do not display

UPDATE photos SET medium='0' WHERE medium != '0'

coloradok5 January 5th, 2005 05:09 PM

Quote:

Originally Posted by omegatron
I mean if you set medium to 0 no mediums will be created for new images correct but as always existing mediums will show

In addition you would aslo have to set "Save and display medium and large images?=no" Correct?

Michael P January 5th, 2005 05:16 PM

No - that option is just for saving thumbnails and no medium or large images.

coloradok5 January 5th, 2005 05:23 PM

Quote:

Originally Posted by Michael P
No - that option is just for saving thumbnails and no medium or large images.

OK, thanks, I kind of thought that but wasn't sure, I like not having the extra image stored plus it gives the gallery a cleaner look.

Pauline Kenny March 8th, 2005 09:39 PM

Have the field names changed for 5.0?
 
I have just upgraded to 5.0 and would like to get rid of my medium photos. Has this SQL query changed with the new release?

UPDATE photos SET medium='0' WHERE medium != '0'

I do not see a "medium" field in the photos table. I see 3 fields: medwidth, medheight, medsize.

Second Question:
Once I run this query to change the fields for the medium images, do I then go up to the server and delete all images in all medium folders?

Thanks!!

Michael P March 9th, 2005 06:56 AM

You would need to run:

UPDATE photos SET medwidth=0,medsize=0,medheight=0 WHERE medsize > 0;

And then you could remove the files withing the medium folders, yes.

Pauline Kenny March 9th, 2005 10:29 AM

Thanks - that did it!


All times are GMT -5. The time now is 07:24 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97