 Relationships |
|
| Anonymous | Login | Signup for a new account | 2012-09-13 19:31 PDT |
| Main | Blog | My View | View Issues | Change Log | Roadmap | IRC Chat | Repositories | Scrum Board |
| View Issue Details [ Jump to Notes ] [ Related Changesets ] | [ Issue History ] [ Print ] | |||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||
| 032 | Source Integration | [All Projects] General | public | 2009-04-30 01:20 | 2009-05-01 07:22 | |||
| Reporter | gransi | |||||||
| Assigned To | John Reese | |||||||
| Priority | normal | Severity | crash | Reproducibility | always | |||
| Status | resolved | Resolution | fixed | |||||
| Product Version | 0.13 | |||||||
| Target Version | 0.14 | Fixed in Version | 0.14 | |||||
| Summary | 032: Install Plugin - Create Tables fails MySql 5.x | |||||||
| Description | My Enviroment: -Mantis 1.2a3 -MySql 5.1.11 -PHP 5.2.9 -Apache 2.2.11 (WAMP-Server on Windows XP SP3) Mantis throws the following error on install the source plugin: APPLICATION ERROR #2503 Upgrading the plugin schema failed in block #0. | |||||||
| Additional Information | The MySql 5.x cannot create BLOB and TEXT columns with DEFAULT values, see Manual http://dev.mysql.com/doc/refman/5.0/en/blob.html [^] It works after i changed the source.php ("function schema()") From: array( 'CreateTableSQL', array( plugin_table( 'repository' ), " id I NOTNULL UNSIGNED AUTOINCREMENT PRIMARY, type C(8) NOTNULL DEFAULT \" '' \" PRIMARY, name C(128) NOTNULL DEFAULT \" '' \" PRIMARY, url C(250) DEFAULT \" '' \", info XL NOTNULL DEFAULT \" '' \" " ) ), array( 'CreateTableSQL', array( plugin_table( 'changeset' ), " id I NOTNULL UNSIGNED AUTOINCREMENT PRIMARY, repo_id I NOTNULL UNSIGNED PRIMARY, revision C(250) NOTNULL PRIMARY, branch C(250) NOTNULL DEFAULT \" '' \", user_id I NOTNULL UNSIGNED DEFAULT '0', timestamp T NOTNULL, author C(250) NOTNULL DEFAULT \" '' \", message XL NOTNULL DEFAULT \" '' \", info XL NOTNULL DEFAULT \" '' \" " ) ), To: array( 'CreateTableSQL', array( plugin_table( 'repository' ), " id I NOTNULL UNSIGNED AUTOINCREMENT PRIMARY, type C(8) NOTNULL DEFAULT \" '' \" PRIMARY, name C(128) NOTNULL DEFAULT \" '' \" PRIMARY, url C(250) DEFAULT \" '' \", info XL " ) ), array( 'CreateTableSQL', array( plugin_table( 'changeset' ), " id I NOTNULL UNSIGNED AUTOINCREMENT PRIMARY, repo_id I NOTNULL UNSIGNED PRIMARY, revision C(250) NOTNULL PRIMARY, branch C(250) NOTNULL DEFAULT \" '' \", user_id I NOTNULL UNSIGNED DEFAULT '0', timestamp T NOTNULL, author C(250) NOTNULL DEFAULT \" '' \", message XL, info XL " ) ), | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
|
Relationships |
|
 Relationships |
|
Notes |
|
 (022)John Reese (administrator) 2009-05-01 07:22 |
Fix committed to master branch at 2009-05-01 13:38:10. |
|
Notes |
| Related Changesets |
|||
|
Source Integration: master b97b10af
Timestamp: 2009-05-01 13:38:10 Author: John Reese Committer: John Reese [ Details ] [ Diff ] |
Fix 032: XL columns should not have default values. | ||
| mod - Source/Source.php | [ Diff ] [ File ] | ||
| Related Changesets |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-02-28 09:39 | Changeset attached | master a7671325 => | |
| 2009-04-30 01:20 | gransi | New Issue | |
| 2009-05-01 06:40 | John Reese | Assigned To | => John Reese |
| 2009-05-01 06:40 | John Reese | Status | new => assigned |
| 2009-05-01 06:40 | John Reese | Target Version | => 0.16 |
| 2009-05-01 07:22 | John Reese | Note Added: 022 | |
| 2009-05-01 07:22 | John Reese | Status | assigned => resolved |
| 2009-05-01 07:22 | John Reese | Fixed in Version | => 0.16 |
| 2009-05-01 07:22 | John Reese | Resolution | open => fixed |
| 2009-05-01 07:22 | John Reese | Changeset attached | master b97b10af => |
|
Issue History |
| Copyright © 2000 - 2012 MantisBT Group
Time: 0.1184 seconds. memory usage: 8,350 KB |
 |
