Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: Admin Tools critical error.  (Read 7387 times)

0 Members and 1 Guest are viewing this topic.

clothahump

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
[Solved]: Admin Tools critical error.
« on: July 04, 2004, 09:46:40 pm »
When I click on Admin tools I get this critical error. "There was an error while processing a database query"
« Last Edit: July 06, 2004, 08:56:10 am by GauGau »
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Admin Tools critical error.
« Reply #1 on: July 05, 2004, 12:48:44 am »
Activate debug mode, in config, and post here the debug error report.

Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

clothahump

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
Re: Admin Tools critical error.
« Reply #2 on: July 05, 2004, 12:58:56 am »
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)
Logged

clothahump

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
Re: Admin Tools critical error.
« Reply #3 on: July 05, 2004, 10:08:01 am »
Any ideas Casper???
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Admin Tools critical error.
« Reply #4 on: July 05, 2004, 10:29:38 am »
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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

clothahump

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
Re: Admin Tools critical error.
« Reply #5 on: July 05, 2004, 10:42:21 am »
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 :
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Admin Tools critical error.
« Reply #6 on: July 05, 2004, 10:53:54 am »
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?
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Admin Tools critical error.
« Reply #7 on: July 05, 2004, 11:00:43 am »
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/
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

clothahump

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
Re: Admin Tools critical error.
« Reply #8 on: July 05, 2004, 11:14:30 am »
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 :

Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Admin Tools critical error.
« Reply #9 on: July 05, 2004, 11:22:17 am »
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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

clothahump

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
Re: Admin Tools critical error.
« Reply #10 on: July 05, 2004, 12:25:32 pm »
(http://www.corydorasworld.com/forum/html/emoticons/celebrate.gif) 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.
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Admin Tools critical error.
« Reply #11 on: July 05, 2004, 03:01:54 pm »
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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

clothahump

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
Re: Admin Tools critical error.
« Reply #12 on: July 05, 2004, 04:21:08 pm »
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.  ;D
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.025 seconds with 20 queries.