forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: caprifolia on July 27, 2013, 10:35:47 pm

Title: Critical error There was an error while processing a database query
Post by: caprifolia on July 27, 2013, 10:35:47 pm
Yes, I know there is another thread with this same title but I do not believe the issue is the same.

Gallery is located here:  http://www.kathleenballardphotography.com/gallery/

I have upgraded a 1.5x gallery to the latest version and moved it to another server.  I uploaded the new version files via ftp and followed the instructions for moving the database and *most* things work OK but there are a few things that don't that I'd like to get taken care fixed.

Most noticeable is that when one is viewing an individual image clicking the Albums List in the top menu produces the above error.  There are several other things one can do to produce it as well.

I have run database checks and database repairs and all is reported as "OK"

One thing I noticed is that different parts of the database seem to have different names:
gallery.cpg15x_temp_messages and gallery.cpg_categories  and I'm wondering if that could be the cause?  See the highlighted parts of the image.


Title: Re: Critical error There was an error while processing a database query
Post by: Joe Carver on July 30, 2013, 12:08:25 am
Were there any errors when you ran update.php?

Have you run versioncheck.php too?
(please note the some minor errors are normal  and should be ignored)
Title: Re: Critical error There was an error while processing a database query
Post by: caprifolia on July 30, 2013, 08:11:07 pm
I believe I've resolved this error (no clue how but I've downloaded new installation files & re-uploaded 3 times) and messed with it every which way from Sunday.

No errors on update.php
version check:  most files say they are corrupted or edited (they have not been edited) even after the above.  The files were uploaded using CuteFTPPro which I've used for years.  Using automatic and PASV.

Now I have another error calling ImageMagick.
Critical error
Error executing ImageMagick - Return value: 1


Hosting support says the following:  "ImageMagick is installed, but the PHP extension is not. Based on the error I would expect this script is trying to use the ImageMagick binary applications. Are you able to specify a path to ImageMagick in the script's configuration? If so, please use /usr/bin"

The path is correct because I did a test installation using Softalicious (or whatever the installer is called that is on the server) and everything works fine in that case.  I know you don't want to hear that but I wanted to check where the error was ImageMagick or the gallery installation and it seems pretty clear that the problem is with the gallery installation.
Title: Re: Critical error There was an error while processing a database query
Post by: caprifolia on July 30, 2013, 08:29:06 pm
Update: 

I installed a test gallery here:  http://www.kathleenballardphotography.com/test  It works.
I checked the path to ImageMagick on the test gallery and it is blank.
I went back to the original gallery and made that path blank and still get the same error.

No idea what is causing the error but it isn't ImageMagick.
Title: Re: Critical error There was an error while processing a database query
Post by: phill104 on July 30, 2013, 08:36:34 pm
Try switching to GD2

A return code of "1" just indicates a failure. Either the path is incorrect or something in Imagemagik or PHP is not configured correctly. Have you tried your hosts path suggestion? Softalicious could have re-configured the script somewhere, possibly in a .htaccess file, to redirect the setting in the config so we cannot really trust that.
Title: Re: Critical error There was an error while processing a database query
Post by: caprifolia on July 30, 2013, 08:52:21 pm
GD2 works fine
Title: Re: Critical error There was an error while processing a database query
Post by: caprifolia on July 30, 2013, 09:05:23 pm
I've tried every path to ImageMagick imaginable (including anything the host support suggested) and each has thrown the same error.
This gallery was hosted by this same host before; it has just been moved to a new server & something bad happened in the move.


I'm fresh out of ideas here.  Something broke and I can't figure out what it is.


Title: Re: Critical error There was an error while processing a database query
Post by: Αndré on August 21, 2013, 11:48:55 am
As your initial issue is solved and your gallery works as expected with GD2, I'm tagging this thread accordingly. If you still have any issues, please start a new thread after reading the docs and searching the board.