forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 bridging => Topic started by: zzaa_za 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!
-
Please enable the debug mode and post the detailed error message.
-
Please enable the debug mode and post the detailed error message.
Done!
-
Sorry forgot to post the detailed error message.
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
==========================
-
Oh no!
Sorry I clicked the tuned down button by accident.
I still can't solve this problem yet.
:-\
-
That's not the error message, but the debug output.
-
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.
:)
-
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.
-
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
-
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.
-
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.