forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: wenzday01 on March 16, 2004, 06:36:48 am

Title: Resize Full Size?
Post by: wenzday01 on March 16, 2004, 06:36:48 am

I've been searching the forums high and low for the past hour or so, and I can't seem to find a solution to my problem.

I've uploaded pics to my photo album, but I've decided that I want the maximum dimension of a full size to be 800px instead of the current 500px.  I tried to overwrite the file that I had, but when I clicked for the full size pop-up, all I got was a compressed version of my new file (800px is compressed to fit a 500px frame).  Is there any way to resize the pop-up window?

I would really appreciate it if anyone can help. Thanks.

Title: Resize Full Size?
Post by: Joachim Müller on March 16, 2004, 08:43:33 am

change the setting in coppermine config first. Then use "resize pictures" from the admin menu. If a pic is only available in 500*x in the first place, you can't blow it up to have 800*x. Replacing the file on the server (albums directory) will only replace the pic, but not the db entry.

GauGau

Title: Resize Full Size?
Post by: wenzday01 on March 16, 2004, 03:48:34 pm

I've already done what you said, but my new 800*x only fills up a 500*x window frame.  So how do I change the db entry?

Title: Resize Full Size?
Post by: Joachim Müller on March 16, 2004, 05:41:03 pm

give a deep link to the pic in question (and a user name and password if necessary).

GauGau

Title: Resize Full Size?
Post by: wenzday01 on March 16, 2004, 08:01:55 pm

Here are three of them:

http://www.thismorning.org/photo//displayimage.php?pos=-869
http://www.thismorning.org/photo//displayimage.php?pos=-868
http://www.thismorning.org/photo//displayimage.php?pos=-866

Title: Resize Full Size?
Post by: Casper on March 16, 2004, 09:42:26 pm

How many pics did you replace.  
The problem is you replaced the original with bigger copies, but the database thinks they are the size you originally uploaded, so that is the size it displays.
You are going to have to update the size details for each pic you changed.
To do this, you need to use your database tool, i.e., phpMyAdmin, and edit them in the pictures table.

If you did all the pics, and they were and are now all the same size, there is probably a single query you can use to do it in one go, but I'm no mysql guru.

Title: Resize Full Size?
Post by: wenzday01 on March 16, 2004, 10:59:49 pm

Thanks for your reply.  I looked through phpMyAdmin and changed the width and height in the database.

And I know that this isn't a mysql forum, but I was wondering if there's anyway to change it for all my pictures at once.

Title: Resize Full Size?
Post by: Joachim Müller on March 17, 2004, 08:59:48 am

If all the pics are the same size, you could run a query in phpMyAdmin like this

Quote

UPDATE `cpg11d_pictures` SET `pwidth` = '600', `pheight`='800' WHERE `aid` = '23';

orange: you might have to change this to match your coppermine table prefix
red: change this to the album number the pics are in.

You may as well replace the WHERE clause with another db field as criteria (e.g. Filepath or something). As this will run through your whole database in one go, be sure to make a backup of your db before experimenting with it! If you don't feel comfortable with mySQL queries, I suggest you don't mess with it at all...

GauGau

Title: Re: Resize Full Size?
Post by: Zeitgeist on November 06, 2004, 06:05:46 pm

That command just helped me out a lot, thanks