Print

[organportal]

Hello,

We are using Coppermine for years with our portal (subdreamer) and forum (SMF).
We started with another forumsoftware PhpBB but switched to SMF.

If we are on the coppermine gallery we can not look at users

This is the error we get:
While executing query "SELECT ID_MEMBER as user_id, memberName as user_name, emailAddress as user_email, dateRegistered as user_regdate, UNIX_TIMESTAMP(lastLogin) as user_lastvisit, is_activated as user_active, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota FROM `richard_SMF`.richard_members AS u INNER JOIN cpg133_usergroups AS g ON u.ID_POST_GROUP+100 = g.group_id LEFT JOIN cpg133_pictures AS p ON p.owner_id = u.ID_MEMBER GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;" on Resource id #23

mySQL error: No database selected

What can we do to solve this?

Thanks in advance!

Richard Postma
Organportal.com


below you can see the script Coppermine generate.

Code: [Select]

USER:
------------------
Array
(
    [ID] => c9004d50ee168ef4406844d8005ecdbd
    [am] => 1
    [lang] => dutch
    [liv] => Array
        (
        )

    [search] => Array
        (
            [search] => richard postma
            [album] => search
            [title] => on
            [newer_than] =>
            [caption] => on
            [older_than] =>
            [keywords] => on
            [type] => AND
            [params] => Array
                (
                    [title] => on
                    [caption] => on
                    [keywords] => on
                )

        )

    [lap] => 2
    [uid] => 263
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => Richard Postma
    [groups] => Array
        (
            [0] => 101
            [1] => 101
            [2] => 153
            [3] => 143
            [4] => 163
            [5] => 52
        )

    [disk_max] => 1000000
    [disk_min] => 120000
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 8
    [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] => Administrator
    [upload_form_config] => 3
    [group_quota] => 1000000
    [can_see_all_albums] => 1
    [group_id] => 101
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg133_filetypes; (0s)
    [1] => SELECT * FROM cpg133_bridge (0s)
    [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 cpg133_usergroups WHERE group_id in (101,101,153,143,163,52) (0.001s)
    [3] => SELECT group_name FROM  cpg133_usergroups WHERE group_id= 101 (0s)
    [4] => SELECT user_favpics FROM cpg133_favpics WHERE user_id = 2 (0.001s)
    [5] => DELETE FROM cpg133_banned WHERE expiry < '2007-10-07 11:26:40' (0.001s)
    [6] => SELECT * FROM cpg133_banned WHERE (ip_addr='83.82.71.165' OR ip_addr='83.82.71.165' OR user_id=2) AND brute_force=0 (0s)
    [7] => DELETE FROM cpg133_users WHERE user_name = '' LIMIT 1 (0s)
    [8] => SELECT COUNT(*) FROM cpg133_pictures WHERE approved = 'NO' (0.001s)
    [9] => SELECT count(*) FROM `richard_SMF`.richard_members WHERE 1 (0s)
    [10] => SELECT ID_MEMBER as user_id, memberName as user_name, emailAddress as user_email, dateRegistered as user_regdate, UNIX_TIMESTAMP(lastLogin) as user_lastvisit, is_activated as user_active, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota FROM `richard_SMF`.richard_members AS u INNER JOIN cpg133_usergroups AS g ON u.ID_POST_GROUP+100 = g.group_id LEFT JOIN cpg133_pictures AS p ON p.owner_id = u.ID_MEMBER GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25; (0s)
)

==========================
GET :
------------------
Array
(
    [llery] =>
    [usermgr_php] =>
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.4.7 - OK
------------------
mySQL version: 4.1.22-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.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -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 | dl, show_source, chown, shell_exec, exec, popen, pclose, virtual, passthru, proc_close, proc_get_status, proc_open, proc_terminate, system, pfsockopen, leak, apache_child_terminate, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid, posix_setuid, escapeshellcmd, escapeshellarg | dl, show_source, chown, shell_exec, exec, popen, pclose, virtual, passthru, proc_close, proc_get_status, proc_open, proc_terminate, system, pfsockopen, leak, apache_child_terminate, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid, posix_setuid, escapeshellcmd, escapeshellarg
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/richard/:/usr/lib/php:/usr/local/lib/php:/tmp | 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 | 500 | 500
max_input_time | 60 | 60
upload_max_filesize | 100M | 100M
post_max_size | 110M | 110M
==========================
Page generated in 0.346 seconds - 11 queries in 0.004 seconds - Album set : ; Meta set: ;

[edit by Sami]
Added code block to debug info
[/edit]

[Sami]

Please read the sticky first next time :When requesting bridge support - mandatory!

and also
- Do not post debug info unless requested
- Use code block (# button) for debug info