View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000296 | XMB1 | Bugs | public | 2009-03-05 06:47 | 2010-01-23 18:18 |
| Reporter | kuba1 | Assigned To | miqrogroove | ||
| Priority | normal | Severity | minor | Reproducibility | random |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.9.11 | ||||
| Target Version | 1.9.11.04 | Fixed in Version | 1.9.11.04 | ||
| Summary | 0000296: MySQL STRICT_ALL_TABLES Incompatibility | ||||
| Description | Upon installation MySQL encountered the following error: Field 'bboffreason' doesn't have a default value(errno = 1364) In the following query: INSERT INTO xmb_settings SET siteurl = 'http://127.0.0.1/xmb/files/', tickercontents = 'Welcome to your new XMB Forum! We recommend changing your forums cp.php?action=settings first.' | ||||
| Additional Information | http://forums.xmbforum.com/viewthread.php?tid=774160 | ||||
| Tags | No tags attached. | ||||
| MySQL Version | 5.1.31 | ||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | akamo | ||||
| SVN Revision | 1783 | ||||
|
|
Scrapping the schema changes now due to [07-Mar-2009 07:14:37] MySQL encountered the following error: BLOB/TEXT column can't have a default value |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2009-03-05 06:47 | kuba1 | New Issue | |
| 2009-03-05 08:55 | miqrogroove | MySQL Version | => >=5.0.2 |
| 2009-03-05 08:55 | miqrogroove | Flags | => Schema Updates |
| 2009-03-05 08:55 | miqrogroove | Original Reporter | => akamo |
| 2009-03-05 08:55 | miqrogroove | Reproducibility | have not tried => random |
| 2009-03-05 08:55 | miqrogroove | Status | new => confirmed |
| 2009-03-05 08:55 | miqrogroove | Projection | none => major rework |
| 2009-03-05 08:55 | miqrogroove | Product Version | 1.9.11.03 => 1.9.11 |
| 2009-03-05 08:55 | miqrogroove | Target Version | => 1.9.11.04 |
| 2009-03-05 08:55 | miqrogroove | Additional Information Updated | |
| 2009-03-05 08:56 | miqrogroove | Summary | null string / null STRICT_ALL_TABLES => MySQL STRICT_ALL_TABLES Incompatibility |
| 2009-03-05 16:13 | miqrogroove | Status | confirmed => assigned |
| 2009-03-05 16:13 | miqrogroove | Assigned To | => miqrogroove |
| 2009-03-06 08:08 | miqrogroove | MySQL Version | >=5.0.2 => 5.1.31 |
| 2009-03-06 08:10 | miqrogroove | ETA | none => < 1 week |
| 2009-03-07 08:26 | miqrogroove | Flags | Schema Updates => |
| 2009-03-07 08:26 | miqrogroove | Note Added: 0000167 | |
| 2009-03-07 09:38 | miqrogroove | SVN Revision | => 1783 |
| 2009-03-07 09:38 | miqrogroove | Status | assigned => resolved |
| 2009-03-07 09:38 | miqrogroove | Fixed in Version | => 1.9.11.04 |
| 2009-03-07 09:38 | miqrogroove | Resolution | open => fixed |
| 2010-01-23 18:18 | miqrogroove | Status | resolved => closed |
