Critical Error Critical Error
 

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

Main Menu

Critical Error

Started by dmdemore, December 22, 2008, 07:18:41 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

dmdemore

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







dmdemore

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
        (
           
  • => 1
            )

        [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
    )


Hein Traag

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.

Joachim Müller

Searching for the error message 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!!!

dmdemore

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.