View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000812 | XMB1 | Bugs | public | 2025-07-10 16:14 | 2025-07-10 16:23 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 1.9.8 SP2 | ||||
| Target Version | 1.10.00 | Fixed in Version | 1.10.00 | ||
| Summary | 0000812: Prune Query Error | ||||
| Description | Anyone who attempts to use the Prune feature with the "Normal" checkbox not selected will see something like this: MySQL encountered the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1 OR closed == 'yes')' at line 1 (errno = 1064) In the following query: SELECT tid, fid FROM xmb_threads WHERE fid IN (8) AND lastpost < "1739228972" AND topped != 1 AND (topped == 1 OR closed == 'yes') | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | |||||
| SVN Revision | |||||
| Git Commit | https://github.com/miqrogroove/xmb/commit/0ad528e94c742b42be32f580c57e181084905520 | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-07-10 16:14 | miqrogroove | New Issue | |
| 2025-07-10 16:15 | miqrogroove | Assigned To | => miqrogroove |
| 2025-07-10 16:15 | miqrogroove | Status | new => assigned |
| 2025-07-10 16:23 | miqrogroove | Status | assigned => resolved |
| 2025-07-10 16:23 | miqrogroove | Resolution | open => fixed |
| 2025-07-10 16:23 | miqrogroove | Fixed in Version | => 1.10.00 |
| 2025-07-10 16:23 | miqrogroove | Git Commit | => https://github.com/miqrogroove/xmb/commit/0ad528e94c742b42be32f580c57e181084905520 |
