forum.coppermine-gallery.net
Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: Mr Tee on May 29, 2004, 02:02:44 pm
-
I have installed and all seemed to work OK. When I intigrated with my phpBB board and try to login I am taken to my message board, where I am already logged in. I return to the gallery but am not logged in. Debug as follows. Any help please?
USER:
Array
(
[ID] => eaf6063b798e7cf8e7eaae168a81fe83
[am] => 1
[liv] => Array
(
)
)
USER DATA:
Array
(
[user_id] => 1
[1] => 1
[user_group] => 1
[2] => YES
[user_active] => YES
[3] => Barrie
[user_name] => xxxxx
[4] => xxxxx
[5] => 2004-05-29 11:52:44
[user_lastvisit] => 2004-05-29 11:52:44
[6] => 2004-05-29 11:52:44
[user_regdate] => 2004-05-29 11:52:44
[7] =>
[user_lang] =>
[8] =>
[user_email] =>
[9] =>
[user_website] =>
[10] =>
[user_location] =>
[11] =>
[user_interests] =>
[12] =>
[user_occupation] =>
[13] =>
[user_actkey] =>
[14] => 1
[group_id] => 1
[15] => Administrators
[group_name] => Administrators
[16] => 0
[group_quota] => 0
[17] => 1
[has_admin_access] => 1
[18] => 1
[can_rate_pictures] => 1
[19] => 1
[can_send_ecards] => 1
[20] => 1
[can_post_comments] => 1
[21] => 1
[can_upload_pictures] => 1
[22] => 1
[can_create_albums] => 1
[23] => 0
[pub_upl_need_approval] => 0
[24] => 0
[priv_upl_need_approval] => 0
)
Queries:
Array
(
- => SELECT * FROM cpg11d_users, cpg11d_usergroups WHERE user_group = group_id AND user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '4d9f1bc5ef05edfde21d66d64a4a0b32'
[1] => DELETE FROM cpg11d_banned WHERE expiry < 1085831631
[2] => SELECT * FROM cpg11d_banned WHERE ip_addr='62.255.64.4' OR ip_addr='80.1.154.116' OR user_id=1
[3] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '' ORDER BY pos
[4] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
[5] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
[6] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1' ORDER BY pos
[7] => SELECT aid FROM cpg11d_albums WHERE category = 2
[8] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 2
[9] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '2' ORDER BY pos
[10] => SELECT count(*) FROM cpg11d_albums WHERE 1
[11] => SELECT count(*) FROM cpg11d_pictures WHERE 1
[12] => SELECT count(*) FROM cpg11d_comments WHERE 1
[13] => SELECT count(*) FROM cpg11d_categories WHERE 1
[14] => SELECT sum(hits) FROM cpg11d_pictures WHERE 1
[15] => SELECT count(*) FROM cpg11d_albums WHERE category = ''
[16] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '' ORDER BY pos LIMIT 0,1
[17] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (1) AND approved = 'YES' GROUP BY aid
[18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1'
[19] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
[20] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid FROM cpg11d_pictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 8
[21] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
[22] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, owner_id, owner_name, aid FROM cpg11d_pictures WHERE approved = 'YES' ORDER BY pid DESC LIMIT 0 ,8
)
GET :
Array
(
)
POST :
Array
(
)
-
Read http://coppermine.sourceforge.net/manual.php#integrating , http://forum.coppermine-gallery.net/index.php?topic=1164.0 and http://forum.coppermine-gallery.net/index.php?topic=2972.0
GauGau