Bug 484428 - MS-SQL backend driver broken
Summary: MS-SQL backend driver broken
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: Fedora
Classification: Fedora
Component: mantis
Version: 10
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Gianluca Sforna
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-02-06 18:29 UTC by W. Michael Petullo
Modified: 2009-02-14 21:27 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-02-14 21:27:22 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)

Description W. Michael Petullo 2009-02-06 18:29:17 UTC
Description of problem:
We have a mantis installation that uses MS-SQL as its backend database. We have found that this component has an error that keeps it from working.

Version-Release number of selected component (if applicable):
mantis-1.1.4-1.fc10.noarch

How reproducible:
Every time

Steps to Reproduce:
Install mantis and configure to use the MS-SQL backend.
  
Actual results:
Configuring the MS-SQL backend will fail when executed from the web-based admin tool. The following error is logged to Apache's log:

...call to undefined function mssql_get_last_message () in /usr/share/mantis/core/adodb/drivers/adodb-mssql.inc.php...

Expected results:


Additional info:
As a temporary work around, I modified /usr/share/mantis/core/adodb/drivers/adodb-mssql.inc.php to use the static string "unknown" instead of calling undefined function mssql_get_last_message (). This was done in two places within the source file. Once this was done, the MS-SQL backend operated as expected.

Comment 1 Gianluca Sforna 2009-02-07 09:34:26 UTC
Hi, 
this is tricky for a number of reasons. For a start, I am not even sure upstream supports MSSQL officially. If they do, you will probably have more luck trying to open this bug on http://bugs.mantist.org because I have no way to test this kind of config.

On the other hand, I notice mssql_get_last_message() is really a php function so you should really have it available. Beforse going further I suggest you double check you installed the php-mssql package with:

# yum install php-mssql

and don't forget to restart apache with:
# service httpd restart

to double check if the function really exists, please install also the php-cli package and issue the command:

$ php --rf mssql_get_last_message
Function [ <internal:mssql> function mssql_get_last_message ] {
}

the output should look like mine.

Comment 2 W. Michael Petullo 2009-02-14 03:34:12 UTC
Yes, php-mssql is installed.

I added a report to Mantis' tracker:

http://www.mantisbt.org/bugs/view.php?id=10131

Comment 3 Gianluca Sforna 2009-02-14 21:27:22 UTC
Ok thank you very much.

I'm closing this now.


Note You need to log in before you can comment on or make changes to this bug.