Declaration of getID3_cached_sqlite3 about getid3 HOT 6 CLOSED

Fixed in d5c2918

Mirroring the similar fix (1e1f1a0) in the MySQL cache extension, I have modified the parent::analyze call

from getid3.

thanks, next issue

SQLite3Stmt::execute(): Unable to execute statement: NOT NULL constraint failed: media_cache.filesize in extension.cache.sqlite3.php on line 195

from getid3.

I am not at all familiar with SQLite, perhaps someone who is can comment and recommend a fix.

from getid3.

Fixed

Solution this line

return "CREATE TABLE IF NOT EXISTS $this->table (filename VARCHAR(255) NOT NULL DEFAULT '', dirname VARCHAR(255) NOT NULL DEFAULT '', filesize INT(11) NOT NULL DEFAULT '0', filetime INT(11) NOT NULL DEFAULT '0', analyzetime INT(11) NOT NULL DEFAULT '0', val text not null, PRIMARY KEY (filename, filesize, filetime))";

to

return "CREATE TABLE IF NOT EXISTS $this->table (filename VARCHAR(255) DEFAULT '', dirname VARCHAR(255) DEFAULT '', filesize INT(11) DEFAULT '0', filetime INT(11) DEFAULT '0', analyzetime INT(11) DEFAULT '0', val text, PRIMARY KEY (filename, filesize, filetime))";

from getid3.

sqlite allow the use of null entries in a primary key column. least one column of the primary key to be not null

from getid3.

Taking your word for it, updated in de973d5

from getid3.