#83 mssql_query errors prevent page loading

3.0.0
closed-works-for-me
MS SQL (15)
5
2010-11-26
2010-10-15
Josh Cooke
No

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

Discussion

  • Josh Cooke

    Josh Cooke - 2010-10-15

    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.

     
  • Jakub Vrána

    Jakub Vrána - 2010-10-16

    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/

     
  • Jakub Vrána

    Jakub Vrána - 2010-10-16
    • status: open --> closed-works-for-me
     
  • Jakub Vrána

    Jakub Vrána - 2010-11-26
    • labels: 1212738 --> MS SQL
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks