#3589 - Error when submitting and viewing tickets
| Identifier | #3589 |
|---|---|
| Issue type | Feature request or suggestion |
| Title | Error when submitting and viewing tickets |
| Status | Completed |
| Handling member | Chris Graham |
| Addon | 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) |
| Steps to reproduce | |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".


Comments
https://bosslife.org/errors/error.htm
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.
Stack:
https://bosslife.org/errors/newerror.htm
Fixed in https://github.com/ocproducts/composr/commit/2296fb769c01366b198c3a69eec3759266e08ac5