View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1723 | Composr | core_cleanup_tools | public | 2014-11-15 05:27 | 2014-11-18 03:02 |
| Reporter | PDStig | Assigned To | Guest | ||
| Priority | normal | Severity | minor | ||
| Status | resolved | Resolution | fixed | ||
| Summary | 1723: Error in MySQL when trying to recalculate member statistics | ||||
| Description | When attempting to recalculate statistics for a member, I am presented with the following error: Unfortunately a query has failed [UPDATE {prefix}_f_members SET m_cache_warnings=0 WHERE (id=1 AND w_is_warning=1) LIMIT 1] [Unknown column 'w_is_warning' in 'where clause'] (version: 9.0.15, PHP version: 5.4.34, URL: /adminzone/pg/admin_cleanup/rebuild) (where {prefix} is the MySQL table prefix, which I edited out here for security) | ||||
| Steps To Reproduce | Use website cleanup tools to recalculate member stats | ||||
| Additional Information | I believe this is in connection with the attempted bug fix regarding incorrect counts of formal warnings on user punishment audit pages. w_is_warning ... should this be m_is_warning ? | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Attached Files | |||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
Ignore m_is_warning remark ... apparently this is trying to access w_is_warning column in the f_members table instead of the f_warnings table |
|
|
Automated response: Error when when trying to recalculate member statistics An "Unknown column 'w_is_warning' in 'where clause'" error is returned due to a coding error in this release. |
|
|
Fixed in git commit 6e2b047 (https://github.com/chrisgraham/Composr/commit/6e2b047 - link will become active once code pushed) A hotfix (a TAR of files to upload) have been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/). |
|
|
Thank you. This note is to confirm that the hotfix has fixed the issue. |
