View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000715 | XMB1 | Bugs | public | 2024-08-22 04:45 | 2024-08-23 11:50 |
| Reporter | Belle | Assigned To | miqrogroove | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 1.9.12.06 | ||||
| Target Version | 1.9.12.07 | Fixed in Version | 1.9.12.07 | ||
| Summary | 0000715: Cannot change avatars on/off in user ranks | ||||
| Description | After changing the avatar to 'off' for the newbie members in User Ranks, I am met with a MySQL error. This is replicated on a fresh install, as well as the Softaculous demo for the forum. Debug says: MySQL encountered the following error: Incorrect integer value: '' for column `(mysql server for the xmb forum here)`.`xmbnr_ranks`.`posts` at row 1 (errno = 1366) In the following query: UPDATE xmbnr_ranks SET title='', posts='', stars='1', allowavatars='no', avatarrank='' WHERE id='1' | ||||
| Steps To Reproduce | Administration Panel > User Ranks > Change 'Avatars' off/on | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | |||||
| SVN Revision | 3062 | ||||
| related to | 0000701 | closed | miqrogroove | When all post based ranks are removed viewthread.php generates Warnings |
|
|
This might be something specific to mysql servers configured for strict mode. I will look into it and the fix should be simple. |
|
|
While the error-level message is specific to MySQL strict mode, the Newbie rank editor itself was partly broken by a recent patch. |
|
|
Thank you for reporting this bug. The latest copy of cp2.php should be all you need. https://sourceforge.net/p/xmb-forum/code/HEAD/tree/xmb19x/trunk/source/cp2.php?format=raw |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-08-22 04:45 | Belle | New Issue | |
| 2024-08-22 13:00 | miqrogroove | Assigned To | => miqrogroove |
| 2024-08-22 13:00 | miqrogroove | Status | new => acknowledged |
| 2024-08-22 13:00 | miqrogroove | Note Added: 0000518 | |
| 2024-08-23 08:13 | miqrogroove | Relationship added | related to 0000701 |
| 2024-08-23 08:15 | miqrogroove | Status | acknowledged => assigned |
| 2024-08-23 08:15 | miqrogroove | Target Version | => 1.9.12.07 |
| 2024-08-23 08:15 | miqrogroove | Note Added: 0000519 | |
| 2024-08-23 11:50 | miqrogroove | Status | assigned => resolved |
| 2024-08-23 11:50 | miqrogroove | Resolution | open => fixed |
| 2024-08-23 11:50 | miqrogroove | Fixed in Version | => 1.9.12.07 |
| 2024-08-23 11:50 | miqrogroove | SVN Revision | => 3062 |
| 2024-08-23 11:50 | miqrogroove | Note Added: 0000520 |
