| Anonymous | Login | Signup for a new account | 2010-07-29 13:10 CDT |
| My View | View Issues | My Account |
| Viewing Issue Simple Details [ Jump to Notes ] | [ View Advanced ] [ Issue History ] [ Print ] | ||||||||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||||
| 0003989 | [MindTouch] UI | major | @0@ | 2008-05-12 18:39 | 2008-07-18 14:09 | ||||||||
| Reporter | MaxM | View Status | public | ||||||||||
| Assigned To | MaxM | ||||||||||||
| Priority | normal | Resolution | fixed | ||||||||||
| Status | resolved | ||||||||||||
| Summary | 0003989: Error when creating users with MySql running in strict mode | ||||||||||||
| Description |
The below error was reported here http://forums.opengarden.org/showpost.php?p=14181&postcount=8 [^] This was introduced in 8.05 by r8417 where user_options is no longer being set for the user insert query. Since the user_options field is a blob and is non-nullable it requires a value upon insert when mysql is running in strict mode. By default mysql will accept no value and save an empty string. As a temporary workaround until the next service release, set mysql to operate in non-strict mode. More info here: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html [^] |
||||||||||||
| Additional Information |
Request URI: http://localhost:8081/deki/users?dream.out.format=php&dream.in.host=wiki.lavenderdigital.com.au&dream.in.scheme=http&dream.in.origin=192.168.203.66&accountpassword=xxx [^] Server response: Array ( [exception] => Array ( [message] => Field 'user_options' doesn't have a default value [source] => MySql.Data [stacktrace] => Array ( [frame] => Array ( [0] => MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000] [1] => MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000] [2] => MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000] [3] => MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000] ) ) [type] => MySql.Data.MySqlClient.MySqlException ) ) |
||||||||||||
| Tags | No tags attached. | ||||||||||||
| From Customer | No | ||||||||||||
| Likelihood | Affects average number of users | ||||||||||||
| Platform | All | ||||||||||||
| Regression | No | ||||||||||||
| Skin | All | ||||||||||||
| Version | trunk | ||||||||||||
| Target Release | 8.05.1 | ||||||||||||
| Browser | , All, | ||||||||||||
| Days Left | 0.5 | ||||||||||||
| Attached Files | |||||||||||||
|
|
|||||||||||||
 Relationships |
|
|
Notes |
|
|
(0007422) MaxM (developer) 2008-05-12 18:40 |
Fixed in trunk r8504 |
|
(0008323) MaxM (developer) 2008-07-18 13:51 |
A strict related fix to data.sql was applied in trunk r9574 |
|
(0008325) MaxM (developer) 2008-07-18 14:09 |
upgrade scripts fixed in trunk r9575 |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-05-12 18:39 | MaxM | New Issue | |
| 2008-05-12 18:39 | MaxM | Branch | => trunk |
| 2008-05-12 18:39 | MaxM | Target release | => future |
| 2008-05-12 18:39 | MaxM | Browser | => All |
| 2008-05-12 18:39 | MaxM | Status | new => assigned |
| 2008-05-12 18:39 | MaxM | Assigned To | => MaxM |
| 2008-05-12 18:40 | MaxM | Note Added: 0007422 | |
| 2008-05-12 18:40 | MaxM | Status | assigned => resolved |
| 2008-05-12 18:40 | MaxM | Resolution | open => fixed |
| 2008-05-13 00:26 | RoyK | Target release | future => 8.05.1 |
| 2008-07-18 13:51 | MaxM | Note Added: 0008323 | |
| 2008-07-18 14:09 | MaxM | Note Added: 0008325 | |
| 2008-09-25 18:02 | RoyK | Target Releases | => 8.05.1 |
| Mantis 1.1.1[^] Copyright © 2000 - 2008 Mantis Group |  |