[horde] "no such table" with IIS 6 and MSSQL

[Alexander Maier]

Hi,

I have set up the horde HEAD with IIS 6 PHP 4.3.9 and Microsoft SQL 
server. Everything is working now except the database connection. Horde 
is able to connect to the DB but cannot find the tables. The database is 
found as it gives another error message when I specify a wrong database 
for the SQL connection. Here are my values for the DB:

$conf['sql']['phptype'] = 'mssql';
$conf['sql']['persistent'] = true;
$conf['sql']['port'] = 1433;
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '********';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';

When trying to use any function that needs database (which are most of 
horde) then I get that error message in the horde log file:

Dec 13 13:14:21 HORDE [emergency] [horde] DB Error: no such table: 
SELECT user_uid FROM horde_users ORDER BY user_uid [nativecode=208 - 
Invalid object name 'horde_users'.] [on line 234 of 
"D:\IISwwwRoot\horde\admin\user.php"]

The complete error array on the website is listed below as an example 
when opening the user manager.


Any suggestions? This probably could be a small thing, but I don't have 
any ideas anymore.

Thanks,

Alex.




Here is the Error log which appears on the web page:


Ein schwerer Fehler ist aufgetreten:
DB Error: no such table

[Zeile 234 von D:\IISwwwRoot\horde\admin\user.php]
Details (auch in Hordes Logdatei):

object(db_error)(8) {
   ["error_message_prefix"]=>
   string(0) ""
   ["mode"]=>
   int(1)
   ["level"]=>
   int(1024)
   ["code"]=>
   int(-18)
   ["message"]=>
   string(23) "DB Error: no such table"
   ["userinfo"]=>
   string(104) "SELECT user_uid FROM horde_users ORDER BY user_uid 
[nativecode=208 - Invalid object name 'horde_users'.]"
   ["backtrace"]=>
   array(9) {
     [0]=>
     array(6) {
       ["file"]=>
       string(18) "C:\PHP\pear\DB.php"
       ["line"]=>
       int(748)
       ["function"]=>
       string(10) "pear_error"
       ["class"]=>
       string(8) "db_error"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(5) {
         [0]=>
         string(23) "DB Error: no such table"
         [1]=>
         int(-18)
         [2]=>
         int(1)
         [3]=>
         int(1024)
         [4]=>
         string(104) "SELECT user_uid FROM horde_users ORDER BY user_uid 
[nativecode=208 - Invalid object name 'horde_users'.]"
       }
     }
     [1]=>
     array(6) {
       ["file"]=>
       string(20) "C:\PHP\pear\PEAR.php"
       ["line"]=>
       int(541)
       ["function"]=>
       string(8) "db_error"
       ["class"]=>
       string(8) "db_error"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(4) {
         [0]=>
         int(-18)
         [1]=>
         int(1)
         [2]=>
         int(1024)
         [3]=>
         string(104) "SELECT user_uid FROM horde_users ORDER BY user_uid 
[nativecode=208 - Invalid object name 'horde_users'.]"
       }
     }
     [2]=>
     array(6) {
       ["file"]=>
       string(25) "C:\PHP\pear\DB\common.php"
       ["line"]=>
       int(500)
       ["function"]=>
       string(10) "raiseerror"
       ["class"]=>
       string(4) "pear"
       ["type"]=>
       string(2) "::"
       ["args"]=>
       array(7) {
         [0]=>
         NULL
         [1]=>
         int(-18)
         [2]=>
         NULL
         [3]=>
         NULL
         [4]=>
         string(104) "SELECT user_uid FROM horde_users ORDER BY user_uid 
[nativecode=208 - Invalid object name 'horde_users'.]"
         [5]=>
         string(8) "DB_Error"
         [6]=>
         bool(true)
       }
     }
     [3]=>
     array(6) {
       ["file"]=>
       string(24) "C:\PHP\pear\DB\mssql.php"
       ["line"]=>
       int(492)
       ["function"]=>
       string(10) "raiseerror"
       ["class"]=>
       string(8) "db_mssql"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(5) {
         [0]=>
         int(-18)
         [1]=>
         NULL
         [2]=>
         NULL
         [3]=>
         NULL
         [4]=>
         string(40) "208 - Invalid object name 'horde_users'."
       }
     }
     [4]=>
     array(6) {
       ["file"]=>
       string(24) "C:\PHP\pear\DB\mssql.php"
       ["line"]=>
       int(145)
       ["function"]=>
       string(15) "mssqlraiseerror"
       ["class"]=>
       string(8) "db_mssql"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(0) {
       }
     }
     [5]=>
     array(6) {
       ["file"]=>
       string(25) "C:\PHP\pear\DB\common.php"
       ["line"]=>
       int(1146)
       ["function"]=>
       string(11) "simplequery"
       ["class"]=>
       string(8) "db_mssql"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(1) {
         [0]=>
         string(50) "SELECT user_uid FROM horde_users ORDER BY user_uid"
       }
     }
     [6]=>
     array(6) {
       ["file"]=>
       string(25) "C:\PHP\pear\DB\common.php"
       ["line"]=>
       int(1596)
       ["function"]=>
       string(5) "query"
       ["class"]=>
       string(8) "db_mssql"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(1) {
         [0]=>
         string(50) "SELECT user_uid FROM horde_users ORDER BY user_uid"
       }
     }
     [7]=>
     array(6) {
       ["file"]=>
       string(30) "C:\PHP\pear\Horde\Auth\sql.php"
       ["line"]=>
       int(299)
       ["function"]=>
       string(6) "getall"
       ["class"]=>
       string(8) "db_mssql"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(3) {
         [0]=>
         string(50) "SELECT user_uid FROM horde_users ORDER BY user_uid"
         [1]=>
         NULL
         [2]=>
         int(1)
       }
     }
     [8]=>
     array(6) {
       ["file"]=>
       string(34) "D:\IISwwwRoot\horde\admin\user.php"
       ["line"]=>
       int(232)
       ["function"]=>
       string(9) "listusers"
       ["class"]=>
       string(8) "auth_sql"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(0) {
       }
     }
   }
   ["callback"]=>
   NULL
}