Unable to crop/rotate Unable to crop/rotate
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Unable to crop/rotate

Started by sdstern, March 08, 2010, 09:46:00 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

sdstern

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.

Joachim Müller

Quote from: sdstern on March 08, 2010, 09:46:00 PM
Version 1.5 RC1
Such a version doesn't exist. You probably meant cpg1.5.3 RC.

Quote from: sdstern on March 08, 2010, 09:46:00 PMSo, there are two problems
there is at least a third problem: you need to respect board rules when asking for support.

sdstern

My error. The correct version number is 1.5.3 RC1.

Joachim Müller

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? >:(

sdstern

    * 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

François Keller

Please read carrefully Joachim post and do what he suggest !!!
Quotei.e. post a link to your gallery
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

Quote from: Joachim Müller on March 09, 2010, 02:27:57 PMread 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.


sdstern

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.

Joachim Müller