Can't view memberlist after bridging

[zzaa_za]

I could solved my first problem, but I found another problem after bridging. When I click the memberlist (under My Gallery) I can't see any members there. The same problem happens when I click the users menu as well. What I get is "Critical Error. There was an error while processing a database query"

Here's my info:

Coppermine install: http://siamese-studio.com/gallery/
Bridging app install: http://siamese-studio/forums/
Coppermine version: cpg1.5.12
Bridging app version: SMF 2.0 RC5
Test user account: test/password

BridgeManager settings:
Bridge app URL:  http://siamese-studio/forums/
Relative path to your bridge app's config file:  ../forums/
Cookie name or prefix:  SMFCookie463
Use bridge app custom groups?:  1

Thank you in advance!

[Αndré]

Please enable the debug mode and post the detailed error message.

[zzaa_za]

Please enable the debug mode and post the detailed error message.

Done!

[zzaa_za]

Sorry forgot to post the detailed error message.

Code Select Expand

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

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => May
    [groups] => Array
        (
            [0] => 101
            [1] => 107
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [access_level] => 3
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrator
    [can_create_public_albums] => 1
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 101
    [allowed_albums] => Array
        (
        )

)

==========================
Queries:
------------------
Array
(
    [0] => SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (22 ms)
    [1] => SELECT * FROM cpg15x_plugins ORDER BY priority [include/plugin_api.inc.php:53] (0 ms)
    [2] => SELECT name, value FROM cpg15x_bridge [include/functions.inc.php:4421] (0 ms)
    [3] => SELECT u.id_member AS id, u.real_name AS username, SHA1(CONCAT(passwd, password_salt)) AS password, u.id_post_group AS group_id FROM `siameses_smf2`.smf_members AS u LEFT JOIN `siameses_smf2`.smf_membergroups AS g ON u.id_post_group=g.id_group WHERE u.id_member='1' [bridge/udb_base.inc.php:70] (0 ms)
    [4] => SELECT id_group, additional_groups AS additionals FROM `siameses_smf2`.smf_members WHERE id_member = 1 [bridge/smf20.inc.php:151] (0 ms)
    [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(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, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS  priv_upl_need_approval FROM cpg15x_usergroups WHERE group_id in (101,107) [bridge/udb_base.inc.php:323] (0 ms)
    [6] => SELECT group_name FROM cpg15x_usergroups WHERE group_id= 101 [bridge/udb_base.inc.php:327] (0 ms)
    [7] => SELECT COUNT(*) FROM cpg15x_categorymap WHERE group_id in (101,107) [bridge/udb_base.inc.php:340] (0 ms)
    [8] => SELECT lang_id FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms)
    [9] => SELECT user_favpics FROM cpg15x_favpics WHERE user_id = 1 [include/init.inc.php:387] (0 ms)
    [10] => DELETE FROM cpg15x_banned WHERE expiry < '2011-02-15 09:52:22' [include/init.inc.php:443] (0 ms)
    [11] => SELECT null FROM cpg15x_banned WHERE (user_id=1 OR '183.89.121.115' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms)
    [12] => SELECT name, description, thumb FROM cpg15x_categories WHERE cid = 1 [index.php:268] (3 ms)
    [13] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
        FROM cpg15x_albums AS a
        INNER JOIN cpg15x_pictures AS p ON p.aid = a.aid
        WHERE a.category > 10000
        AND approved = 'YES' [index.php:292] (0 ms)
    [14] => SELECT name, description, cid, thumb, depth, lft
        FROM cpg15x_categories AS c
        WHERE depth BETWEEN 0 + 1 AND 0 + 2
ORDER BY c.lft [index.php:316] (0 ms)
    [15] => SELECT category, COUNT(*) AS num
        FROM cpg15x_albums AS a
        INNER JOIN cpg15x_categories ON cid = category
        WHERE depth BETWEEN 0 + 1 AND 0 + 2
GROUP BY category ORDER BY NULL [index.php:358] (0 ms)
    [16] => SELECT title, r.description, keyword, category, aid, alb_hits, visibility, r.thumb, r.owner
        FROM cpg15x_categories AS c
        INNER JOIN cpg15x_albums AS r ON r.category = c.cid
        WHERE c.depth BETWEEN 0 + 1 AND 0 + 2
ORDER BY r.pos, r.aid [index.php:379] (58 ms)
    [17] => SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload
        FROM cpg15x_categories AS c
        INNER JOIN cpg15x_albums AS r ON r.category = c.cid
        INNER JOIN cpg15x_pictures AS p ON p.aid = r.aid
        WHERE (1)
        AND approved = 'YES'
        AND c.depth BETWEEN 0 + 1 AND 0 + 2
        GROUP BY r.aid
        ORDER BY NULL [index.php:414] (30 ms)
    [18] => SELECT extension, mime, content, player FROM cpg15x_filetypes [include/functions.inc.php:5789] (1 ms)
    [19] => SELECT count(pid) AS link_pic_count, max(pid) AS link_last_pid  FROM cpg15x_pictures  WHERE ((aid != '2' ) AND (keywords like '%full kit%' ))  AND approved='YES' [index.php:1009] (0 ms)
    [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg15x_pictures WHERE ((aid = '2' ) AND (keywords like '%full kit%' ))  AND approved='YES' ORDER BY RAND() LIMIT 0,1 [index.php:1033] (1 ms)
    [21] => SELECT count(pid) AS link_pic_count, max(pid) AS link_last_pid  FROM cpg15x_pictures  WHERE ((aid != '4' ) AND (keywords like '%collab%' ))  AND approved='YES' [index.php:1009] (0 ms)
    [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg15x_pictures WHERE pid='8' [index.php:1039] (0 ms)
    [23] => SELECT count(pid) AS link_pic_count, max(pid) AS link_last_pid  FROM cpg15x_pictures  WHERE ((aid != '3' ) AND (keywords like '%CT layouts%' ))  AND approved='YES' [index.php:1009] (0 ms)
    [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg15x_pictures WHERE pid='6' [index.php:1039] (0 ms)
    [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg15x_pictures WHERE pid='11' [index.php:1039] (0 ms)
    [26] => SELECT COUNT(*) FROM cpg15x_albums AS a WHERE 1  [index.php:542] (0 ms)
    [27] => SELECT COUNT(*) FROM cpg15x_pictures WHERE approved = 'YES' [index.php:555] (0 ms)
    [28] => SELECT COUNT(*) FROM cpg15x_comments WHERE approval = 'YES' [index.php:574] (0 ms)
    [29] => SELECT COUNT(*) FROM cpg15x_categories [index.php:580] (0 ms)
    [30] => SELECT SUM(hits) FROM cpg15x_pictures WHERE approved = 'YES' [index.php:593] (0 ms)
    [31] => SELECT COUNT(*) FROM cpg15x_pictures WHERE approved = 'NO' [include/functions.inc.php:2418] (0 ms)
    [32] => SELECT lang_id, abbr FROM cpg15x_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2315] (0 ms)
    [33] => DELETE FROM cpg15x_temp_messages WHERE time < 1297781543 [include/functions.inc.php:4927] (6 ms)
    [34] => SELECT count(aid) FROM cpg15x_albums as a WHERE category = '0'  [index.php:728] (0 ms)
    [35] => SELECT COUNT(*)
                FROM cpg15x_pictures AS r
                INNER JOIN cpg15x_albums AS a ON a.aid = r.aid
                WHERE (1)
                AND approved = 'YES' [include/functions.inc.php:1485] (0 ms)
    [36] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
                FROM cpg15x_pictures AS r
                INNER JOIN cpg15x_albums AS a ON a.aid = r.aid
                WHERE (1)
                AND approved = 'YES'
                ORDER BY r.pid DESC  LIMIT 0 ,8 [include/functions.inc.php:1501] (0 ms)
)

==========================
GET :
------------------
Array
(
)

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

==========================
COOKIE :
------------------
Array
(
    [wibiya682095_unique_user] => 1
    [cpg15x_data] => YTo0OntzOjI6IklEIjtzOjMyOiIxYmRhYjY2OGMxODI2ZmQzYWNiNjQzOGUxNWRjMGMyMCI7czo0OiJsYW5nIjtzOjc6ImVuZ2xpc2giO3M6MjoiYW0iO2k6MTtzOjM6ImxpdiI7YTowOnt9fQ==
    [PHPSESSID] => 58748e9bd1649a66ade479bc91940c19
    [SMFCookie463] => a:4:{i:0;s:1:\"1\";i:1;s:40:\"e584f6cbc6fe6b5bff9d39ad72c7d835d7c46627\";i:2;i:1486999100;i:3;i:2;}
)

==========================
SESSION :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version        5.2.13           OK   
MySQL version      5.0.91-community OK   
Coppermine version 1.5.12           stable

==========================
Module: GD
------------------
Exact version                    2.0.34                     
GD Version                       bundled (2.0.34 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                         
XPM Support                      1                         
XBM Support                      1                         
JIS-mapped Japanese Font Support                           

==========================
Key config settings
------------------
site_url             http://www.siamese-studio.com/gallery/
charset              utf-8                                 
allow_private_albums 1                                     
cookie_name          cpg15x                               
cookie_path          /                                     
impath               /usr/bin/                             
lang                 english                               
main_page_layout     breadcrumb/catlist/alblist/lastup,2   
silly_safe_mode      0                                     
smtp_host                                                 
theme                curve                                 
thumb_method         gd2                                   

==========================
Plugins
------------------

==========================
Server restrictions
------------------
safe_mode                                                                                                                               
safe_mode_exec_dir                                                                                                                     
safe_mode_gid                                                                                                                           
safe_mode_include_dir                                                                                                                   
sql.safe_mode                                                                                                                           
disable_functions        symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,passthru,escapeshellarg,escapeshellcmd,show_source
file_uploads             1                                                                                                             
include_path             .:/usr/lib/php:/usr/local/lib/php                                                                             
open_basedir             /home/siameses:/usr/lib/php:/usr/local/lib/php:/tmp                                                           
allow_url_fopen          1                                                                                                             
max_execution_time       30                                                                                                             
max_input_time           60                                                                                                             
upload_max_filesize      128M                                                                                                           
post_max_size            128M                                                                                                           
memory_limit             128M                                                                                                           
suhosin.post.max_vars                                                                                                                   
suhosin.request.max_vars                                                                                                               


==========================
Page (performance)
------------------
Parameter        Current  Peak   
Memory usage     2.97 MiB 4.53 MiB
Page generation  348 ms   348 ms 
Page query time  121 ms   121 ms 
Page query count 37       37     


==========================
               

[zzaa_za]

Oh no!
Sorry I clicked the tuned down button by accident.
I still can't solve this problem yet.

:-\

[Αndré]

That's not the error message, but the debug output.

[zzaa_za]

That's not the error message, but the debug output.

I'm sorry but where can I find the error message.
Sorry to be such pain but I really don't know where to find it.
Hope you understand.

[Αndré]

You already posted the (short) error message:

Critical Error. There was an error while processing a database query

After enabling the debug mode that error message contains much more detailed information.

[zzaa_za]

You already posted the (short) error message:
After enabling the debug mode that error message contains much more detailed information.

Oh yes!

I got it now.

Critical error

There was an error while processing a database query.

While executing query 'SELECT id_member AS user_id, real_name AS user_name, email_address AS user_email, date_registered AS user_regdate, last_login 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 `siameses_smf2`.smf_members AS u INNER JOIN `siameses_cpg`.cpg15x_usergroups AS g ON u.id_post_group+100 = g.group_id LEFT JOIN `siameses_cpg`.cpg15x_pictures AS p ON p.owner_id = u.id_member GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;' in bridge/udb_base.inc.php on line 230

mySQL error: SELECT command denied to user 'siameses_smf2'@'localhost' for table 'cpg15x_usergroups'


File: /home/siameses/public_html/gallery/include/functions.inc.php - Line: 270

[Αndré]

SELECT command denied to user 'siameses_smf2'@'localhost' for table 'cpg15x_usergroups'

Check the permissions of your MySQL users. Maybe you cannot do that yourself and you have to ask your hosting provider.

[zzaa_za]

Check the permissions of your MySQL users. Maybe you cannot do that yourself and you have to ask your hosting provider.

Thank you!
I've submit a ticket to my host, and they told me to create a new MySQL User and add into the database. I've tried that but it didn't work so I've added the the forum MySQL user to Coppermine database and it works.