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: Unable to crop/rotate  (Read 8643 times)

0 Members and 1 Guest are viewing this topic.

sdstern

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • My Picture Gallery
Unable to crop/rotate
« on: March 08, 2010, 09:46:00 pm »

Version 1.5 RC1

I just uploaded a picture then clicked CROP AND ROTATE.  The preview screen does not show any image.  Attempting to rotate and save anyway generates this in the error log:

Mar 08, 2010 at 03:40 PM - While executing query 'UPDATE cpg11d_pictures
                      SET pheight = ,
                          pwidth = ,
                          filesize = 4096,
                          total_filesize = 16284
                      WHERE pid = '571'' in pic_editor.php on line 200 the following error was encountered:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
                          pwidth = ,
                          filesize = 4096,' at line 2
---
So, there are two problems:  (1) Nothing shows up in the crop/rotate edit window and (2) it allows me to try to save invalid data.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to crop/rotate
« Reply #1 on: March 09, 2010, 09:27:01 am »

Version 1.5 RC1
Such a version doesn't exist. You probably meant cpg1.5.3 RC.

So, there are two problems
there is at least a third problem: you need to respect board rules when asking for support.
Logged

sdstern

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • My Picture Gallery
Re: Unable to crop/rotate
« Reply #2 on: March 09, 2010, 01:20:41 pm »

My error. The correct version number is 1.5.3 RC1.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to crop/rotate
« Reply #3 on: March 09, 2010, 02:27:57 pm »

Still not a valid support request, as I already told you: read up the board rules section that I have refered to above and do as suggested there, i.e. post a link to your gallery for christ's sake! Do I have to fall on my knees and beg? >:(
Logged

sdstern

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • My Picture Gallery
Re: Unable to crop/rotate
« Reply #4 on: March 10, 2010, 01:59:41 am »

    * Coppermine version
1.5.3 RC 1
    *  Server OS
 Linux / Fedora 12, 2.6.32.9-67.fc12.i686
    * Web Server Software (Apache, IIS etc.)
Apache2
    * GD1, GD2 or ImageMagick Test
ImageMagick
    * PHP Version
PHP 5.3.1 (cli) (built: Nov 20 2009 12:52:06)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2009 Zend Technologies
    with eAccelerator v0.9.6, Copyright (c) 2004-2010 eAccelerator, by eAccelerator
    * BB Integration / Bridging (if any)
none
    * Themes fully tested (by fully tested, we mean as many different features as possible using that theme)
curve
    * Client OS and Browser(s)
Linux / Fedora 12, Firefox 3.5.8
    * Fresh install or upgrade (if upgrade, from which version of cpg)
Upgrade 1.4.26
    * Source: did you install using a package (if yes: which one), a SVN tarball, a SVN checkout (if yes: which revision)
zip package from coppermine.net
    * Browser language / tested coppermine language
En/E
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Unable to crop/rotate
« Reply #5 on: March 10, 2010, 07:18:20 am »

Please read carrefully Joachim post and do what he suggest !!!
Quote
i.e. post a link to your gallery
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to crop/rotate
« Reply #6 on: March 10, 2010, 12:46:11 pm »

read up the board rules section that I have refered to above and do as suggested there, i.e. post a link to your gallery
Users who ignore what I say get ignored by me as well, as I can not tolerate laziness if you expect free support from me. In other words: I'm out of this thread as far as support is concerned and will ignore your future requests for help.
Logged

sdstern

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • My Picture Gallery
Re: Unable to crop/rotate
« Reply #7 on: March 10, 2010, 02:35:44 pm »

Logged

sdstern

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • My Picture Gallery
Re: Unable to crop/rotate [SOLVED]
« Reply #8 on: March 10, 2010, 06:56:56 pm »

Bad permissions on one of the directories under albums/. I did a chown -R apache:apache albums/ and the problem went away. I suspect it was the directory albums/edit.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to crop/rotate
« Reply #9 on: March 11, 2010, 07:06:09 am »

Logged
Pages: [1]   Go Up
 

Page created in 0.144 seconds with 19 queries.