View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003589 | Composr | tickets | public | 2018-04-23 01:31 | 2018-05-03 02:26 |
| Reporter | Joe | Assigned To | Chris Graham | ||
| Severity | Feature-request | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0003589: Error when submitting and viewing tickets | ||||
| Description | Unfortunately a query has failed ... [Unknown column 'mf_member_id' in 'where clause'] (version: 10.0.15, PHP version: 5.6.30, URL: /tickets/ticket/2_5add3646b6510.htm?redirected=1) | ||||
| Tags | No tags attached. | ||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
| has duplicate | 0003613 | closed | Chris Graham | Query has failed |
|
|
Please provide more detail. You've removed the actual failing query from the error message you posted, which is the most critical part of it for debugging. I cannot reproduce it; possibly I can with deep code analysis, but that is time consuming. |
|
|
Sorry, it was pretty long. I've uploaded the page here: https://bosslife.org/errors/error.htm |
|
|
Thanks. This looks like a bug after Comcode field precalculation is cleared. I'll try and get a fix out to you tomorrow. |
|
|
Fixed in https://github.com/ocproducts/composr/commit/b5e01e52cc5e930eddec83bc7885c9f35ad8d57d This is a class of bug that happens when the Comcode cache ("Comcode field precalculations" OTTOMH) is cleared. Composr has to update the parsed Comcode back into the database when it is missing, but if we have JOINed tables in the data row it tries to save alien data back into the row; we have to pre-filter out what is in the row. Usually we do it right, but there are 100s of cases in the code for us to get it wrong. I think I remember you having a similar issue before. |
|
|
PHP NOTICE [8] Undefined index: in sources/database.php on line 83 (version: 10.0.15, PHP version: 5.6.30, URL: /tickets/ticket/2_5ae83ddc6693e.htm) Stack: https://bosslife.org/errors/newerror.htm |
|
|
Ergh, sorry, yes. I accidentally triggered an undo in my editor before committing. Fixed in https://github.com/ocproducts/composr/commit/2296fb769c01366b198c3a69eec3759266e08ac5 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-04-23 01:31 | Joe | New Issue | |
| 2018-04-24 15:13 | Chris Graham | Note Added: 0005674 | |
| 2018-04-24 15:13 | Chris Graham | Status | non-assigned => closed |
| 2018-04-24 15:13 | Chris Graham | Assigned To | => Chris Graham |
| 2018-04-24 15:13 | Chris Graham | Resolution | open => unable to reproduce |
| 2018-04-24 19:23 | Joe | Note Added: 0005676 | |
| 2018-04-29 23:47 | Chris Graham | Note Added: 0005685 | |
| 2018-04-30 15:43 | Chris Graham | Note Added: 0005686 | |
| 2018-04-30 15:43 | Chris Graham | Status | closed => resolved |
| 2018-04-30 15:43 | Chris Graham | Resolution | unable to reproduce => fixed |
| 2018-05-01 10:39 | Joe | Note Added: 0005687 | |
| 2018-05-01 10:39 | Joe | Status | resolved => non-assigned |
| 2018-05-01 10:39 | Joe | Resolution | fixed => reopened |
| 2018-05-03 02:26 | Chris Graham | Note Added: 0005691 | |
| 2018-05-03 02:26 | Chris Graham | Status | non-assigned => resolved |
| 2018-05-03 02:26 | Chris Graham | Resolution | reopened => fixed |
| 2018-05-21 18:33 | Chris Graham | Relationship added | has duplicate 0003613 |
