Print

[jlovenet]

I keep getting this

Notice: Undefined index: debug_mode in /home/jloven/public_html/picturegallery/include/functions.inc.php on line 101
Fatal error :
There was an error while processing a database query

? i switched it from my old domain to a new domain and now it's all messed up

http://j-love.net/picturegallery

what do i do?

the config is right, i triple checked it

[Joachim Müller]

enable debug_mode to check what query actually fails.

GauGau

[jlovenet]

and i would enable that how?

sorry i'm confused w/ php.

[Joachim Müller]

enable debug mode in coppermine config (at the very bottom of the screen). If you can't go to config at all, use phpMyAdmin, browse the coppermine config table (cpg11d_config or similar) and set "debug_mode" from "0" to "1".

GauGau

[jlovenet]

i changed it and it's still saying the same thing?

[Joachim Müller]

You should see details which query actually fails. Please post a screenshot.

GauGau

[jlovenet]

it doesn't say,

i just reinstalled a new version and i'm uploading eah picture manually..

is there a way to move the albums into the new directory? or i really do have to do each one, one by one?

[Joachim Müller]

I don't get your point. You're recommended to upload/move around pics with ftp and then use batch-add. Defining the albums dir to be outside of the coppermine folder is possible, but not recommended. You can do so in coppermine config.

GauGau

[peter_hun]

Hi,

I've got the same problem:

Notice: Undefined index: debug_mode in /disk/raid/t/e/myhostname/pictures/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query

What's went wrong???

Debug info:
USER:
------------------
Array
(
    [ID] => 9d1a48ae4c638cfeb0c50df8ce0eeec8
    [am] => 1
    [liv] => Array
        (
           

• => 3
[1] => 2
            [2] => 1
            [3] => 127
            [4] => 126
        )

)

==========================
USER DATA:
------------------
Array
(
   

[user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => ********
    [user_password] => ********
    [user_lastvisit] => 2004-07-16 22:01:06
    [user_regdate] => 2004-07-16 22:01:06
    [user_group_list] =>
    [user_email] =>
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [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
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
   

• => SELECT extension, mime, content FROM cpg_filetypes;
[1] => SELECT * FROM cpg_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '1d8c68aeb928bff77decdcf215e11500'
    [2] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (1)
    [3] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1
    [4] => DELETE FROM cpg_banned WHERE expiry < 1090012686
    [5] => SELECT * FROM cpg_banned WHERE ip_addr='xx.xxx.xx.xxx' OR ip_addr='xx.xxx.xx.xxx' OR user_id=1
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.4 - OK
------------------
mySQL version: 4.0.16-log
------------------
Coppermine version: 1.3.1
==========================
Module: gd
------------------
module doesn't exist
==========================
Module: mysql
------------------
module doesn't exist
==========================
Module: zlib
------------------
module doesn't exist
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
==========================
email
------------------
Directive | Local Value | Master Value |  |  |  |  |  |  |  |
==========================
Size and Time
------------------
Directive | Local Value | Master Value |  |  |  |  |  |  |  |
==========================
Page generated in 0.06 seconds - 6 queries in 0.003 seconds - Album set :

[Keksz]

nobody know the real answer

if you have a lot of visitors the mysql sucks, and you get query error

so i can't use this coppermine gallery

[Nibbler]

No one on this thread has yet posted the mysql error message as requested. Without that we cannot know what the problem is.