View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000427 | XMB1 | Bugs | public | 2011-01-28 16:10 | 2011-02-11 09:45 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | crash | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 1.9.11.11 | ||||
| Summary | 0000427: ALTER TABLE Failure in MySQL 5.5 | ||||
| Description | This error was generated by trying to perform an XMB upgrade from version 1.8 to the mysql55x branch using the upgrade.php script. Requesting to lock the forums table... Gathering schema information from the forums table... Making room for the new values in the postperm column... Restructuring the forum permissions data... Deleting/Modifying columns in the forums table... MySQL encountered the following error: Incorrect integer value: '' for column 'theme' at row 1(errno = 1366) In the following query: ALTER TABLE xmb2_forums DROP COLUMN private, DROP COLUMN pollstatus, DROP COLUMN guestposting, MODIFY COLUMN lastpost varchar(54) NOT NULL default '', MODIFY COLUMN theme smallint(3) NOT NULL default 0, MODIFY COLUMN password varchar(32) NOT NULL default '', MODIFY COLUMN name varchar(128) NOT NULL default '', MODIFY COLUMN posts int(10) NOT NULL default 0, MODIFY COLUMN threads int(10) NOT NULL default 0, ADD INDEX (fup), ADD INDEX (type), ADD INDEX (displayorder), ADD INDEX (status) | ||||
| Tags | No tags attached. | ||||
| MySQL Version | 5.5.8 | ||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | |||||
| SVN Revision | 2447 | ||||
| child of | 0000408 | closed | miqrogroove | MySQL 5.5 Compatibility |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-01-28 16:10 | miqrogroove | New Issue | |
| 2011-01-28 16:10 | miqrogroove | MySQL Version | => 5.5.8 |
| 2011-01-28 16:10 | miqrogroove | Relationship added | child of 0000408 |
| 2011-01-28 16:12 | miqrogroove | Description Updated | |
| 2011-01-28 16:27 | miqrogroove | Status | new => assigned |
| 2011-01-28 16:27 | miqrogroove | Assigned To | => miqrogroove |
| 2011-01-28 17:56 | miqrogroove | SVN Revision | => 2447 |
| 2011-01-28 17:56 | miqrogroove | Status | assigned => resolved |
| 2011-01-28 17:56 | miqrogroove | Fixed in Version | => 1.9.11.11 |
| 2011-01-28 17:56 | miqrogroove | Resolution | open => fixed |
| 2011-02-11 09:45 | miqrogroove | Status | resolved => closed |
