View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003811 | Composr alpha bug reports | [All Projects] General / Uncategorised | public | 2019-06-01 20:15 | 2019-06-09 20:58 |
| Reporter | Salman | Assigned To | Chris Graham | ||
| Severity | Feature-request | ||||
| Status | resolved | Resolution | fixed | ||
| Summary | 0003811: Query error in Hook_member_boxes_buildr::run() in v11 | ||||
| Description | I am getting the following error inside member tooltips: A query has failed [SELECT m.*,r.*,rm.name AS room_name FROM cms11_w_members m JOIN cms11_w_realms r ON m.location_realm=r.id JOIN cms11_w_rooms rm ON r.location_x=rm.location_x AND r.location_y=rm.location_y AND r.location_realm=rm.location_realm WHERE (m.id=4) LIMIT 1] [Unknown column 'r.location_x' in 'on clause'] The culprit is the following line (# 51) in "sources_custom/hooks/systems/member_boxes/buildr.php": $rows = $GLOBALS['SITE_DB']->query_select('w_members m JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'w_realms r ON m.location_realm=r.id JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'w_rooms rm ON r.location_x=rm.location_x AND r.location_y=rm.location_y AND r.location_realm=rm.location_realm', array('m.*', 'r.*', 'rm.name AS room_name'), array('m.id' => $member_id), '', 1); I tried to find a fix but the `w_realms` table doesn't have `location_x` and `location_y` columns in any repo branch so I'm not sure what needs to be done. | ||||
| Steps To Reproduce | 1. Go to Forum home 2. Hover over a member's name (e.g., in the "Last Post" column of a forum group). | ||||
| Tags | No tags attached. | ||||
| Sponsorship open | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-06-01 20:15 | Salman | New Issue | |
| 2019-06-01 20:15 | Salman | Description Updated | View Revisions |
| 2019-06-09 20:58 | Chris Graham | Assigned To | => Chris Graham |
| 2019-06-09 20:58 | Chris Graham | Status | non-assigned => resolved |
| 2019-06-09 20:58 | Chris Graham | Resolution | open => fixed |
| 2019-06-09 20:58 | Chris Graham | Note Added: 0005961 | |
| 2023-02-26 18:29 | Chris Graham | Category | General => General / Uncategorised |
