View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0008256 | mantisbt | installation | public | 2007-08-11 02:13 | 2007-10-04 01:38 |
Reporter | pva | Assigned To | giallu | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
OS | Linux | ||||
Product Version | 1.0.8 | ||||
Target Version | 1.0.9 | Fixed in Version | 1.0.9 | ||
Summary | 0008256: Install process fails creating db tables. regression: 1.0.7 works. | ||||
Description | The problem initially was reported here: http://www.mantisbt.org/forums/viewtopic.php?t=3345 and although in that discussion there are unanswered questions left behind this bug report (and I really appreciate answers) the bug itself I'll report here. The problem is that in the 1.0.8 the installation proces fails on: Create Schema ( CreateTableSQL on mantis_config_table ) BAD I found that if I revert back the following change: +++++++++++++++++++++++++++++++++++++++++++++++++++ See the README and LICENSE files for details
+++++++++++++++++++++++++++++++++++++++++++++++++++ everything works. That's amd64 server with dev-db/mysql-5.0.42, dev-lang/php-5.2.2-r1, apache-2, and mantisbt-1.0.8. | ||||
Steps To Reproduce | Just try to do fresh install. | ||||
Tags | No tags attached. | ||||
Attached Files | mantisbt-1.0.8-avoid-XS-type-in-schema.php.patch (3,619 bytes)
--- admin/schema.php.orig 2007-08-12 09:51:24.000000000 +0400 +++ admin/schema.php 2007-08-12 09:53:25.000000000 +0400 @@ -26,7 +26,7 @@ user_id I DEFAULT '0' PRIMARY, access_reqd I DEFAULT '0', type I DEFAULT '90', - value XS NOTNULL", + value XL NOTNULL", Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateIndexSQL',Array('idx_config',config_get('mantis_config_table'),'config_id')); @@ -108,9 +108,9 @@ $upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_bug_text_table')," id I PRIMARY UNSIGNED NOTNULL AUTOINCREMENT, - description XS NOTNULL, - steps_to_reproduce XS NOTNULL, - additional_information XS NOTNULL + description XL NOTNULL, + steps_to_reproduce XL NOTNULL, + additional_information XL NOTNULL ",Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_bugnote_table')," @@ -129,7 +129,7 @@ $upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_bugnote_text_table')," id I UNSIGNED NOTNULL PRIMARY AUTOINCREMENT, - note XS NOTNULL + note XL NOTNULL ",Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_custom_field_project_table')," @@ -174,7 +174,7 @@ project_id I NOTNULL DEFAULT '0', is_public L DEFAULT NULL, name C(64) NOTNULL DEFAULT \" '' \", - filter_string XS NOTNULL + filter_string XL NOTNULL ",Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_news_table')," @@ -186,7 +186,7 @@ view_state I2 NOTNULL DEFAULT '10', announcement L NOTNULL DEFAULT '0', headline C(64) NOTNULL DEFAULT \" '' \", - body XS NOTNULL + body XL NOTNULL ",Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_project_category_table')," @@ -222,7 +222,7 @@ view_state I2 NOTNULL DEFAULT '10', access_min I2 NOTNULL DEFAULT '10', file_path C(250) NOTNULL DEFAULT \" '' \", - description XS NOTNULL + description XL NOTNULL ",Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateIndexSQL',Array('idx_project_id',config_get('mantis_project_table'),'id')); $upgrade[] = Array('CreateIndexSQL',Array('idx_project_name',config_get('mantis_project_table'),'name',Array('UNIQUE'))); @@ -240,7 +240,7 @@ project_id I UNSIGNED NOTNULL DEFAULT '0', version C(64) NOTNULL DEFAULT \" '' \", date_order T NOTNULL DEFAULT '1970-01-01 00:00:01', - description XS NOTNULL, + description XL NOTNULL, released L NOTNULL DEFAULT '1' ",Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateIndexSQL',Array('idx_project_version',config_get('mantis_project_version_table'),'project_id,version',Array('UNIQUE'))); @@ -265,7 +265,7 @@ type I NOTNULL, timestamp T NOTNULL, expiry T, - value XS NOTNULL", + value XL NOTNULL", Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_user_pref_table')," @@ -313,7 +313,7 @@ platform C(32) NOTNULL DEFAULT \" '' \", os C(32) NOTNULL DEFAULT \" '' \", os_build C(32) NOTNULL DEFAULT \" '' \", - description XS NOTNULL + description XL NOTNULL ",Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_user_table')," | ||||
That modifcation was done in order to use (when available) the system ADODB. So, for a start, what ADODB version have you around in your system? |
|
dev-php/adodb-4.94. But seems that 495a have been released, so I'll try to download it and report back results. |
|
Well with 495a and 4.72 I have the same result. I've tried to put the full path into |
|
Ok. I think I now understand what is going on... On the devel branch, soon after the database_api.php change, there was an update of ADODB to a newer version, dropping in the operation some specific mantis patches to it. The schema.php file was modified as well to avoid using the XS type (which was introduced by the mantis patch and not exists in upstream ADODB). see: http://mantisbt.cvs.sourceforge.net/mantisbt/mantisbt/admin/schema.php?r1=1.15&r2=1.16 Now, given this analysis and the recently formalized policy for what should/should not land on the stable branch, I think we should revert the change to database_api.php for 1.0.9. |
|
Thank you for clarification. Seems that the link on patch you gave is for HEAD, but in any case, XS -> XL substitution fixes the issue (attached patch is actually for 1.0.8). |
|
Reverted the last commit on database_api.php so that now it works as in 1.0.7. |
|
MantisBT: master-1.0.x 91a6b8ca 2007-08-21 17:56 Details Diff |
Fix 8256: Install process fails creating db tables. regression: 1.0.7 works. Reverted the modification that allows using system ADODB, since the 1.0.x branch contains a modified ADODB tree and the upgrade.php script expects to work with that. git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/branches/BRANCH_1_0_0@4551 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9 |
Affected Issues 0008256 |
|
mod - core/database_api.php | Diff File |