View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000217 | XMB1 | Bugs | public | 2008-12-09 01:23 | 2009-01-07 21:51 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.9.11 Beta 2 | ||||
| Target Version | 1.9.11 | Fixed in Version | 1.9.11 | ||
| Summary | 0000217: Thread Merge Causes SQL Error | ||||
| Description | [09-Dec-2008 02:21:48] PHP Fatal error: MySQL encountered the following error: Column 'username' cannot be null (errno = 1048) In the following query: UPDATE xmb_favorites AS f INNER JOIN xmb_members AS m ON m.username = f.username INNER JOIN (SELECT username, COUNT(*) AS fcount FROM xmb_favorites AS f2 WHERE tid=773648) AS query2 ON m.username = query2.username SET f.tid=773648 WHERE f.tid='773649' AND query2.fcount=0 in db/mysql.php on line 162 | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | |||||
| SVN Revision | 1485 | ||||
| Git Commit | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2008-12-09 01:23 | miqrogroove | New Issue | |
| 2008-12-09 01:25 | miqrogroove | Status | new => assigned |
| 2008-12-09 01:25 | miqrogroove | Assigned To | => miqrogroove |
| 2008-12-09 01:37 | miqrogroove | SVN Revision | => 1485 |
| 2008-12-09 01:37 | miqrogroove | Status | assigned => resolved |
| 2008-12-09 01:37 | miqrogroove | Fixed in Version | => 1.9.11 |
| 2008-12-09 01:37 | miqrogroove | Resolution | open => fixed |
| 2009-01-07 21:51 | miqrogroove | Status | resolved => closed |
