forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: dmdemore on December 22, 2008, 07:18:41 pm

Title: Critical Error
Post by: dmdemore on December 22, 2008, 07:18:41 pm
I didn't know where to post this so hope I found the  right place.

my url is
http://galleries.firthessence.net/JustColin/index.php

it is coppermine 1.4

Today I was batch uploading some files, got that done. Then went to edit the files (to name them). I got to the right page and set the drop down from 25 to 100 at a time. Got that done, then needed to go to the next set of photos (101 - 200) but after I clicked the link to do so and was waitng I was wanting to shut other pages I had opened but hit the wrong X and the gallery closed too.  When I went back (reopened it) I got

CRITICAL ERROR WHILE PROCESSING A DATABASE QUERY





Here are the 2 messages:

While executing query "SELECT * FROM cpg_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 10" on 0

mySQL error: Got error -1 from storage


AND






Title: Re: Critical Error
Post by: dmdemore on December 22, 2008, 07:23:40 pm
The forum will not allow me to post the whole of the second message as it is too large, so I will post some of it here.



USER:
------------------
Array
(
    [ID] => c71b1791fd51e51bbf7af1bf0beb2ce5
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => diane
    [groups] => Array
        (
           
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

Title: Re: Critical Error
Post by: Hein Traag on December 22, 2008, 07:25:50 pm
Don't post debug output unless asked to do, it clutters up the board pretty quickly.
You have 1.4.16 at your site. Upgrade first to 1.4.19

Does not seem to be a cpg error but more related to MySql.
Title: Re: Critical Error
Post by: Joachim Müller on December 22, 2008, 08:12:07 pm
Searching for the error message (http://forum.coppermine-gallery.net/index.php?action=search2;search=mySQL%20error%20Got%20error%20-1%20from%20storage%20engine) you got is dead easy. Has been asked and answered. As Hein suggested: not a coppermine issue. Ask your webhost for support. As Hein suggested as well: upgrade!!!
Title: Re: Critical Error
Post by: dmdemore on December 22, 2008, 08:30:12 pm
Apologies for posting a redundant thread. I was a bit desperate. Last year I lost a 2 yr old forum and now this gallery with over 16,000 pics.

Appreciate the help and pointers to the original discussion. Unfortunately, I have no idea what any of that means.

(I did do the MySQL and nothing changed)

I'll try the upgrade and cross my fingers. The last time I upgraded one of these programes I lost all the content and had to start completely over.