forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: sec187 on July 30, 2010, 05:30:50 pm

Title: Critical error, There was an error while processing a database query.
Post by: sec187 on July 30, 2010, 05:30:50 pm
Coppermine Photo Gallery v1.4.25


Any help with this is greatly appreciated.  This just popped up on the home page to my gallery, the links on the gallery still work...
  THANK YOU!!!


While executing query "SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 15)GROUP BY a.aid" on 0

mySQL error: Out of memory (Needed 1046672 bytes)


USER:
------------------
Array
(
    [ID] => b62587fdea9bc96e85b7d632811c8dda
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [name] => CLICK ONE
    [search] => Array
        (
            [search] => sin
            [album] => search
            [title] => on
            [newer_than] =>
            [caption] => on
            [older_than] =>
            [keywords] => on
            [type] => AND
            [filename] => on
            [params] => Array
                (
                    [title] => on
                    [caption] => on
                    [keywords] => on
                    [filename] => on
                )

        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => god
    [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] => 10
    [num_URI_upload] => 10
    [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
)

==========================
Queries:
------------------
Array
(
   
Title: Re: Critical error, There was an error while processing a database query.
Post by: Phill Luckhurst on July 30, 2010, 05:50:34 pm
Please, always post a link to your site with every new support request.

Also, don't post the debug unless asked, we can see it when you post a link so it just leaves a mess.

Finally, upgrade first. The current version is 1.4.27 or better still, make the jump to 1.5.x
Title: Re: Critical error, There was an error while processing a database query.
Post by: sec187 on July 30, 2010, 06:04:06 pm
Ok, sorry,

http://www.bostonsgraffitighosts.com/gallery/index.php

so a upgrade will fix this?
Title: Re: Critical error, There was an error while processing a database query.
Post by: Jeff Bailey on July 30, 2010, 09:39:44 pm
The upgrade is required to get support.
Title: Re: Critical error, There was an error while processing a database query.
Post by: Phill Luckhurst on July 30, 2010, 09:57:06 pm
It may well fix it but as Jeff says, we will only support up to date installs. It is not because we are grumpy gits, it is because we don't want you to get hacked and all our efforts will go to waste. It may also be that the later version has fixed something already so we don't want to do the work in fixing a bug twice. You will be amazed how many people argue about a simple upgrade and our reasons. Odd really as they are there to help.