|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|
|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:|
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 )
CREATE TABLE mantis_config_table ( config_id VARCHAR(64) NOT NULL, project_id INTEGER NOT NULL DEFAULT 0, user_id INTEGER NOT NULL DEFAULT 0, access_reqd INTEGER DEFAULT 0, type INTEGER DEFAULT 90, value XS NOT NULL, PRIMARY KEY (config_id, project_id, user_id) )TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'XS NOT NULL, PRIMARY KEY (config_id, project_id, user_id) )TYPE' at line 7
I found that if I revert back the following change:
--- /usr/share/webapps/mantisbt/1.0.7/htdocs/core/database_api.php 2007-05-11 15:09:18.000000000 +0400
+++ /usr/share/webapps/mantisbt/1.0.8/htdocs/core/database_api.php 2007-07-23 14:19:22.000000000 +0400
@@ -6,7 +6,7 @@
# See the README and LICENSE files for details
- # $Id: database_api.php,v 220.127.116.11 2006/01/05 03:54:19 thraxisp Exp $
+ # $Id: database_api.php,v 18.104.22.168.4.1 2007/05/26 22:23:50 giallu Exp $
### Database ###
@@ -16,7 +16,7 @@
$t_core_dir = dirname( __FILE__ ).DIRECTORY_SEPARATOR;
- require_once( $t_core_dir . 'adodb/adodb.inc.php' );
+ require_once( 'adodb/adodb.inc.php' );
# An array in which all executed queries are stored. This is used for profiling
$g_queries_array = array();
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.|
That modifcation was done in order to use (when available) the system ADODB.
I specifically requested that, as it is usually considered a packaging error (at least, it is in Fedora) to use bundled 3rd party libraries insted of system wide ones.
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
require_once( '/usr/share/php/adodb/adodb.inc.php' );
and also nothing changes the same result. (BTW. This path is in 'include_path = ".:/usr/share/php5:/usr/share/php"' of php.ini) What else can cause this problem?
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:
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
Timestamp: 2007-08-21 21:56:26
|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
|mod - core/database_api.php|
|2007-08-11 02:13||pva||New Issue|
|2007-08-11 03:12||giallu||Note Added: 0015414|
|2007-08-11 04:20||pva||Note Added: 0015415|
|2007-08-11 04:57||pva||Note Added: 0015416|
|2007-08-11 10:23||giallu||Note Added: 0015417|
|2007-08-11 10:30||giallu||Target Version||=> 1.0.9|
|2007-08-12 02:38||pva||File Added: mantisbt-1.0.8-avoid-XS-type-in-schema.php.patch|
|2007-08-12 02:40||pva||Note Added: 0015422|
|2007-08-21 17:58||giallu||Status||new => resolved|
|2007-08-21 17:58||giallu||Fixed in Version||=> 1.0.9|
|2007-08-21 17:58||giallu||Resolution||open => fixed|
|2007-08-21 17:58||giallu||Assigned To||=> giallu|
|2007-08-21 17:58||giallu||Note Added: 0015473|
|2007-10-04 01:38||vboctor||Status||resolved => closed|
|2008-11-11 09:04||giallu||Changeset attached||master-1.0.x 91a6b8ca =>|