#1723 - Error in MySQL when trying to recalculate member statistics
-
By PDStig
- Added
- 3 views
| Identifier | #1723 |
|---|---|
| Issue type | Minor issue (breaks specific functionality) |
| Title | Error in MySQL when trying to recalculate member statistics |
| Status | Completed |
| Handling member | PDStig |
| Addon | core_cleanup_tools |
| 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 ? |
| Funded? | No |
| Commits |
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
An "Unknown column 'w_is_warning' in 'where clause'" error is returned due to a coding error in this release.