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: Can't view memberlist after bridging  (Read 9776 times)

0 Members and 1 Guest are viewing this topic.

zzaa_za

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Can't view memberlist after bridging
« on: February 15, 2011, 04:35:41 pm »

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!
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Can't view memberlist after bridging
« Reply #1 on: February 15, 2011, 04:42:07 pm »

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

zzaa_za

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Can't view memberlist after bridging
« Reply #2 on: February 15, 2011, 04:52:04 pm »

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

Done!
Logged

zzaa_za

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Can't view memberlist after bridging
« Reply #3 on: February 15, 2011, 04:54:50 pm »

Sorry forgot to post the detailed error message.

Code: [Select]
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     


==========================
               
Logged

zzaa_za

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Can't view memberlist after bridging
« Reply #4 on: February 15, 2011, 04:57:48 pm »

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

 :-\
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Can't view memberlist after bridging
« Reply #5 on: February 15, 2011, 04:59:45 pm »

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

zzaa_za

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Can't view memberlist after bridging
« Reply #6 on: February 15, 2011, 05:03:50 pm »

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.

 :)
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Can't view memberlist after bridging
« Reply #7 on: February 15, 2011, 05:07:33 pm »

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

zzaa_za

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Can't view memberlist after bridging
« Reply #8 on: February 15, 2011, 05:10:39 pm »

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.

Quote
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

Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Can't view memberlist after bridging
« Reply #9 on: February 15, 2011, 06:08:11 pm »

Quote
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.
Logged

zzaa_za

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Can't view memberlist after bridging
« Reply #10 on: February 15, 2011, 08:46:32 pm »

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.057 seconds with 19 queries.