Modify

Opened 7 years ago

Last modified 7 months ago

#1983 new defect

SQLITE EROR

Reported by: arnoldroa@… Owned by: roman
Priority: highest Component: TeamtracIntegration
Severity: blocker Keywords:
Cc: arnoldroa@… Trac Release: 0.10

Description

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?

Attachments (0)

Change History (6)

comment:1 Changed 7 years ago by roman

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....

comment:2 Changed 7 years ago by 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?

comment:3 Changed 7 years ago by 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.

comment:4 Changed 7 years ago by anonymous

  • Cc arnoldroa@… added; anonymous removed

i will try it

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

comment:5 Changed 7 years ago by 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.

comment:6 Changed 7 years ago by anonymous

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

Add Comment

Modify Ticket

Action
as new The owner will remain roman.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.