search

jatpat / phpliteadmin

Automatically exported from code.google.com/p/phpliteadmin
0 stars 0 forks source link

Trac Database: 'No tables in database' error #258

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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

Original issue reported on code.google.com by piotrows...@gmail.com on 1 Aug 2014 at 6:40

GoogleCodeExporter commented 9 years ago 
I will install trac in a VM to get grip of a trac sqlite db to see if I can 
reproduce this.

Original comment by crazy4ch...@gmail.com on 27 Dec 2014 at 11:18

GoogleCodeExporter commented 9 years ago 
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?

Original comment by crazy4ch...@gmail.com on 28 Dec 2014 at 12:15

GoogleCodeExporter commented 9 years ago 
Attached is the trac.db of my fresh trac project which I was successfully able 
to open in phpLiteAdmin.

Original comment by crazy4ch...@gmail.com on 28 Dec 2014 at 12:19

Attachments: