|
[Resolved] Problem installing Plugin Manager 0.1.0 on Mantis 1.1.0Posted by seanwhalen
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
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.
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
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.
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
I don't understand where is the issue. Create a PHP file in the mantis root directory with this and browse it:
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
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
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
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:
In this last case I'm not getting all the tables created, so I made them manually.
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.
Sorry, only registered users may post in this forum.
Online Users
Guests:
8
Record Number of Users:
1
on April 02, 2023
Record Number of Guests:
115
on November 09, 2023
Top Users
|