[Resolved] Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0

seanwhalen

[Resolved] Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 01:04AM

Registered: 15 years ago
Posts: 7

I have followed the installation instructions for Plugin Manager 0.1.0 and now when I login as admin and try to browse to the plugins_install_page.php, the system reports an error:

APPLICATION ERROR #401

Database query failed. Error received from database was #2812: Could not find stored procedure 'SHOW'. for the query: SHOW TABLES

It seems that it is trying to use a MySQL command and I have a MSSQL database. Is there some way I can change a setting or something to get the plugin manager to work?

Mantis: 1.1.0
PHP: 5.2.5
SQL: MSSQL 2005
OS: Windows Server 2003 Small Business Edition, SP2

Reply Quote

deboutv

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 09:12AM

Admin
Registered: 17 years ago
Posts: 2,139

Use the last version 0.4.0.

Vincent

Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here

Reply Quote

seanwhalen

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 03:34PM

Registered: 15 years ago
Posts: 7

I have the exact same problem when I install the 0.4.0 version. In fact, I installed that one first, then when it didn't work I tried to use 0.1.0 (as the instructions call for).

Mantis: 1.1.0
PHP: 5.2.5
SQL: MSSQL 2005
OS: Windows Server 2003 Small Business Edition, SP2

Edited 2 time(s). Last edit at 01/21/2009 03:36PM by seanwhalen.

Reply Quote

deboutv

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 03:41PM

Admin
Registered: 17 years ago
Posts: 2,139

Can you give me the URL when you get the error? And make sure that you browse plugins_page.php and not directly plugins_install_page.php.

Vincent

Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here

Reply Quote

seanwhalen

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 03:55PM

Registered: 15 years ago
Posts: 7

I apologize, I do browse to plugins_page.php to start with. The system then automatically goes to plugins_install_page.php and shows the error.

The final URL with the error is:

[sitename]

Mantis: 1.1.0
PHP: 5.2.5
SQL: MSSQL 2005
OS: Windows Server 2003 Small Business Edition, SP2

Edited 1 time(s). Last edit at 01/21/2009 03:56PM by seanwhalen.

Reply Quote

deboutv

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 04:00PM

Admin
Registered: 17 years ago
Posts: 2,139

The issue comes from Mantis files (there is no SHOW TABLES in the pluginmanager). Did you correctly set the $g_db_type in the config_inc.php file?

Vincent

Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here

Reply Quote

seanwhalen

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 04:05PM

Registered: 15 years ago
Posts: 7

Yes, the setting is correct. In the root of the mantis installation the config_inc.php file has this setting:
$g_db_type = 'mssql';

Mantis itself has no problems accessing the database correctly.

Mantis: 1.1.0
PHP: 5.2.5
SQL: MSSQL 2005
OS: Windows Server 2003 Small Business Edition, SP2

Reply Quote

deboutv

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 04:20PM

Admin
Registered: 17 years ago
Posts: 2,139

You don't have any $g_dsn variable defined somewhere?

Vincent

Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here

Reply Quote

seanwhalen

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 21, 2009 06:18PM

Registered: 15 years ago
Posts: 7

No, this variable is not found in any of the files in the mantis folders.

Reply Quote

deboutv

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 22, 2009 09:58AM

Admin
Registered: 17 years ago
Posts: 2,139

I don't understand where is the issue. Create a PHP file in the mantis root directory with this and browse it:

Language: PHP
( &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;core.php&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>; );
 ( db_table_exists( config_get( &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;mantis_user_table&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>; ) ) ) {
    &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;Found&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;;
} {
    &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;Not found&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;;
}
 ( db_table_exists( config_get( &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;db_table_prefix&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>; ) . &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;_plugins_pm_list&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>; . config_get( &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;db_table_suffix&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>; ) ) ) {
    &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;Found&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;;
} {
    &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;Not found&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;;
}

Vincent

Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here

Reply Quote

seanwhalen

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 22, 2009 04:38PM

Registered: 15 years ago
Posts: 7

I get
Found
Not Found

It is not creating the tables in SQL Server; I assumed that it wss using SHOW TABLES to see if they existed and if not, create them. Since it can't get the list, it never creates them.

Mantis: 1.1.0
PHP: 5.2.5
SQL: MSSQL 2005
OS: Windows Server 2003 Small Business Edition, SP2

Reply Quote

seanwhalen

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 27, 2009 12:20AM

Registered: 15 years ago
Posts: 7

Any luck in figuring what is causing this?

Is there any way for me to install a plugin without using the plugin manager? the only reason I was installing the plugin manager was to install the Import/Export plugin. If there is some other way to install the Import/Export plugin I would be happy.

Mantis: 1.1.0
PHP: 5.2.5
SQL: MSSQL 2005
OS: Windows Server 2003 Small Business Edition, SP2

Reply Quote

deboutv

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
January 27, 2009 08:50AM

Admin
Registered: 17 years ago
Posts: 2,139

I don't know where the error comes from. Could you enable more error report (see in the config_default_inc.php file).

Vincent

Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here

Reply Quote

bravecobra

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
March 25, 2009 08:14PM

Registered: 15 years ago
Posts: 5

I'm having the same issue when installing the plugin manager on SQl server.

"Show tables" is not correct syntax on SQL Server. You'll need:

Language: SQL
name <database name>..sysobjects xtype = &<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;U&<a href="http://bugtracker.morinie.fr/mantis/view.php?id=039" target="_blank">#039</a>;;

Reply Quote

bravecobra

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
March 25, 2009 10:30PM

Registered: 15 years ago
Posts: 5

I just found that the reason it fails to install is that there are backticks (`) in all queries. Remove those and you're good to go. Unfortunately, you need to remove them in all the queries in all php files.

Reply Quote

bravecobra

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
March 25, 2009 10:40PM

Registered: 15 years ago
Posts: 5

Another issue is that there are fieldnames that are keywords in sql server like 'function' and 'file'. Try renaming those...

Reply Quote

bravecobra

Re: Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0
March 25, 2009 10:48PM

Registered: 15 years ago
Posts: 5

In this last case I'm not getting all the tables created, so I made them manually.

Language: SQL
[dbo].[mantis_plugins_pm_dependencies_table](
	[plugin] [varchar](50),
	[dependencies] [text], CLUSTERED 
(
	[plugin]
)
) ] TEXTIMAGE_ON ]
 [dbo].[mantis_plugins_pm_function_overwrite_table](
	[id] [int] IDENTITY(1,1),
	[plugin] [varchar](50),
	] [varchar](100),
	[new_function] [varchar](100),
	[plugins] [text],
	[file] [varchar](150),
 CONSTRAINT [PK_mantis_plugins_pm_function_overwrite_table] CLUSTERED 
(
	[id]
)
) ] TEXTIMAGE_ON ]
 [dbo].[mantis_plugins_pm_list_table](
	[plugin] [varchar](50),
	[installed] [int] ((0)), CLUSTERED 
(
	[plugin]
)
) ]

But once you have that one running and your plugin manager is up and running all installations of plugins fail due to the keyword-named fieldnames.

Personally I think that renaming those fieldnames and removing the backticks makes all of this SQL server compatible. ADODB should cover the rest.

Edited 1 time(s). Last edit at 03/25/2009 10:55PM by bravecobra.

Reply Quote

[Resolved] Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0

Online Users