NULL not displayed as Default Value for field when viewing table structure

[Former user]

Originally reported on Google Code with ID 142

When default value is NULL for a field/column, it is not shown as NULL when viewing
the table's structure. It is just shown as blank.

What version of the product are you using? On what operating system? 
phpLiteAdmin v1.9.3; Windows XP SP3

Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?
SQLite version: 2.8.17
SQLite extension: SQLiteDatabase

Reported by jgjooste on 2012-11-13 14:20:26

[Former user]

Hey jgjooste

Its now fixed in last svn 1.9.4 http://phpliteadmin.googlecode.com/svn/source/1.9.4/phpliteadmin.php

Thanks for reporting

Reported by teryaki1963 on 2012-11-13 15:09:32 - Status changed: Accepted

[Christopher Kramer]

Thanks jgjooste for reporting and thanks Ayman (teryaki1963) for fixing this.

Reported by crazy4chrissi on 2012-11-13 15:39:55 - Status changed: Fixed

[Former user]

Looks like this issue is still present in the latest development version. Somehow the
fix was "undone" (maybe while fixing Issue 149).

Reported by jgjooste on 2012-11-27 11:10:46

[Christopher Kramer]

Hmm... It works for me (s. screenshot). But the font color of the "NULL" text was so
light gray that it was hardly visible. I made it darker now. You still have the problem?

Maybe it's SQLiteDatabase specific. I was not able to test SQLiteDatabase yet (has
been dropped in PHP 5.4 ), only tested PDO.

Reported by crazy4chrissi on 2012-11-27 13:22:27

<hr> * Attachment: issue_142.png<br>

[Christopher Kramer]

Changing status back to NEW as it seems to be unclear again whether it is fixed or not.

Reported by crazy4chrissi on 2012-11-27 13:25:04 - Status changed: New

[Christopher Kramer]

I mark this as fixed as I did not receive any more feedback. If you or somebody else
still has problems, please comment again.

Reported by crazy4chrissi on 2013-03-18 16:59:41 - Status changed: Fixed