View Issue Details Jump to Notes ] Wiki ] Related Changesets ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008256mantisbtinstallationpublic2007-08-11 02:132007-10-04 01:38
Assigned Togiallu 
PlatformOSLinuxOS Version
Product Version1.0.8 
Target Version1.0.9Fixed in Version1.0.9 
Summary0008256: Install process fails creating db tables. regression: 1.0.7 works.
DescriptionThe 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 2006/01/05 03:54:19 thraxisp Exp $
+ # $Id: database_api.php,v 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/' );
+ require_once( 'adodb/' );

        # An array in which all executed queries are stored. This is used for profiling
        $g_queries_array = array();


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 ReproduceJust try to do fresh install.
TagsNo tags attached.
Attached Filespatch file icon mantisbt-1.0.8-avoid-XS-type-in-schema.php.patch [^] (3,619 bytes) 2007-08-12 02:38 [Show Content]

- Relationships

-  Notes
User avatar (0015414)
giallu (developer)
2007-08-11 03:12

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?
User avatar (0015415)
pva (reporter)
2007-08-11 04:20

dev-php/adodb-4.94. But seems that 495a have been released, so I'll try to download it and report back results.
User avatar (0015416)
pva (reporter)
2007-08-11 04:57

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/' );
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?
User avatar (0015417)
giallu (developer)
2007-08-11 10:23

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.
User avatar (0015422)
pva (reporter)
2007-08-12 02:40

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).
User avatar (0015473)
giallu (developer)
2007-08-21 17:58

Reverted the last commit on database_api.php so that now it works as in 1.0.7.

- Related Changesets
MantisBT: master-1.0.x 91a6b8ca
Timestamp: 2007-08-21 21:56:26
Author: giallu
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: [^] /?p=mantisbt.git;a=object;h=f5dc347c-c33d-0410-90a0-b07cc1902cb9
mod - core/database_api.php Diff ] File ]

- Issue History
Date Modified Username Field Change
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 =>

MantisBT 1.2.17 [^]
Copyright © 2000 - 2014 MantisBT Team
Time: 0.0892 seconds.
memory usage: 3,056 KB
Powered by Mantis Bugtracker