Fatal Error

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