Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Resize Full Size?  (Read 4396 times)

0 Members and 1 Guest are viewing this topic.

wenzday01

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Resize Full Size?
« 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.
« Last Edit: November 06, 2004, 06:10:11 pm by TranzNDance »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Resize Full Size?
« Reply #1 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
Logged

wenzday01

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Resize Full Size?
« Reply #2 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?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Resize Full Size?
« Reply #3 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
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Resize Full Size?
« Reply #5 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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

wenzday01

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Resize Full Size?
« Reply #6 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Resize Full Size?
« Reply #7 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
Logged

Zeitgeist

  • Coppermine regular visitor
  • **
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 71
Re: Resize Full Size?
« Reply #8 on: November 06, 2004, 06:05:46 pm »

That command just helped me out a lot, thanks
Logged
I love GauGau!
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 18 queries.