Notice: this is a static mirror for historical purposes.

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
171Source Integration[All Projects] Generalpublic2010-08-06 13:592011-04-07 09:29
ReporterAaron Montgomery 
Assigned To 
PrioritynormalSeverityblockReproducibilityalways
StatusnewResolutionopen 
Product Version0.13 
Target VersionFixed in Version 
Summary171: APPLICATION ERROR #2503 Upgrading the plugin schema failed in block #0.
DescriptionAttempting to install the Source/WebSVN Integration 0.16 plugin leads to Application Error.
Steps To Reproduce When I install the "Source Control Integration 0.16.2" plug-in, the Dependencies column is yellow with "MantisBT 1.2.0" and "Meta Programming 0.1" listed. There is an upgrade action available, but it leads to the Application Error in the Summary line.

If I persist and install the Source/SVN and Source/WebSVN plugins, they appear to have all their dependencies met (but don't list Meta Programming as a dependency).

If I try to configure the plugin, I am met with a large number of errors starting with:

APPLICATION WARNING 100: Configuration option "blah" not found.
Additional InformationNew to Mantis, so this may be something obvious I am missing. All installations are new today following the links on the MantisBT and MantisForge pages.

Running Mantis 1.2.2 with plugin Meta Programming 0.1
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
User avatar (235)
Aaron Montgomery (reporter)
2010-08-06 14:05

Should have included the OS. This is running on a Mac OS X (10.5) installation.
User avatar (237)
treeboy (reporter)
2010-08-31 15:12

I meet exactly this on Debian Sid too, with the same versions of Mantis and Source Integration.

If I switch on mysql logging, I can see that it attempts to create the mantis_plugin_Source_repository_table, but doesn't seem to succeed. I do not see it attempt to drop that table,but it does not exist.

If I run the query manually, it works perfectly well.

The Mantis query debugging doesn't show the attempt to create this table.

The mysql log shows:

=== BEGIN LOG
100831 23:07:11 213 Connect mantis@localhost on
                  213 Init DB mantis
                  213 Query SET NAMES UTF8
                  213 Query SELECT *
                                  FROM mantis_user_table
                                  WHERE cookie_string='08f4817c1b925e922e0896f1206bcf692baecce8c4957f718b0e7296008e6757'
                  213 Query SELECT *
                                  FROM mantis_user_pref_table
                                  WHERE user_id=3 AND project_id=0
                  213 Query SHOW TABLES
                  213 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table
                  213 Query DELETE FROM mantis_tokens_table WHERE 1283292431 > expiry
                  213 Query SELECT * FROM mantis_tokens_table
                                        WHERE type=5 AND owner=3
                  213 Query SELECT * FROM mantis_tokens_table
                                        WHERE type=4 AND owner=3
                  213 Query SELECT id
                                FROM mantis_tokens_table
                                WHERE id=34 LIMIT 1
                  213 Query UPDATE mantis_tokens_table
                                        SET expiry=1283292731
                                        WHERE id=34
                  213 Query SELECT COUNT(*) FROM mantis_plugin_table WHERE basename='Source'
                  213 Query INSERT INTO mantis_plugin_table ( basename, enabled )
                                VALUES ( 'Source', '1' )
                  213 Query SELECT COUNT(*) FROM mantis_plugin_table WHERE basename='Source'
                  213 Query select version()
                  213 Query CREATE TABLE mantis_plugin_Source_repository_table (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
type VARCHAR(8) NOT NULL DEFAULT '',
name VARCHAR(128) NOT NULL DEFAULT '',
url VARCHAR(250) DEFAULT '',
info LONGTEXT NOT NULL,
                 PRIMARY KEY (id, type, name)
)DEFAULT CHARSET=utf8
                  213 Query SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent
                                  FROM mantis_project_table p
                                  LEFT JOIN mantis_project_hierarchy_table ph
                                    ON ph.child_id = p.id
                                  WHERE p.enabled = 1
                                  ORDER BY p.name
                  213 Query SELECT DISTINCT p.id, p.name, ph.parent_id
                                          FROM mantis_project_table p
                                          LEFT JOIN mantis_project_hierarchy_table ph
                                            ON ph.child_id = p.id
                                          WHERE p.enabled = 1 AND
                                                 ph.parent_id IS NOT NULL
                                          ORDER BY p.name
                  213 Query UPDATE mantis_user_table
                                  SET last_visit= 1283292431
                                  WHERE id=3
                  213 Quit

=== END LOG

The Mantis query log shows:

=== BEGIN LOG
1 0.0002 database_api.php:105 db_connect()
SET NAMES UTF8
2 0.0007 authentication_api.php:759 auth_is_cookie_valid()
SELECT * FROM mantis_user_table WHERE cookie_string='08f4817c1b925e922e0896f1206bcf692baecce8c4957f718b0e7296008e6757'
3 0.0004 user_pref_api.php:171 user_pref_cache_row()
SELECT * FROM mantis_user_pref_table WHERE user_id=3 AND project_id=0
4 0.0003 config_api.php:124 config_get()
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table
5 0.0004 tokens_api.php:263 token_purge_expired()
DELETE FROM mantis_tokens_table WHERE 1283292431 > expiry
6 0.0003 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=3
7 0.0005 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=4 AND owner=3
8 0.0003 tokens_api.php:43 token_exists()
SELECT id FROM mantis_tokens_table WHERE id=34
9 0.0003 tokens_api.php:137 token_touch()
UPDATE mantis_tokens_table SET expiry=1283292731 WHERE id=34
10 0.0005 plugin_api.php:529 plugin_is_installed()
SELECT COUNT(*) FROM mantis_plugin_table WHERE basename='Source'
11 0.0003 plugin_api.php:556 plugin_install()
INSERT INTO mantis_plugin_table ( basename, enabled ) VALUES ( 'Source', '1' )
12 0.0003 plugin_api.php:529 plugin_is_installed()
SELECT COUNT(*) FROM mantis_plugin_table WHERE basename='Source'
13 0.0007 project_hierarchy_api.php:157 project_hierarchy_cache()
SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name
14 0.0003 user_api.php:948 user_get_accessible_subprojects()
SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name
15 0.0003 user_api.php:1148 user_update_last_visit()
UPDATE mantis_user_table SET last_visit= 1283292431 WHERE id=3
    0.0058 SQL Queries Total Time
    0.1429 Page Request Total Time
    
Powered by Mantis Bugtracker
=== END LOG
User avatar (238)
treeboy (reporter)
2010-08-31 15:15

I should add that query 12 in the Mantis query log is in red whereas all of the rest are in black.
User avatar (241)
hippyjim (reporter)
2010-09-27 11:36

I had this same problem - it was fixed by making sure that the MySQL user mantis uses had sufficient permissions to alter & create tables on the database (allowing the required changes to the DB the plugin needed)
User avatar (243)
Aaron Montgomery (reporter)
2010-09-28 06:56

Have played with the permissions. I am still getting the error even when I give the MySQL user mantis all possible permissions. However, I will poke it a few more times to see if some other setting is off.
User avatar (283)
Karl Reichert (reporter)
2011-04-07 09:29

This is a duplicate of 162

Please note my comment in this bug for a workaround!

- Issue History
Date Modified Username Field Change
2010-08-06 13:59 Aaron Montgomery New Issue
2010-08-06 14:05 Aaron Montgomery Note Added: 235
2010-08-31 15:12 treeboy Note Added: 237
2010-08-31 15:15 treeboy Note Added: 238
2010-09-27 11:36 hippyjim Note Added: 241
2010-09-28 06:56 Aaron Montgomery Note Added: 243
2011-04-07 09:29 Karl Reichert Note Added: 283


Copyright © 2000 - 2012 MantisBT Group
Time: 0.1367 seconds.
memory usage: 8,426 KB
Powered by Mantis Bugtracker

hosted with
Linode