Ticket #1983 (new defect)

Opened 1 year ago

Last modified 6 months ago

SQLITE EROR

Reported by: arnoldroa@hotmail.com Assigned to: roman
Priority: highest Component: TeamtracIntegration
Severity: blocker Keywords:
Cc: arnoldroa@hotmail.com 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

Change History

08/29/07 16:43:45 changed 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....

08/30/07 11:12:48 changed by arnoldroa@hotmail.com

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?

08/30/07 11:54:31 changed 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.

09/01/07 12:16:30 changed by anonymous

  • cc set to arnoldroa@hotmail.com.

i will try it

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

05/20/08 09:57:38 changed 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.

06/01/08 11:23:32 changed by anonymous

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

Add/Change #1983 (SQLITE EROR)




Change Properties
Action