Modify

Opened 9 years ago

Closed 4 weeks ago

#1983 closed defect (wontfix)

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 (7)

comment:1 Changed 9 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 9 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 9 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 9 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 8 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 8 years ago by anonymous

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

comment:7 Changed 4 weeks ago by rjollos

  • Resolution set to wontfix
  • Status changed from new to closed

Plugin is deprecated.

Add Comment

Modify Ticket

Action
as closed The owner will remain roman.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.