View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000313 | XMB1 | Bugs | public | 2009-03-22 12:57 | 2010-01-23 18:18 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | minor | Reproducibility | random |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.9.10 | ||||
| Target Version | 1.9.11.06 | Fixed in Version | 1.9.11.06 | ||
| Summary | 0000313: Error in Memcp With Empty Forum List | ||||
| Description | [22-Mar-2009 11:52:23] 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 ') ORDER BY t.lastpost DESC LIMIT 0,5' at line 1 (errno = 1064) In the following query: SELECT t.tid, t.fid, t.lastpost, t.subject, t.icon, t.replies FROM xmb2_favorites f INNER JOIN xmb2_threads t USING (tid) WHERE f.username='testuser' AND f.type='favorite' AND t.fid IN () ORDER BY t.lastpost DESC LIMIT 0,5 | ||||
| Steps To Reproduce | Remove all forum permissions, then hit the memcp. | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | |||||
| SVN Revision | 1830 | ||||
|
|
This issue needs to be expanded per http://svn.xmbforum.com/phpxref/_functions/permittedforums.html |
|
|
Still investigating related legacy issues. There are some data type issues in stats.php for example. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2009-03-22 12:57 | miqrogroove | New Issue | |
| 2009-03-22 12:58 | miqrogroove | Status | new => confirmed |
| 2009-03-22 12:58 | miqrogroove | Projection | none => tweak |
| 2009-03-22 13:18 | miqrogroove | Status | confirmed => assigned |
| 2009-03-22 13:18 | miqrogroove | Assigned To | => miqrogroove |
| 2009-03-22 13:39 | miqrogroove | SVN Revision | => 1825 |
| 2009-03-22 13:39 | miqrogroove | Status | assigned => resolved |
| 2009-03-22 13:39 | miqrogroove | Fixed in Version | => 1.9.11.06 |
| 2009-03-22 13:39 | miqrogroove | Resolution | open => fixed |
| 2009-03-22 14:21 | miqrogroove | Note Added: 0000188 | |
| 2009-03-22 14:21 | miqrogroove | Status | resolved => feedback |
| 2009-03-22 14:21 | miqrogroove | Resolution | fixed => reopened |
| 2009-03-22 15:04 | miqrogroove | Note Added: 0000189 | |
| 2009-03-22 15:04 | miqrogroove | Status | feedback => assigned |
| 2009-03-22 15:04 | miqrogroove | Product Version | 1.9.11 => 1.9.10 |
| 2009-03-22 15:04 | miqrogroove | Fixed in Version | 1.9.11.06 => |
| 2009-03-22 16:44 | miqrogroove | SVN Revision | 1825 => 1830 |
| 2009-03-22 16:44 | miqrogroove | Status | assigned => resolved |
| 2009-03-22 16:44 | miqrogroove | Fixed in Version | => 1.9.11.06 |
| 2009-03-22 16:44 | miqrogroove | Resolution | reopened => fixed |
| 2010-01-23 18:18 | miqrogroove | Status | resolved => closed |
