forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: sdstern on March 08, 2010, 09:46:00 pm

Title: Unable to crop/rotate
Post by: sdstern 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.
Title: Re: Unable to crop/rotate
Post by: Joachim Müller 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 (http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616) when asking for support.
Title: Re: Unable to crop/rotate
Post by: sdstern on March 09, 2010, 01:20:41 pm
My error. The correct version number is 1.5.3 RC1.
Title: Re: Unable to crop/rotate
Post by: Joachim Müller 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? >:(
Title: Re: Unable to crop/rotate
Post by: sdstern 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
Title: Re: Unable to crop/rotate
Post by: François Keller 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
Title: Re: Unable to crop/rotate
Post by: Joachim Müller 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.
Title: Re: Unable to crop/rotate
Post by: sdstern on March 10, 2010, 02:35:44 pm
Gallery is at http://gallery.sterndata.com
Title: Re: Unable to crop/rotate [SOLVED]
Post by: sdstern 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.
Title: Re: Unable to crop/rotate
Post by: Joachim Müller on March 11, 2010, 07:06:09 am
Resolve your threads (http://forum.coppermine-gallery.net/index.php/topic,55415.msg270631.html#msg270631)