fixes to _create_table() in sqlite_forge.php:
removed space between table name and parenthesis
added version check for IF NOT EXISTS
diff --git a/system/database/drivers/sqlite/sqlite_forge.php b/system/database/drivers/sqlite/sqlite_forge.php
index e3196cc..1fd2a2b 100644
--- a/system/database/drivers/sqlite/sqlite_forge.php
+++ b/system/database/drivers/sqlite/sqlite_forge.php
@@ -76,12 +76,13 @@
{
$sql = 'CREATE TABLE ';
- if ($if_not_exists === TRUE)
+ // IF NOT EXISTS added to SQLite in 3.3.0
+ if ($if_not_exists === TRUE && version_compare($this->_version(), '3.3.0', '>=') === TRUE)
{
$sql .= 'IF NOT EXISTS ';
}
- $sql .= $this->db->_escape_table($table)." (";
+ $sql .= $this->db->_escape_table($table)."(";
$current_field_count = 0;
foreach ($fields as $field=>$attributes)