[horde] Using SQLite

[Jason Walton]

Ok, the error message is quite long, but here it is:

object(DB_Error)#12 (8) {
   ["error_message_prefix"]=>
   string(0) ""
   ["mode"]=>
   int(1)
   ["level"]=>
   int(1024)
   ["code"]=>
   int(-1)
   ["message"]=>
   string(23) "DB Error: unknown error"
   ["userinfo"]=>
   string(42) "1 ** show tables [DB Error: unknown error]"
   ["backtrace"]=>
   array(7) {
     [0]=>
     array(6) {
       ["file"]=>
       string(25) "/opt/local/lib/php/DB.php"
       ["line"]=>
       int(888)
       ["function"]=>
       string(10) "PEAR_Error"
       ["class"]=>
       string(8) "DB_Error"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(5) {
         [0]=>
         string(23) "DB Error: unknown error"
         [1]=>
         int(-1)
         [2]=>
         int(1)
         [3]=>
         int(1024)
         [4]=>
         string(42) "1 ** show tables [DB Error: unknown error]"
       }
     }
     [1]=>
     array(6) {
       ["file"]=>
       string(27) "/opt/local/lib/php/PEAR.php"
       ["line"]=>
       int(557)
       ["function"]=>
       string(8) "DB_Error"
       ["class"]=>
       string(8) "DB_Error"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(4) {
         [0]=>
         int(-1)
         [1]=>
         int(1)
         [2]=>
         int(1024)
         [3]=>
         string(42) "1 ** show tables [DB Error: unknown error]"
       }
     }
     [2]=>
     array(6) {
       ["file"]=>
       string(32) "/opt/local/lib/php/DB/common.php"
       ["line"]=>
       int(1849)
       ["function"]=>
       string(10) "raiseError"
       ["class"]=>
       string(9) "DB_sqlite"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(7) {
         [0]=>
         NULL
         [1]=>
         int(-1)
         [2]=>
         NULL
         [3]=>
         NULL
         [4]=>
         string(42) "1 ** show tables [DB Error: unknown error]"
         [5]=>
         string(8) "DB_Error"
         [6]=>
         bool(true)
       }
     }
     [3]=>
     array(6) {
       ["file"]=>
       string(32) "/opt/local/lib/php/DB/sqlite.php"
       ["line"]=>
       int(698)
       ["function"]=>
       string(10) "raiseError"
       ["class"]=>
       string(9) "DB_sqlite"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(5) {
         [0]=>
         int(-1)
         [1]=>
         NULL
         [2]=>
         NULL
         [3]=>
         string(16) "1 ** show tables"
         [4]=>
         string(0) ""
       }
     }
     [4]=>
     array(6) {
       ["file"]=>
       string(32) "/opt/local/lib/php/DB/sqlite.php"
       ["line"]=>
       int(294)
       ["function"]=>
       string(16) "sqliteRaiseError"
       ["class"]=>
       string(9) "DB_sqlite"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(1) {
         [0]=>
         NULL
       }
     }
     [5]=>
     array(6) {
       ["file"]=>
       string(32) "/opt/local/lib/php/DB/common.php"
       ["line"]=>
       int(1162)
       ["function"]=>
       string(11) "simpleQuery"
       ["class"]=>
       string(9) "DB_sqlite"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(1) {
         [0]=>
         string(11) "show tables"
       }
     }
     [6]=>
     array(6) {
       ["file"]=>
       string(53) "/Library/WebServer/Documents/horde/admin/ 
sqlshell.php"
       ["line"]=>
       int(57)
       ["function"]=>
       string(5) "query"
       ["class"]=>
       string(9) "DB_sqlite"
       ["type"]=>
       string(2) "->"
       ["args"]=>
       array(1) {
         [0]=>
         string(11) "show tables"
       }
     }
   }
   ["callback"]=>
   NULL
}


I personally think it may have more to do w/ my php5 installation  
rather than Horde, but my phpinfo page seems to indicate everything  
is in place as far as sqlite goes.

Any ideas, or any more data that may help you?

Thanks,
Jason

On Sep 6, 2005, at 10:22 PM, Chuck Hagenbuch wrote:

> Quoting Jason Walton <jwalton at mailworks.org>:
>
>
>> Anyway, I modified the create script to work with SQLite, and created
>> a database successfully. The sqlite command-line tool shows the
>> tables just fine. BTW, I'm using sqlite v.2 instead of 3, but I
>> seemed to have the same issue w/ 3.
>>
>
> What issue?
>
>
>> Anyway, Horde gives an error when trying to display the datatree, and
>>
>
> What error?
>
>
>> shows no tables in the SQL shell. When I try to perform a "show
>> tables;" in the SQL Shell, I get an unknown error coughed up in the
>> browser window.
>>
>
> I'm running an internal site on sqlite. It works fine.
>
> -chuck
>
> -- 
> "But she goes not abroad in search of monsters to destroy." - John
> Quincy Adams
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>