SQLITE EROR

[arnoldroa@…]

Hi, in your code you have:

impl/tracktickets.php :

if ($db = sqlite_open($this->dbfile) {

when i run your aplication i got the message error Could not connect to database: but without any error description. you have it specied in the line 72:

die("<b>Could not connect to database:</b> ".$sqliteerror);

so i edit the connect line to this:

if ($db = sqlite_open($this->dbfile,0666,$sqliteerror)) {

and add a error_reporting(E_ALL);

so, i got this error now:

Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database in /home/pbxa/public_html/tt/impl/tractickets.php on line 36

Could not connect to database: file is encrypted or is not a database

im using trac 0.10.4. this error happends when you use sqlite-open to access to a slqite3 DB. How can i solve this?

[Roman Kurmanowytsch]

First of all, thanks for your hint about the improved error handling.

Teamtrac supports sqlite3 but you have to change a line in the configuration file cfg/teamtrac.cfg.

Search for the line

impl.ticketsystem: TracTickets

and replace it by

impl.ticketsystem: TracTicketsSQLite3

That should do the trick....

[arnoldroa@…]

thanks! i will try it, but:

• Is not better if the SqLite was the default option?
• anyway, why you dont check it internally in your code?

[anonymous]

Is not better if the SqLite? was the default option?

It is since version 0.7. ;)

anyway, why you dont check it internally in your code?

That is planned for one of the following releases. It is probably not very hard to do that but I simply did not have the time yet.

[anonymous]

i will try it

Can I consider this ticket to be solved? Did you try the configuration change?

[anonymous]

When I try to login in my temtrac an error rise up "Fatal error: Call to undefined function: sqlite3_open() in /var/www/teamtrac/impl/tractickets-sqlite3.php on line 37" can anyone help with it.

[anonymous]

You need ​php-sqlite3, a library for accessing sqlite3 databases in PHP.

[Ryan J Ollos]

Plugin is deprecated.