Getting a User Gallery database error

[lithman]

I am very very new to Coppermine. I really don't know what I'm doing with it. All I know is Under user gallery categorey it says 2 albums and 5 files ... but when you click on user gallery, it says "Critical error There was an error while processing a database query" It also says this when I am logged in as admin and I click on Users in the admin tool bar.

I have no idea what this means or what to look for or what to do.... please help! I really need to have my users able to have their own album. Thanks

http://www.historum.com/photos (you must be a member to see the photo gallery though). I have Allow unlogged users (guest or anonymous) access clicked YES ... and it still won't let a guest look at the photo album.

[Stramm]

enable debug mode and post the actual error message (not the debug outout)

[Joachim Müller]

You're using cpg1.4.2, so you shouldn't have started your thread on the cpg1.3.x support board. Moving this thread accordingly. You're lagging behind in versions, upgrade to the most recent version (currently cpg1.4.8) asap!

[lithman]

Here is the error I get

Code Select Expand

While executing query "SELECT user_id as user_id,username as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg_albums AS a INNER JOIN `lithman_historum`.phpbb_users as u on u.user_id+10000=a.category LEFT JOIN cpg_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 12 " on 0

mySQL error:


File: /home/user/public_html/historum/photos/include/functions.inc.php - Line: 248

Code Select Expand

USER:
------------------
Array
(
    [ID] => eda9e1b6013f270bd0788000fbada06d
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => Commander
    [groups] => Array
        (
            [0] => 1
        )

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

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg_filetypes; (0s)
    [1] => select * from cpg_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg_bridge (0s)
    [3] => SELECT u.user_id AS user_id, u.user_password AS password FROM `lithman_historum`.phpbb_users AS u, `lithman_historum`.phpbb_sessions AS s WHERE u.user_id=s.session_user_id AND s.session_id = '5f1b3aa16f351a291e215d1aeddc9efd' AND u.user_id > 0 (0s)
    [4] => SELECT u.user_id AS id, u.username AS username, u.user_password AS password, ug.group_id AS group_id FROM `lithman_historum`.phpbb_users AS u, `lithman_historum`.phpbb_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='2' (0s)
    [5] => 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) (0s)
    [6] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1 (0s)
    [7] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 2 (0s)
    [8] => DELETE FROM cpg_banned WHERE expiry < '2006-08-12 01:57:01' (0s)
    [9] => SELECT * FROM cpg_banned WHERE (ip_addr='24.127.225.187' OR ip_addr='24.127.225.187' OR user_id=2) AND brute_force=0 (0s)
    [10] => SELECT aid FROM cpg_albums as a WHERE category>=10000 (0s)
    [11] => SELECT cid FROM cpg_categories WHERE parent = '1' (0s)
    [12] => SELECT name, parent FROM cpg_categories WHERE cid = '1' (0s)
    [13] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '1'  ORDER BY pos (0s)
    [14] => SELECT aid FROM cpg_albums as a WHERE category >= 10000 (0s)
    [15] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0s)
    [16] => select null from cpg_albums as p where ( category>10000 ) group by category; (0.001s)
    [17] => SELECT user_id as user_id,username as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg_albums AS a INNER JOIN `lithman_historum`.phpbb_users as u on u.user_id+10000=a.category LEFT JOIN cpg_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 12  (0s)
)

==========================
GET :
------------------
Array
(
    [cat] => 1
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.4.2 - OK
------------------
mySQL version: 4.1.19-standard
------------------
Coppermine version: 1.4.2(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 2
Client API version 4.1.19
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2
==========================
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 | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
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 | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 10M | 10M
post_max_size | 8M | 8M
==========================
Page generated in 0.115 seconds - 18 queries in 0.001 seconds - Album set : AND aid IN (5,6) ; Meta set: AND aid IN (5,6) ;

[lithman]

I have also made a demo user for anyone who needs to look at the forum

username: demo
password: demo

[Nibbler]

Update your gallery.

[Joachim Müller]

enable debug mode and post the actual error message (not the debug outout)

You have been told not to post debug_output. Why did you?

You're lagging behind in versions, upgrade to the most recent version (currently cpg1.4. asap!

You've been told to upgrade already. Running your outdated version is the reason for the error message you get. There's a reason why we release new versions: they contain fixes for older versions.