Print Page - [Solved]: Admin Tools critical error.

Title: [Solved]: Admin Tools critical error.
Post by: clothahump 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"

Title: Re: Admin Tools critical error.
Post by: Casper on July 05, 2004, 12:48:44 AM

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

Title: Re: Admin Tools critical error.
Post by: clothahump 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)

Title: Re: Admin Tools critical error.
Post by: clothahump on July 05, 2004, 10:08:01 AM

Any ideas Casper???

Title: Re: Admin Tools critical error.
Post by: Casper 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.

Title: Re: Admin Tools critical error.
Post by: clothahump 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 :

Title: Re: Admin Tools critical error.
Post by: Casper 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?

Title: Re: Admin Tools critical error.
Post by: Casper 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/

Title: Re: Admin Tools critical error.
Post by: clothahump 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 :

Title: Re: Admin Tools critical error.
Post by: Casper 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.

Title: Re: Admin Tools critical error.
Post by: clothahump on July 05, 2004, 12:25:32 PM

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

Title: Re: Admin Tools critical error.
Post by: Casper 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.

Title: Re: Admin Tools critical error.
Post by: clothahump 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

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: clothahump on July 04, 2004, 09:46:40 PM