coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 pnCPG (Coppermine for postNuke/Zikula) => Topic started by: Eddy17 on December 20, 2005, 09:54:06 AM

Title: "There was an error while processing a database query"
Post by: Eddy17 on December 20, 2005, 09:54:06 AM
Hi

my gallery suddenly doesnt work any more, and it showed this error:

USER:
------------------
Array
(
    [ID] => 9bb4705e221a8c59a269e72f4e581ad8
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_group] => 1
    [user_active] => YES
    [user_name] => Eddy
    [user_password] => ********
    [user_lastvisit] => 2005-12-20 09:42:28
    [user_regdate] => 2005-01-03 20:51:42
    [user_group_list] => 2
    [user_email] => Eddy23d@aol.com
    [user_website] => chaos-klasse.de.tf
    [user_location] => Hölle auf Erden
    [user_interests] => Pardy, Volleeeeball, theatre
    [user_occupation] => DJ
    [user_actkey] => c1bf370dcf09d455dc12167840c24bcb
    [disk_max] => 51200
    [disk_min] => 51200
    [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] => 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] => 51200
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
           
Title: Re: "There was an error while processing a database query"
Post by: Joachim Müller on December 20, 2005, 01:58:35 PM
that's not an error message, but the debug_ouput. Post the actual error message and/or a link to your site.
Title: Re: "There was an error while processing a database query"
Post by: Eddy17 on December 20, 2005, 06:07:48 PM
There was an error while processing a database query.


While executing query "SELECT count(*) FROM galerie_pictures as p, galerie_albums as a WHERE p.aid = a.aid AND category >= 10000" on 0

mySQL error: Can't open file: 'galerie_pictures.MYI'. (errno: 145)



Datei: /usr/export/www/vhosts/funnetwork/hosting/chaosklasse/galerie/include/functions.inc.php - Zeile: 105



That's it

Thanks
Title: Re: "There was an error while processing a database query"
Post by: Nibbler on December 20, 2005, 06:20:53 PM
http://forum.coppermine-gallery.net/index.php?topic=10409.0
Title: Re: "There was an error while processing a database query"
Post by: Eddy17 on December 20, 2005, 09:38:35 PM
Thanks
sorry, Im new and didnt find the link

bfn