Ticket #1072 (fixed bug)
The DB class for SQLite doesn't maintain string values by default?
- Created: 2016-01-06 06:36:28
- Reported by: Visman
- Assigned to: quy
- Milestone: 1.5.10
- Component: database
- Priority: normal
sqlite.php file, add_field function:
if ($default_value === '')
$default_value = '\'\'';
if (!is_null($default_value))
$query .= ' DEFAULT '.$default_value;
If $default_value = 'jpg,jpeg,png,gif,mp3,zip,rar,7z', to query
... DEFAULT jpg,jpeg,png,gif,mp3,zip,rar,7z ...
Is it normal?
History

I don't have an installation with SQLite yet, so I don't fully understand what the issue is. Please elaborate. Thanks.
Visman 2016-01-15 06:35:59

if ($default_value === '')
$default_value = '\'\'';
--->
if (is_string($default_value))
$default_value = '\''.$this->escape($default_value).'\'';

I don't have SQLite to test. The code provided by Visman appears to be fine so here is the pull request:
https://github.com/fluxbb/fluxbb/pull/198