Modify

Opened 10 years ago

Closed 7 months ago

#1983 closed defect (wontfix)

SQLITE EROR

Reported by: arnoldroa@… Owned by: Roman Kurmanowytsch
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 10 years ago by 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....

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

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

comment:7 Changed 7 months ago by Ryan J Ollos

Resolution: wontfix
Status: newclosed

Plugin is deprecated.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Roman Kurmanowytsch.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.