I have the following issue when trying to bridge coppermine 1.4.21 and phpBB3.0.2:
I have the same issue that many people seemd to used to have but has since been fixed. Once I enable the bridge, if i try to login to cpg, i am directed to my forum, if i click from my forum back to cpg i am still not logged in. once i disable the bridge everything is fine. I've been at this for over 8 hours, reading and re-reading the docs (still doesnt mean i didn't miss something). doing an uninstall/reinstall, going thru the forums and reading posts over and over. I'm such a noob, i'm probably missing something simple, please forgive me if i've provided too much, or not enough. And thank you in Advance.
Coppermine install:
http://www.houstonlancers.com/photosForum install:
http://www.houstonlancers.com/forumsCoppermine version: cpg1.4.21
Forum version: phpBB3.0.2 with BOARD3 portal mod
Test user account: for cpg: testuser/helpplz
for forums: testuzr/helpplz
BridgeManager settings:
Forum URL:
http://www.houstonlancers.com/forumsRelative path to your BBS's config file: ../forums/
Use post-based groups?: 1 (currently set to 1, i've tried both options with other differing settings)
Cookie name/preifx (if applicable): phpbb3_m8j8i_
the bridge file i used is from nibbler's post:
http://forum.coppermine-gallery.net/index.php/topic,53678.0.htmlI've read thru that thing several times now, and still haven't gotten anything in there to work.
Also read this post:
http://forum.coppermine-gallery.net/index.php/topic,57832.0.htmli though i should delete the underscore, but if i do, when i try to log into cpg, i get "Fatal Error" and nothing else. So i've been keeping the underscore on there
And this topic:
http://forum.coppermine-gallery.net/index.php/topic,58102.0.htmlso i turned on debug mode and this is what it looks like right before i enable bridging:
USER:
------------------
Array
(
[ID] => c92ddfb91b07b694a437696908c7f56e
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 2
[user_name] => lordtygr62
[groups] => Array
(
[0] => 1
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 3
[ufc_min] => 3
[custom_user_upload] => 0
[num_file_upload] => 5
[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] => Administrators
[upload_form_config] => 3
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
[1] => select * from cpg14x_plugins order by priority asc; (0s)
[2] => delete from `tygrdenc_halophotos`.cpg14x_sessions where time<1237696602 and remember=0; (0s)
[3] => delete from `tygrdenc_halophotos`.cpg14x_sessions where time<1236490602; (0s)
[4] => select user_id from `tygrdenc_halophotos`.cpg14x_sessions where session_id = 'c257ebb8bbdae8b0f6f26e5d3cb496d6' (0.002s)
[5] => select user_id as id, user_password as password from `tygrdenc_halophotos`.cpg14x_users where user_id=2 (0s)
[6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `tygrdenc_halophotos`.cpg14x_users AS u INNER JOIN `tygrdenc_halophotos`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='2' (0s)
[7] => SELECT user_group_list FROM `tygrdenc_halophotos`.cpg14x_users AS u WHERE user_id='2' and user_group_list <> ''; (0s)
[8] => 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 cpg14x_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 1 (0s)
[10] => update `tygrdenc_halophotos`.cpg14x_sessions set time='1237700202' where session_id = 'c257ebb8bbdae8b0f6f26e5d3cb496d6' (0s)
[11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 2 (0s)
[12] => DELETE FROM cpg14x_banned WHERE expiry < '2009-03-22 00:36:42' (0s)
[13] => SELECT * FROM cpg14x_banned WHERE (ip_addr='99.49.159.52' OR ip_addr='99.49.159.52' OR user_id=2) AND brute_force=0 (0s)
[14] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
[15] => SELECT * FROM cpg14x_bridge (0.001s)
[16] => UPDATE cpg14x_config SET value = '0' WHERE name = 'bridge_enable' (0s)
[17] => SELECT * FROM cpg14x_bridge (0s)
[18] => SELECT * FROM cpg14x_config (0s)
[19] => DELETE FROM cpg14x_usergroups WHERE 1 (0s)
[20] => INSERT INTO cpg14x_usergroups
VALUES (1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3) (0s)
[21] => INSERT INTO cpg14x_usergroups
VALUES (2, 'Registered', 1024, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3) (0s)
[22] => INSERT INTO cpg14x_usergroups
VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3) (0s)
[23] => INSERT INTO cpg14x_usergroups
VALUES (4, 'Banned', 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3) (0s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.4.9 - OK
------------------
mySQL version: 5.0.75-community-log
------------------
Coppermine version: 1.4.21(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 1
Client API version 5.0.75
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 | no value | no value
file_uploads | On | On
include_path | /usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php | /usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php
open_basedir | no value | 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 | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.095 seconds - 24 queries in 0.003 seconds - Album set : ; Meta set: ;
And:
Notices
/include/themes.inc.php
Notice line 226: Undefined variable: USER_ID
Notice line 823: Undefined variable: pm_link
/bridgemgr.php
Notice line 567: Undefined index: step
Notice line 184: Undefined index: bridge_enable
Notice line 189: Undefined index: clear_unused_db_fields
Notice line 195: Undefined variable: return
Notice line 1137: Undefined index: submit
Notice line 1154: Undefined index: short_name_used
Notice line 1154: Undefined index: license_number_used
Notice line 1154: Undefined index: db_database_name_used
Notice line 1154: Undefined index: db_hostname_used
Notice line 1154: Undefined index: db_username_used
Notice line 1154: Undefined index: db_password_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: relative_path_of_forum_from_webroot_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: logout_flag_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: table_prefix_used
Notice line 1154: Undefined index: user_table_used
Notice line 1154: Undefined index: session_table_used
Notice line 1154: Undefined index: group_table_used
Notice line 1154: Undefined index: group_relation_table_used
Notice line 1154: Undefined index: group_mapping_table_used
Notice line 1154: Undefined index: use_standard_groups_used
Notice line 1154: Undefined index: validating_group_used
Notice line 1154: Undefined index: guest_group_used
Notice line 1154: Undefined index: member_group_used
Notice line 1154: Undefined index: admin_group_used
Notice line 1154: Undefined index: banned_group_used
Notice line 1154: Undefined index: global_moderators_group_used
Notice line 1154: Undefined index: recovery_logon_failures_used
Notice line 1154: Undefined index: recovery_logon_timestamp_used
Notice line 1154: Undefined index: avatar_path_used
Notice line 1209: Undefined index: submit
And After I Enabel:
USER:
------------------
Array
(
[ID] => c92ddfb91b07b694a437696908c7f56e
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 2
[user_name] => lordtygr62
[groups] => Array
(
[0] => 1
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 3
[ufc_min] => 3
[custom_user_upload] => 0
[num_file_upload] => 5
[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] => Administrators
[upload_form_config] => 3
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
[1] => select * from cpg14x_plugins order by priority asc; (0s)
[2] => delete from `tygrdenc_halophotos`.cpg14x_sessions where time<1237696787 and remember=0; (0s)
[3] => delete from `tygrdenc_halophotos`.cpg14x_sessions where time<1236490787; (0s)
[4] => select user_id from `tygrdenc_halophotos`.cpg14x_sessions where session_id = 'c257ebb8bbdae8b0f6f26e5d3cb496d6' (0.001s)
[5] => select user_id as id, user_password as password from `tygrdenc_halophotos`.cpg14x_users where user_id=2 (0s)
[6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `tygrdenc_halophotos`.cpg14x_users AS u INNER JOIN `tygrdenc_halophotos`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='2' (0.001s)
[7] => SELECT user_group_list FROM `tygrdenc_halophotos`.cpg14x_users AS u WHERE user_id='2' and user_group_list <> ''; (0s)
[8] => 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 cpg14x_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 1 (0.001s)
[10] => update `tygrdenc_halophotos`.cpg14x_sessions set time='1237700387' where session_id = 'c257ebb8bbdae8b0f6f26e5d3cb496d6' (0s)
[11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 2 (0s)
[12] => DELETE FROM cpg14x_banned WHERE expiry < '2009-03-22 00:39:47' (0s)
[13] => SELECT * FROM cpg14x_banned WHERE (ip_addr='99.49.159.52' OR ip_addr='99.49.159.52' OR user_id=2) AND brute_force=0 (0s)
[14] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
[15] => SELECT * FROM cpg14x_bridge (0s)
[16] => UPDATE cpg14x_config SET value = '1' WHERE name = 'bridge_enable' (0s)
[17] => SELECT * FROM cpg14x_bridge (0s)
[18] => SELECT * FROM cpg14x_config (0s)
[19] => SELECT * FROM `tygrdenc_phpb1`.phpbb_groups WHERE group_name <> '' (0s)
[20] => SELECT group_id, group_name FROM cpg14x_usergroups WHERE 1 (0.001s)
[21] => DELETE FROM cpg14x_usergroups WHERE group_id = '1' LIMIT 1 (0s)
[22] => DELETE FROM cpg14x_usergroups WHERE group_id = '2' LIMIT 1 (0s)
[23] => DELETE FROM cpg14x_usergroups WHERE group_id = '3' LIMIT 1 (0s)
[24] => DELETE FROM cpg14x_usergroups WHERE group_id = '4' LIMIT 1 (0s)
[25] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('101', 'GUESTS', '0') (0s)
[26] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('102', 'REGISTERED', '0') (0s)
[27] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('103', 'REGISTERED_COPPA', '0') (0s)
[28] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('104', 'GLOBAL_MODERATORS', '0') (0s)
[29] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('105', 'ADMINISTRATORS', '1') (0s)
[30] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('106', 'BOTS', '0') (0s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
[bridge_enable] => 1
[submit] => Finish
[step] => finalize
[force_startpage] => 1
)
==========================
VERSION INFO :
------------------
PHP version: 4.4.9 - OK
------------------
mySQL version: 5.0.75-community-log
------------------
Coppermine version: 1.4.21(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 5.0.75
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 | no value | no value
file_uploads | On | On
include_path | /usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php | /usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php
open_basedir | no value | 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 | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.104 seconds - 31 queries in 0.004 seconds - Album set : ; Meta set: ;
with:
Notices
/include/themes.inc.php
Notice line 226: Undefined variable: USER_ID
Notice line 823: Undefined variable: pm_link
/bridgemgr.php
Notice line 189: Undefined index: clear_unused_db_fields
Notice line 195: Undefined variable: return
Notice line 1154: Undefined index: short_name_used
Notice line 1154: Undefined index: license_number_used
Notice line 1154: Undefined index: db_database_name_used
Notice line 1154: Undefined index: db_hostname_used
Notice line 1154: Undefined index: db_username_used
Notice line 1154: Undefined index: db_password_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: relative_path_of_forum_from_webroot_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: logout_flag_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: table_prefix_used
Notice line 1154: Undefined index: user_table_used
Notice line 1154: Undefined index: session_table_used
Notice line 1154: Undefined index: group_table_used
Notice line 1154: Undefined index: group_relation_table_used
Notice line 1154: Undefined index: group_mapping_table_used
Notice line 1154: Undefined index: use_standard_groups_used
Notice line 1154: Undefined index: validating_group_used
Notice line 1154: Undefined index: guest_group_used
Notice line 1154: Undefined index: member_group_used
Notice line 1154: Undefined index: admin_group_used
Notice line 1154: Undefined index: banned_group_used
Notice line 1154: Undefined index: global_moderators_group_used
Notice line 1154: Undefined index: recovery_logon_failures_used
Notice line 1154: Undefined index: recovery_logon_timestamp_used
Notice line 1154: Undefined index: avatar_path_used
Notice line 1209: Undefined index: wizard_finished
/bridge/phpbb3.inc.php
Notice line 44: Constant USE_BRIDGEMGR already defined
/bridge/udb_base.inc.php
Notice line 544: Undefined property: group_overrride
and if i click "home" directly after i've enabled bridging, it logs me out. debug gives this:
USER:
------------------
Array
(
[ID] => c92ddfb91b07b694a437696908c7f56e
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 0
[user_name] => Guest
[groups] => Array
(
[0] => 1
)
[group_quota] => 0
[can_rate_pictures] =>
[can_send_ecards] =>
[can_post_comments] =>
[can_upload_pictures] =>
[can_create_albums] => 0
[pub_upl_need_approval] =>
[priv_upl_need_approval] =>
[upload_form_config] =>
[num_file_upload] =>
[num_URI_upload] =>
[custom_user_upload] =>
[disk_max] =>
[disk_min] =>
[ufc_max] =>
[ufc_min] =>
[has_admin_access] => 0
[group_name] =>
[can_see_all_albums] => 0
[group_id] => 1
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
[1] => select * from cpg14x_plugins order by priority asc; (0s)
[2] => SELECT * FROM cpg14x_bridge (0s)
[3] => 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 cpg14x_usergroups WHERE group_id in (1) (0.001s)
[4] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 1 (0.001s)
[5] => DELETE FROM cpg14x_banned WHERE expiry < '2009-03-22 00:41:31' (0s)
[6] => SELECT * FROM cpg14x_banned WHERE (ip_addr='99.49.159.52' OR ip_addr='99.49.159.52' OR user_id=0) AND brute_force=0 (0s)
[7] => SELECT aid, category FROM cpg14x_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (1) (0s)
[8] => SELECT aid FROM cpg14x_albums (0s)
[9] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = '' ORDER BY name (0s)
[10] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0s)
[11] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
[12] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = '1' ORDER BY name (0s)
[13] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0s)
[14] => SELECT count(*) FROM cpg14x_albums as a WHERE 1 (0s)
[15] => SELECT count(*) FROM cpg14x_categories WHERE 1 (0s)
[16] => SELECT count(*) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
[17] => SELECT sum(hits) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON p.aid=a.aid WHERE 1 (0s)
[18] => SELECT count(*) FROM cpg14x_comments as c LEFT JOIN cpg14x_pictures as p ON c.pid=p.pid LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 (0s)
[19] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0s)
[20] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1) ORDER BY RAND() LIMIT 8 (0s)
[21] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1) (0s)
[22] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1) ORDER BY pid DESC LIMIT 0 ,8 (0s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
Page generated in 0.088 seconds - 23 queries in 0.002 seconds - Album set : ; Meta set: AND aid IN (-1) ;
with this:
Notices
/bridge/udb_base.inc.php
Notice line 114: Undefined variable: row
/include/themes.inc.php
Notice line 226: Undefined variable: USER_ID
Notice line 823: Undefined variable: pm_link
Notice line 2772: Undefined variable: loginFormHtml
/include/functions.inc.php
Notice line 88: Undefined variable: cpg_show_private_album
Notice line 109: Undefined variable: meta_album_set_array
Warning line 109: array_diff() [function.array-diff]: Argument #1 is not an array