[adminer-tracker] [ adminer-Bugs and Features-3088237 ] mssql_query errors prevent page loading

[SourceForge.net <no...@so...>]

Bugs and Features item #3088237, was opened at 2010-10-15 19:45
Message generated for change (Settings changed) made by jakubvrana
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3088237&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
>Category: MS SQL
Group: 3.0.0
Status: Closed
Resolution: Works For Me
Priority: 5
Private: No
Submitted By: Josh Cooke (icecreamhead)
Assigned to: Jakub Vrána (jakubvrana)
Summary: mssql_query errors prevent page loading

Initial Comment:
Shown when loading the adminer homepage:

PHP Warning:  mssql_query(): message: Invalid object name 'fn_helpcollations'. (severity 16) in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): Query failed in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): message: Invalid object name 'sys.databases'. (severity 16) in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): Query failed in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): message: Invalid object name 'sys.databases'. (severity 16) in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): Query failed in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): message: Invalid object name 'sys.databases'. (severity 16) in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): Query failed in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): message: Invalid object name 'sys.databases'. (severity 16) in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): Query failed in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): message: Invalid object name 'sys.databases'. (severity 16) in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): Query failed in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): message: Invalid object name 'sys.databases'. (severity 16) in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): Query failed in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): message: Invalid object name 'sys.databases'. (severity 16) in G:\socs\su140\admin\adminer-3.0.0.php on line 618
PHP Warning:  mssql_query(): Query failed in G:\socs\su140\admin\adminer-3.0.0.php on line 618

----------------------------------------------------------------------

Comment By: Jakub Vrána (jakubvrana)
Date: 2010-10-16 08:20

Message:
Adminer currently works only with MS SQL 2008. I've added this information
on the homepage. I would appreciate if you become a contributor an adapt
the driver to work also with earlier version. I don't even have them. You
can start at http://www.adminer.org/en/drivers/

----------------------------------------------------------------------

Comment By: Josh Cooke (icecreamhead)
Date: 2010-10-15 20:46

Message:
It appears this bug appears because SQL Server 2000 is being used, so the
sys.databases table does not exist. Instead, there is systables. There is
no collation_name field in this table though.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3088237&group_id=264133