Trac Database: 'No tables in database' error

[Former user]

Originally reported on Google Code with ID 258

What steps will reproduce the problem?
1. Configure phpliteadmin to open sqlite database created by trac (http://trac.edgewall.org)
2.Login to phpliteadmin

What is the expected output? What do you see instead?

After selecting trac databases, phpliteadmin gives "No tables in database" error where
table list should appear. Other databases (like owncloud's) can be accessed normally
on the same setup. Databases are proper in the sense that they can be managed from
commandline using sqlite2 command


What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?

Centos 6.5
SQLite version: 3.6.20
SQLite extension [?]: PDO
PHP version: 5.4.30

Reported by piotrowski.mb on 2014-08-01 06:40:48

[Christopher Kramer]

I will install trac in a VM to get grip of a trac sqlite db to see if I can reproduce
this.

Reported by crazy4chrissi on 2014-12-27 23:18:57

[Christopher Kramer]

I was not able to reproduce this.
Versions of the software I used:

trac: 1.0.1-3
ubuntu 14.10 
phpLiteAdmin: 1.9.5 and 1.9.6-dev
SQLite Version: 3.7.7.1
SQLite extension [?]: PDO
PHP Version: 5.4.7

I was able to successfully open the trac.db of a fresh trac project in phpLiteAdmin.
But in my case, it was a SQLite3 db. What version of trac are you using? As you say
you are accessing the db with sqlite2, this seems to be an older trac version. From
your sqlite version you seem to be using sqlite3 in phpLiteAdmin. Have you installed
sqlite2 for php? PhpLiteAdmin only supports sqlite2 if you have the appropriate php
extension installed. But most distributions do not provide a package for SQLite2 for
PHP anylonger.
What version of trac are you using?

Reported by crazy4chrissi on 2014-12-28 12:15:20

[Christopher Kramer]

Attached is the trac.db of my fresh trac project which I was successfully able to open
in phpLiteAdmin.

Reported by crazy4chrissi on 2014-12-28 12:19:31

<hr> * Attachment: trac.zip

[Christopher Kramer]

Closed invalid as I could not reproduce it and got no more feedback.