[Solved]: Admin Tools critical error.

[clothahump]

When I click on Admin tools I get this critical error. "There was an error while processing a database query"

[Casper]

Activate debug mode, in config, and post here the debug error report.

[clothahump]

Notice: Undefined index: cat_thumb in /var/www/html/gallery/themes/eyeball/theme.php on line 1125

Notice: Undefined index: cat_albums in /var/www/html/gallery/themes/eyeball/theme.php on line 1127


USER:
------------------
Array
(
    [ID] => 66effc648f86d165fcd6516c9c901103
    [am] => 1
    [liv] => Array
        (
           

• => 3
              [1] => 1
              [2] => 2
              [3] => 7
              [4] => 5
          )
  
      [lang] => english
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
     
• => 1
      [user_id] => 1
      [1] => ***
      [user_name] => ****
      [2] => 4
      [mgroup] => 4
      [3] => 4
      [group_id] => 4
      [4] => Admin
      [group_name] => Admin
      [5] => 2048
      [group_quota] => 2048
      [6] => 0
      [has_admin_access] => 1
      [7] => 1
      [can_rate_pictures] => 1
      [8] => 1
      [can_send_ecards] => 1
      [9] => 1
      [can_post_comments] => 1
      [10] => 1
      [can_upload_pictures] => 1
      [11] => 1
      [can_create_albums] => 1
      [12] => 0
      [pub_upl_need_approval] => 0
      [13] => 0
      [priv_upl_need_approval] => 0
      [14] => 3
      [upload_form_config] => 3
      [15] => 1
      [custom_user_upload] => 1
      [16] => 10
      [num_file_upload] => 10
      [17] => 3
      [num_URI_upload] => 3
      [groups] => Array
          (
             
• => 4
          )
  
      [can_see_all_albums] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg130_filetypes;
      [1] => SELECT id as user_id, name as user_name, mgroup FROM `*******`.ibf_members WHERE id='1' AND password='*************************'
      [2] => SELECT * FROM cpg130_usergroups WHERE group_id = '4'
      [3] => DELETE FROM cpg130_banned WHERE expiry < 1088980323
      [4] => SELECT * FROM cpg130_banned WHERE ip_addr='213.78.67.106' OR ip_addr='213.78.67.106' OR user_id=1
      [5] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = ''  ORDER BY pos
      [6] => SELECT aid FROM cpg130_albums WHERE category>=10000
      [7] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category >= 10000
      [8] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '1'  ORDER BY pos
      [9] => SELECT aid FROM cpg130_albums WHERE category = 2
      [10] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 2
      [11] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '2'  ORDER BY pos
      [12] => SELECT aid FROM cpg130_albums as a WHERE category = '0'
      [13] => SELECT count(*) FROM cpg130_albums as a WHERE category>0
      [14] => SELECT count(*) FROM cpg130_pictures as p LEFT JOIN cpg130_albums as a ON a.aid=p.aid WHERE a.category>=0
      [15] => SELECT count(*) FROM cpg130_comments as c LEFT JOIN cpg130_pictures as p ON c.pid=p.pid LEFT JOIN cpg130_albums as a ON a.aid=p.aid WHERE a.category>=0
      [16] => SELECT count(*) FROM cpg130_categories WHERE 1
      [17] => SELECT sum(hits) FROM cpg130_pictures as p LEFT JOIN cpg130_albums as a ON p.aid=a.aid WHERE a.category>=0
      [18] => SELECT count(*) FROM cpg130_albums as a WHERE category = '0'
      [19] => SELECT COUNT(*) from cpg130_pictures WHERE approved = 'YES' AND aid IN (1,3,4)
      [20] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg130_pictures WHERE approved = 'YES' AND aid IN (1,3,4)  ORDER BY RAND() LIMIT 6
      [21] => SELECT COUNT(*) from cpg130_pictures WHERE approved = 'YES' AND aid IN (1,3,4)
      [22] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg130_pictures WHERE approved = 'YES' AND aid IN (1,3,4)  ORDER BY pid DESC  LIMIT 0 ,6
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.3 - OK
  ------------------
  mySQL version: 3.23.58
  ==========================
  Module: gd
  ------------------
  GD Support enabled
  GD Version bundled (2.0.15 compatible)
  FreeType Support enabled
  FreeType Linkage with freetype
  GIF Read Support enabled
  JPG Support enabled
  PNG Support enabled
  WBMP Support enabled
  XBM Support enabled
  ==========================
  Module: mysql
  ------------------
  Active Persistent Links 0
  Active Links 1
  Client API version 3.23.58
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.3
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/php/includes:/usr/share/php | .:/php/includes:/usr/share/php
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | me@localhost.com | me@localhost.com
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 60 | 60
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.084 seconds - 23 queries in 0.007 seconds - Album set : AND aid IN (1,3,4)

[clothahump]

Any ideas Casper???

[Casper]

OK, now with debug still turned on, try to use the admin tools, do what you did before that caused the critical error, and you should also get a full error message.  Please post that error message in full.

[clothahump]

There was an error while processing a database query.

While executing query "SELECT aid, category, IF(name IS NOT NULL, CONCAT('(', name, ') ',title), CONCAT(' - ', title)) AS title FROM cpg130_albums AS a LEFT JOIN ibf_members AS u ON category = (10000 + id) ORDER BY category, title" on

mySQL error: Table 'photochallenge_org_uk_-_gallery.ibf_members' doesn't exist


File: /var/www/html/gallery/include/functions.inc.php - Line: 110

Notice: Undefined index: action in /var/www/html/gallery/util.php on line 49

Select album

Notice: Undefined variable: UDB_DB_NAME_PREFIX in /var/www/html/gallery/bridge/invisionboard.inc.php on line 374

Notice: Undefined variable: UDB_DB_LINK_ID in /var/www/html/gallery/bridge/invisionboard.inc.php on line 377

USER:
------------------
Array
(
   [ID] => 66effc648f86d165fcd6516c9c901103
   [am] => 1
   [liv] => Array
       (
           

• => 3
             [1] => 1
             [2] => 2
             [3] => 7
             [4] => 5
         )
  
     [lang] => english
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
     
• => 1
     [user_id] => 1
     [1] => ***
     [user_name] => ****
     [2] => 4
     [mgroup] => 4
     [3] => 4
     [group_id] => 4
     [4] => Admin
     [group_name] => Admin
     [5] => 2048
     [group_quota] => 2048
     [6] => 0
     [has_admin_access] => 1
     [7] => 1
     [can_rate_pictures] => 1
     [8] => 1
     [can_send_ecards] => 1
     [9] => 1
     [can_post_comments] => 1
     [10] => 1
     [can_upload_pictures] => 1
     [11] => 1
     [can_create_albums] => 1
     [12] => 0
     [pub_upl_need_approval] => 0
     [13] => 0
     [priv_upl_need_approval] => 0
     [14] => 3
     [upload_form_config] => 3
     [15] => 1
     [custom_user_upload] => 1
     [16] => 10
     [num_file_upload] => 10
     [17] => 3
     [num_URI_upload] => 3
     [groups] => Array
         (
             
• => 4
         )
  
     [can_see_all_albums] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg130_filetypes;
     [1] => SELECT id as user_id, name as user_name, mgroup FROM `photochallenge_org_uk_-_forum`.ibf_members WHERE id='1' AND password='*****************************'
     [2] => SELECT * FROM cpg130_usergroups WHERE group_id = '4'
     [3] => DELETE FROM cpg130_banned WHERE expiry < 1089015398
     [4] => SELECT * FROM cpg130_banned WHERE ip_addr='213.78.79.206' OR ip_addr='213.78.79.206' OR user_id=1
     [5] => SELECT aid, category, IF(name IS NOT NULL, CONCAT('(', name, ') ',title), CONCAT(' - ', title)) AS title FROM cpg130_albums AS a LEFT JOIN ibf_members AS u ON category = (10000 + id) ORDER BY category, title
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.3 - OK
  ------------------
  mySQL version: 3.23.58
  ==========================
  Module: gd
  ------------------
  GD Support enabled
  GD Version bundled (2.0.15 compatible)
  FreeType Support enabled
  FreeType Linkage with freetype
  GIF Read Support enabled
  JPG Support enabled
  PNG Support enabled
  WBMP Support enabled
  XBM Support enabled
  ==========================
  Module: mysql
  ------------------
  Active Persistent Links 0
  Active Links 1
  Client API version 3.23.58
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient  
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.3
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/php/includes:/usr/share/php | .:/php/includes:/usr/share/php
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | me@localhost.com | me@localhost.com
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 60 | 60
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 2.902 seconds - 6 queries in 0.002 seconds - Album set :

[Casper]

OK, is this the only time you get this error, i.e., when going to admin tools, not when uploading, or using the groups manager?

[Casper]

Just realised this was reported and fixed a while ago 

You need to download the updated bridge file, and replace your existing one.  Get the file at http://cvs.sourceforge.net/viewcvs.py/coppermine/stable/bridge/

[clothahump]

Updated the file but still get this in admin utilities.

Notice: Undefined index: action in /var/www/html/gallery/util.php on line 49

USER:
------------------
Array
(
    [ID] => 66effc648f86d165fcd6516c9c901103
    [am] => 1
    [liv] => Array
        (
           

• => 3
              [1] => 1
              [2] => 2
              [3] => 7
              [4] => 5
          )
  
      [lang] => english
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
     
• => 1
      [user_id] => 1
      [1] => ***
      [user_name] => ****
      [2] => 4
      [mgroup] => 4
      [3] => 4
      [group_id] => 4
      [4] => Admin
      [group_name] => Admin
      [5] => 2048
      [group_quota] => 2048
      [6] => 0
      [has_admin_access] => 1
      [7] => 1
      [can_rate_pictures] => 1
      [8] => 1
      [can_send_ecards] => 1
      [9] => 1
      [can_post_comments] => 1
      [10] => 1
      [can_upload_pictures] => 1
      [11] => 1
      [can_create_albums] => 1
      [12] => 0
      [pub_upl_need_approval] => 0
      [13] => 0
      [priv_upl_need_approval] => 0
      [14] => 3
      [upload_form_config] => 3
      [15] => 1
      [custom_user_upload] => 1
      [16] => 10
      [num_file_upload] => 10
      [17] => 3
      [num_URI_upload] => 3
      [groups] => Array
          (
             
• => 4
          )
  
      [can_see_all_albums] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg130_filetypes;
      [1] => SELECT id as user_id, name as user_name, mgroup FROM `photochallenge_org_uk_-_forum`.ibf_members WHERE id='1' AND password='*****************************'
      [2] => SELECT * FROM cpg130_usergroups WHERE group_id = '4'
      [3] => DELETE FROM cpg130_banned WHERE expiry < 1089017277
      [4] => SELECT * FROM cpg130_banned WHERE ip_addr='213.78.79.206' OR ip_addr='213.78.79.206' OR user_id=1
      [5] => SELECT aid, category, IF(name IS NOT NULL, CONCAT('(', name, ') ', a.title), CONCAT(' - ', a.title)) AS title FROM cpg130_albums AS a LEFT JOIN `photochallenge_org_uk_-_forum`.ibf_members AS u ON category = (10000 + id) ORDER BY category, title
      [6] => SELECT name FROM cpg130_categories WHERE cid = 10001
      [7] => SELECT name FROM cpg130_categories WHERE cid = 10002
      [8] => SELECT name FROM cpg130_categories WHERE cid = 10003
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.3 - OK
  ------------------
  mySQL version: 3.23.58
  ==========================
  Module: gd
  ------------------
  GD Support enabled
  GD Version bundled (2.0.15 compatible)
  FreeType Support enabled
  FreeType Linkage with freetype
  GIF Read Support enabled
  JPG Support enabled
  PNG Support enabled
  WBMP Support enabled
  XBM Support enabled
  ==========================
  Module: mysql
  ------------------
  Active Persistent Links 0
  Active Links 1
  Client API version 3.23.58
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.3
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/php/includes:/usr/share/php | .:/php/includes:/usr/share/php
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | me@localhost.com | me@localhost.com
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 60 | 60
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.205 seconds - 9 queries in 0.003 seconds - Album set :
  
  

[Casper]

Turn off debug, and see if it works.  There are several areas where you will get 'undefined index' in debug, but they do not affect the operation of coppermine.
It is only if you get errors, or warnings, you need to worry.

[clothahump]

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.corydorasworld.com%2Fforum%2Fhtml%2Femoticons%2Fcelebrate.gif&hash=1547a2a04e3ec55270c348c07206ca774e483d42) Cheers Casper, thank you for all your help.
How do I alter the Karma rating for you and remove my Negative Karma unfairly awarded to me by someone, I can guess who it was.

[Casper]

If you cannot see the '[applaud][smite]' links by your karma setting, then you cannot give awards to others. I'm not sure at what stage these become available to members.  No-one can change their own setting.
A karma setting of -1 is nothing to worry about, it means you made an error once on the boards.  It is those who continue to break the boards rules, and subsequently get several minus points, who need to worry.

You will get positive karma points by adding to the boards in some way, by supplying a hack or mod, or simply by helping others.

I hope you enjoy using coppermine now you have it working the way you want.  I noticed on my visit to your site, you don't yet have navigation links between your forum and gallery.  These would help users a lot.

[clothahump]

Thanks Casper.

The links are the next thing on the list of things to do, I will try not to break anything whilst doing so.

Thanks to one and all once again.