Without rowid tables are not handled as should.

Originally reported on Google Code with ID 270
What steps will reproduce the problem?
1) Create a table without rowid, eg. worcount:

CREATE TABLE wordcount( word TEXT PRIMARY KEY, cnt INTEGER ) WITHOUT ROWID;

2) Insert some records into this table:

INSERT INTO wordcount(word,cnt) values('Word',4);
INSERT INTO wordcount(word,cnt) values('Another',7);
INSERT INTO wordcount(word,cnt) values('Some',4);

3) Select the wordcount table in phpLiteAdmin
In the browse tab, you get the message 'Showing rows 0 - 0, Total: 3 (Query took 0.0001
sec)'

But only 1 row shows : column value for word is NULL and for cnt is NULL.
Clicking on the Edit or Delete link results in an error: 'ERROR: You did not select
anything.'

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

I expected to see 3 rows with a working edit and delete link but saw only 1 row with
invalid links.


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

phpLiteAdmin v1.9.5
SQLite version: 3.8.8.3
SQLite extension: PDO
PHP version: 5.6.9
OS: Microsoft Windows 8.1

Please provide any additional information below.

It seams phpLiteAdmin works only on tables with the standard ROWID, the links for editing
and deleting indeed do show the parameter pk=... but on tables without ROWID this link
is empty.

Selecting all records in the sql tab altough just works fine:
SELECT * FROM "wordcount" WHERE 1 gives a correct result.
Reported by leo.van.nieuwenhuyse on 2015-06-27 15:33:41
Comments (3)
