Explain ? as number of rows

[Former user]

Originally reported on Google Code with ID 226

What steps will reproduce the problem?
1.
2.
3.

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


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


Please provide any additional information below.

Reported by nanozero87 on 2013-08-30 14:17:59

[Former user]

Sorry, miscard information :(
The problem it's on the attached image, DB information is
Size of database: 2123 KB
Database last modified: 4:00pm on August 30, 2013 (CEST)
SQLite version: 3.3.7
SQLite extension [?]: PDO
PHP version: 5.2.17

Reported by nanozero87 on 2013-08-30 14:19:54

<hr> * Attachment: issuesqliteadmin.jpg

[Christopher Kramer]

Sorry for the very late reply.
The reason for this is that the database is "big" (<=2 MB) and the table does not have
a primary key assigned to it. In this case, counting the number of records is quite
slow so we skip it in this case to make phpLiteAdmin respond faster.

I would always recommend to give a table a primary key.

I think we should add some explanation why there is a ? and how to solve it. And maybe
a link to force counting even though it might take long.

Reported by crazy4chrissi on 2013-12-23 22:45:56 - Status changed: Accepted - Labels added: Type-Enhancement - Labels removed: Type-Defect

[Christopher Kramer]

Of course I meant >=2MB, not <=

Reported by crazy4chrissi on 2013-12-23 22:46:30

[Christopher Kramer]

Reported by crazy4chrissi on 2013-12-23 23:18:39 - Labels added: Target-1.9.5

[Christopher Kramer]

This has just been fixed with revision 424.

Reported by crazy4chrissi on 2013-12-23 23:23:29 - Status changed: Fixed

[Christopher Kramer]

Reported by crazy4chrissi on 2014-01-02 16:20:01