Did you try actually registering and then replying to the email?
As an admin, I get that user has registered in gallery, but I do not get the rest of the text that says please click to validate user.
I have left debug mode on for now. Below are some error messages:
While executing query 'SELECT user_active, user_email, user_email_valid, user_name FROM cpg15x_users WHERE user_actkey = '582b45be5bba144f28d7880796d54e77' LIMIT 1' in register.php on line 708
mySQL error: Unknown column 'user_email_valid' in 'field list'
THIS IS THE CRITICAL DATABASE ERROR
Additional debug verbose info below:
USER:
------------------
Array
(
[ID] => b32becc430189535c0102e016d028ed0
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 0
[user_name] => Guest
[groups] => Array
(
[0] => 3
)
[group_quota] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 0
[can_post_comments] => 0
[can_upload_pictures] => 0
[can_create_albums] => 0
[pub_upl_need_approval] => 1
[priv_upl_need_approval] => 1
[access_level] => 2
[disk_max] => 0
[disk_min] => 0
[has_admin_access] => 0
[group_name] => Guests
[can_create_public_albums] => 0
[can_see_all_albums] => 0
[group_id] => 3
[allowed_albums] => Array
(
)
)
==========================
Queries:
------------------
Array
(
[0] => SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (0 ms)
[1] => SELECT * FROM cpg15x_plugins ORDER BY priority [include/plugin_api.inc.php:54] (0 ms)
[2] => SELECT user_id, time FROM `emrguru_album`.cpg15x_sessions WHERE session_id = 'bb09bdc583bef336f9c5bb92482ce03e' [bridge/coppermine.inc.php:264] (1 ms)
[3] => SELECT user_id, user_password FROM `emrguru_album`.cpg15x_users WHERE user_id = 0 [bridge/coppermine.inc.php:276] (0 ms)
[4] => 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 (3) [bridge/udb_base.inc.php:323] (0 ms)
[5] => SELECT group_name FROM cpg15x_usergroups WHERE group_id= 3 [bridge/udb_base.inc.php:327] (1 ms)
[6] => SELECT COUNT(*) FROM cpg15x_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:340] (0 ms)
[7] => UPDATE `emrguru_album`.cpg15x_sessions SET time = 1309465440 WHERE session_id = 'bb09bdc583bef336f9c5bb92482ce03e' [bridge/coppermine.inc.php:321] (0 ms)
[8] => SELECT aid FROM cpg15x_albums WHERE moderator_group IN (3) [include/init.inc.php:271] (0 ms)
[9] => SELECT lang_id FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms)
[10] => DELETE FROM cpg15x_banned WHERE expiry < '2011-06-30 15:24:00' [include/init.inc.php:443] (0 ms)
[11] => SELECT null FROM cpg15x_banned WHERE ('68.239.48.130' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms)
[12] => SELECT aid FROM cpg15x_albums WHERE (1 AND visibility != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:976] (0 ms)
[13] => SELECT user_active, user_email, user_email_valid, user_name FROM cpg15x_users WHERE user_actkey = '582b45be5bba144f28d7880796d54e77' LIMIT 1 [register.php:708] (0 ms)
)
==========================
GET :
------------------
Array
(
[activate] => 582b45be5bba144f28d7880796d54e77
)
==========================
POST :
------------------
Array
(
)
==========================
COOKIE :
------------------
Array
(
[c7d1c5341a4ac90a63fa73ff9c53dcdb] => 30df64b1547a6c29bd52cef2be4ba28c
[cpg15x_data] => YTozOntzOjI6IklEIjtzOjMyOiJiMzJiZWNjNDMwMTg5NTM1YzAxMDJlMDE2ZDAyOGVkMCI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjt9
[PHPSESSID] => c083760a0d7317910c737639a27048b4
)
==========================
SESSION :
------------------
Array
(
)
==========================
UPON REGISTRATION:
USER:
------------------
Array
(
[ID] => b32becc430189535c0102e016d028ed0
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 0
[user_name] => Guest
[groups] => Array
(
[0] => 3
)
[group_quota] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 0
[can_post_comments] => 0
[can_upload_pictures] => 0
[can_create_albums] => 0
[pub_upl_need_approval] => 1
[priv_upl_need_approval] => 1
[access_level] => 2
[disk_max] => 0
[disk_min] => 0
[has_admin_access] => 0
[group_name] => Guests
[can_create_public_albums] => 0
[can_see_all_albums] => 0
[group_id] => 3
[allowed_albums] => Array
(
)
)
==========================
Queries:
------------------
Array
(
[0] => SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (0 ms)
[1] => SELECT * FROM cpg15x_plugins ORDER BY priority [include/plugin_api.inc.php:54] (0 ms)
[2] => SELECT user_id, time FROM `emrguru_album`.cpg15x_sessions WHERE session_id = 'bb09bdc583bef336f9c5bb92482ce03e' [bridge/coppermine.inc.php:264] (0 ms)
[3] => SELECT user_id, user_password FROM `emrguru_album`.cpg15x_users WHERE user_id = 0 [bridge/coppermine.inc.php:276] (0 ms)
[4] => 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 (3) [bridge/udb_base.inc.php:323] (0 ms)
[5] => SELECT group_name FROM cpg15x_usergroups WHERE group_id= 3 [bridge/udb_base.inc.php:327] (0 ms)
[6] => SELECT COUNT(*) FROM cpg15x_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:340] (0 ms)
[7] => UPDATE `emrguru_album`.cpg15x_sessions SET time = 1309465350 WHERE session_id = 'bb09bdc583bef336f9c5bb92482ce03e' [bridge/coppermine.inc.php:321] (0 ms)
[8] => SELECT aid FROM cpg15x_albums WHERE moderator_group IN (3) [include/init.inc.php:271] (0 ms)
[9] => SELECT lang_id FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms)
[10] => DELETE FROM cpg15x_banned WHERE expiry < '2011-06-30 15:22:30' [include/init.inc.php:443] (0 ms)
[11] => SELECT null FROM cpg15x_banned WHERE ('68.239.48.130' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms)
[12] => SELECT aid FROM cpg15x_albums WHERE (1 AND visibility != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:976] (0 ms)
[13] => SELECT null FROM cpg15x_users WHERE user_name = 'bananas' [register.php:488] (4 ms)
[14] => SELECT null FROM cpg15x_banned WHERE user_name = 'bananas' AND brute_force = 0 LIMIT 1 [register.php:533] (2 ms)
[15] => SELECT null FROM cpg15x_banned WHERE email = 'mpatelkaval@yahoo.com' AND brute_force = 0 LIMIT 1 [register.php:541] (0 ms)
[16] => SELECT null FROM cpg15x_users WHERE user_email = 'mpatelkaval@yahoo.com' [register.php:565] (3 ms)
[17] => INSERT INTO cpg15x_users (user_regdate, user_active, user_actkey, user_name, user_password, user_email, user_profile1, user_profile2, user_profile3, user_profile4, user_profile5, user_profile6, user_language) VALUES (NOW(), 'NO', '582b45be5bba144f28d7880796d54e77', 'bananas', '098f6bcd4621d373cade4e832627b4f6', 'mpatelkaval@yahoo.com', 'test', '', '', 'test', '', '', 'english') [register.php:594] (1 ms)
[18] => SELECT user_id, user_email, user_language FROM cpg15x_users WHERE user_group = 1 [register.php:642] (0 ms)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
[username] => bananas
[password] => test
[password_verification] => test
[email] => mpatelkaval@yahoo.com
[user_profile1] => test
[user_profile2] =>
[user_profile3] =>
[user_profile4] => test
[user_profile5] =>
[user_profile6] =>
[agree] => 1
[recaptcha_challenge_field] => 03AHJ_Vus1yftBn5M_MCrffdqVgHNVBovqvQ-GTZT5y87BaT-i0aoQFvwjvlOk4gnnOnII-QEuOuIOrKS7h1L5ULHOAluVDvyvlZQsyY6FwIaKmxsdJAU8Q29T1DrASgN23hLEQZpJz3GwRbJxVX872vk-k4GlokKZDg
[recaptcha_response_field] => major bumenta
[submit] => Submit registration
)
==========================
COOKIE :
------------------
Array
(
[c7d1c5341a4ac90a63fa73ff9c53dcdb] => 30df64b1547a6c29bd52cef2be4ba28c
[cpg15x_data] => YTozOntzOjI6IklEIjtzOjMyOiJiMzJiZWNjNDMwMTg5NTM1YzAxMDJlMDE2ZDAyOGVkMCI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjt9
[PHPSESSID] => c083760a0d7317910c737639a27048b4
)
==========================
SESSION :
------------------
Array
(
)
==========================
Thanks,
-Mahesh