search

sapioit / phpliteadmin

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

No tables listed on structure tab : "no table in database" #221

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Attempted load of any database in any directory my phpliteadmin

What is the expected output? What do you see instead?
List of tables is expected. No tables are listed. Standard SQL query in query 
window will generate table results, but "no table in database" is result on 
main page.

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

PDO . Using sqlite3. PHP 5.4.4-14+deb7u2. v1.9.4.1

Please provide any additional information below. Works fine except won't list 
tables automatically.

Original issue reported on code.google.com by colin.re...@gmail.com on 27 Jun 2013 at 2:58

GoogleCodeExporter commented 9 years ago 
This is on raspbian occidentalis, apache2

Original comment by colin.re...@gmail.com on 27 Jun 2013 at 3:33

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Thanks for your report. I have a raspberry pi but not tried phpLiteAdmin on it 
yet. I will give it a try and let you know if it works for me.

Original comment by crazy4ch...@gmail.com on 27 Jun 2013 at 2:00

GoogleCodeExporter commented 9 years ago 
Do you use occidentalis v0.1 or 0.2?

Original comment by crazy4ch...@gmail.com on 27 Jun 2013 at 2:38

GoogleCodeExporter commented 9 years ago 
0.2

Original comment by colin.re...@gmail.com on 27 Jun 2013 at 2:54

GoogleCodeExporter commented 9 years ago 
Let me know if you need any other config details. It's a pretty
straightforward install.

Occidentalis 0.2 + apt-get install php5 sqlite3 apache2 libapache2-mod-php5
python3 python-setuptools rpi.gpio ... and I think that's about it.

Original comment by colin.re...@gmail.com on 27 Jun 2013 at 2:56

GoogleCodeExporter commented 9 years ago 
I have also encountered queries that do not work on the phpliteadmin interface 
that work using python sqlite library calls. I have only encountered this so 
far using ALTER queries. Example:

alter table channels add column negativeoutput real

Original comment by interfac...@gmail.com on 28 Jun 2013 at 5:54

GoogleCodeExporter commented 9 years ago 
@interfaceinnovationsmail: This sounds like a completely different issue (maybe 
something related to issue #12). Do you also encounter this on raspbian? If 
not, please open up a new issue.

Original comment by crazy4ch...@gmail.com on 29 Jun 2013 at 8:48

GoogleCodeExporter commented 9 years ago 
Sorry. I am the same person. Different email. I have since gotten phpliteadmin 
working fine on another installation. The SDCard corrupted earlier today, and I 
assume the problem was due to other memory issues. Good news is it works great 
on my Pi.

Original comment by colin.re...@gmail.com on 29 Jun 2013 at 8:50

GoogleCodeExporter commented 9 years ago 
I did not find the time to test PLA on my pi, but as you say it works now with 
a new SD, this probably was no PLA issue so I am closing it.

Original comment by crazy4ch...@gmail.com on 9 Aug 2013 at 1:16