View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000449 | XMB1 | Bugs | public | 2011-03-13 20:23 | 2011-05-29 14:05 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | minor | Reproducibility | unable to reproduce |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.9.11.11 | ||||
| Target Version | 1.9.11.12 | Fixed in Version | 1.9.11.12 | ||
| Summary | 0000449: U2U Upgrade Fails if u2u.readstatus is Missing | ||||
| Description | During an upgrade of XMB 1.8 in the wild, a situation was encountered where the u2u and settings table updates from the 1.5 -> 1.6 upgrade script had not been applied. As a result, the upgrade script crashed with the following error message: MySQL encountered the following error: Unknown column 'readstatus' in 'where clause'(errno = 1054) In the following query: UPDATE xmb_u2u SET readstatus='no' WHERE readstatus='' If this becomes a common problem, it needs to be patched out of the new 1.9.x upgrade script. | ||||
| Additional Information | http://forums.xmbforum.com/viewthread.php?tid=776205&goto=search&pid=1371831 | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | |||||
| SVN Revision | 2544 | ||||
|
|
I'm thinking the best solution for XMB 1.8 upgrades is to add some code that will check for all of the expected columns in the oldest compatible version. |
|
|
I've written some code that will check the version 1.8 schema for compatibility with the new upgrade utility. The code needs to be debugged and tested but should easily make it into the next patch cycle. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-03-13 20:23 | miqrogroove | New Issue | |
| 2011-03-14 09:07 | miqrogroove | Note Added: 0000305 | |
| 2011-03-27 14:02 | miqrogroove | Note Added: 0000306 | |
| 2011-03-27 14:02 | miqrogroove | Target Version | => 1.9.11.12 |
| 2011-03-27 14:04 | miqrogroove | Status | new => confirmed |
| 2011-03-31 15:50 | miqrogroove | SVN Revision | => 2544 |
| 2011-03-31 15:50 | miqrogroove | Status | confirmed => resolved |
| 2011-03-31 15:50 | miqrogroove | Fixed in Version | => 1.9.11.12 |
| 2011-03-31 15:50 | miqrogroove | Resolution | open => fixed |
| 2011-03-31 15:50 | miqrogroove | Assigned To | => miqrogroove |
| 2011-05-29 14:05 | miqrogroove | Status | resolved => closed |
