View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
2184Composrchatpublic2016-02-10 05:362016-02-11 03:50
ReporterPDStig Assigned ToChris Graham  
PriorityhighSeverity@70@ 
Status resolvedResolutionfixed 
Summary2184: Composr 10b1: When site-wide chat message checking enabled, site errors with MySQL error
DescriptionWhen the setting to enable global checking for new chat message etc instead of just in the lobby, website errors with MYSQL error in additional info. I didn't test to see if it does this when the option is off and a user goes to the chat lobby.
Steps To Reproduce1. Enable global checking for new chat messages.
2. Go to any webpage.
3. An error is thrown.
Additional InformationUnfortunately a query has failed [SELECT COUNT(DISTINCT member_id) FROM cms_chat_active a LEFT JOIN cms_sessions s ON s.member_id=a.member_id WHERE session_invisible=0 AND date_and_time>=1455082409 LIMIT 1] [Column 'member_id' in field list is ambiguous] (version: 10 beta1, PHP version: 5.4.45, URL: /)
Stack trace…
File -> 'sources/failure.php'
Line -> 960
Function -> 'die_html_trace'
Args -> array
File -> 'sources/global2.php'
Line -> 903
Function -> '_fatal_exit'
Args -> array
File -> 'sources/database/mysqli.php'
Line -> 245
Function -> 'fatal_exit'
Args -> array
File -> 'sources/database.php'
Line -> 1,290
Function -> 'db_query'
Class -> 'Database_Static_mysqli'
Object -> O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:46:"a:2:{i:0;s:9:"admin_tlc";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}}s:14:"last_select_db";a:2:{i:0;r:3;i:1;s:9:"admin_tlc";}s:16:"reconnected_once";b:0;}
Type -> '->'
Args -> array
File -> 'sources/database.php'
Line -> 1,065
Function -> '_query'
Class -> 'DatabaseConnector'
Object -> O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:9:"admin_tlc";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:9:"admin_tlc";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:46:"a:2:{i:0;s:9:"admin_tlc";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:9:"admin_tlc";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type -> '->'
Args -> a:7:{i:0;s:163:"SELECT COUNT(DISTINCT member_id) FROM cms_chat_active a LEFT JOIN cms_sessions s ON s.member_id=a.member_id WHERE session_invisible=0 AND date_and_time>=1455082409";i:1;i:1;i:2;N;i:3;b:0;i:4;b:0;i:5;N;i:6;s:0:"";}
File -> 'sources/database.php'
Line -> 881
Function -> 'query'
Class -> 'DatabaseConnector'
Object -> O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:9:"admin_tlc";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:9:"admin_tlc";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:46:"a:2:{i:0;s:9:"admin_tlc";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:9:"admin_tlc";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type -> '->'
Args -> a:6:{i:0;s:163:"SELECT COUNT(DISTINCT member_id) FROM cms_chat_active a LEFT JOIN cms_sessions s ON s.member_id=a.member_id WHERE session_invisible=0 AND date_and_time>=1455082409";i:1;i:1;i:2;N;i:3;b:0;i:4;b:0;i:5;N;}
File -> 'sources/chat_stats.php'
Line -> 32
Function -> 'query_value_if_there'
Class -> 'DatabaseConnector'
Object -> O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:9:"admin_tlc";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:9:"admin_tlc";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:46:"a:2:{i:0;s:9:"admin_tlc";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:9:"admin_tlc";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type -> '->'
Args -> a:1:{i:0;s:163:"SELECT COUNT(DISTINCT member_id) FROM cms_chat_active a LEFT JOIN cms_sessions s ON s.member_id=a.member_id WHERE session_invisible=0 AND date_and_time>=1455082409";}
File -> 'sources/hooks/blocks/side_stats/stats_chat.php'
Line -> 43
Function -> 'get_num_chatters'
Args -> a:0:{}
File -> 'sources/blocks/side_stats.php'
Line -> 150
Function -> 'run'
Class -> 'Hook_stats_chat'
Object -> O:15:"Hook_stats_chat":0:{}
Type -> '->'
Args -> a:0:{}
File -> 'sources/zones.php'
Line -> 1,115
Function -> 'run'
Class -> 'Block_side_stats'
Object -> O:16:"Block_side_stats":0:{}
Type -> '->'
Args -> a:1:{i:0;a:3:{s:8:"failsafe";s:1:"1";s:5:"block";s:10:"side_stats";s:5:"cache";s:1:"1";}}
File -> 'sources/tempcode.php'
Line -> 1,027
Function -> 'do_block'
Args -> a:2:{i:0;s:10:"side_stats";i:1;a:2:{s:8:"failsafe";s:1:"1";s:5:"block";s:10:"side_stats";}}
File -> 'sources/symbols.php'
Line -> 2,962
Function -> 'handle_symbol_preprocessing'
Args -> a:2:{i:0;a:4:{i:0;a:0:{}i:1;i:0;i:2;s:5:"BLOCK";i:3;a:2:{i:0;s:10:"failsafe=1";i:1;s:16:"block=side_stats";}}i:1;a:0:{}}
File -> 'sources/tempcode.php(1914) : eval()'d code'
Line -> 1
Function -> 'ecv_BLOCK'
Args -> a:3:{i:0;s:2:"EN";i:1;a:0:{}i:2;a:2:{i:0;s:10:"failsafe=1";i:1;s:16:"block=side_stats";}}
File -> 'sources/tempcode.php'
Line -> 1,914
Function -> 'eval'
File -> 'sources/tempcode.php'
Line -> 180
Function -> 'evaluate'
Class -> 'Tempcode'
Object -> Tempcode -> ...
Type -> '->'
Args -> a:0:{}
File -> 'sources/tempcode.php(2049) : runtime-created function'
Line -> 1
Function -> 'otp'
Args -> array
Function -> '__lambda_func'
Args -> array
File -> 'sources/tempcode.php'
Line -> 1,911
Function -> 'call_user_func'
Args -> array
File -> 'sources/tempcode.php'
Line -> 1,133
Function -> 'evaluate'
Class -> 'Tempcode'
Object -> Tempcode -> ...
Type -> '->'
Args -> a:0:{}
File -> 'sources/symbols.php'
Line -> 1,592
Function -> 'handle_symbol_preprocessing'
Args -> a:2:{i:0;a:4:{i:0;a:0:{}i:1;i:0;i:2;s:10:"LOAD_PANEL";i:3;a:1:{i:0;s:5:"right";}}i:1;a:0:{}}
File -> 'sources/tempcode.php(2049) : runtime-created function'
Line -> 66
Function -> 'ecv_LOAD_PANEL'
Args -> a:3:{i:0;N;i:1;a:0:{}i:2;a:1:{i:0;s:5:"right";}}
Details here are intended only for the website/system-administrator, not for regular website users.
» If you are a regular website user, please let the website staff deal with this problem.

Depending on the error, and only if the website installation finished, you may need to edit the installation options (the _config.php file).

ocProducts maintains full documentation for all procedures and tools. These may be found on the Composr website. If you are unable to easily solve this problem, we may be contacted from our website and can help resolve it for you.
TagsNo tags attached.
Attach Tags
Time estimation (hours)
Sponsorship open

Sponsor

Date Added Member Amount Sponsored

Activities

PDStig

2016-02-10 05:39

administrator   ~3327

CORRECTION: The error is unrelated to sitewide IM setting. It's related to when you have chat statistics enabled for the statistics block.

Chris Graham

2016-02-11 03:50

administrator   ~3333

Fixed this and re-tested site-wide IMs. Fixed some issues.

The re-opening of windows you mentioned is gone, but it does use a window. We just do smarter window binding management (which took ages, I remember now).

Issue History

Date Modified Username Field Change