Change minimum required sqlite version to 3.7.11 [#2605594]

My environment:

PHP 5.5.21 (cli) (built: Jun 26 2015 05:29:29
SQLite version 3.6.20

which satisfies Drupal 8 requirements listed on https://www.drupal.org/requirements.

After failing to install through browser, in order to get more information I decided to give a try to Drush:

drush --version
 Drush Version   :  8.0-dev

Unfortunately, it is also failing giving the following error log:

drush site-install --db-url=sqlite://sites/default/files/.ht.sqlite
You are about to create a /home/drupal8/public_html/sites/default/settings.php file and CREATE the 'sites/default/files/.ht.sqlite' database. Do you want to continue? (y/n): y
Starting Drupal installation. This takes a while. Consider using the --notify global option.                                     [ok]
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 near ",": syntax error' in                              [error]
/home/drupal8/public_html/core/lib/Drupal/Core/Database/Driver/sqlite/Statement.php:87
Stack trace:
#0 /home/drupal8/public_html/core/lib/Drupal/Core/Database/Driver/sqlite/Statement.php(87): PDO->prepare('INSERT OR REPLA...')
#1 /home/drupal8/public_html/core/lib/Drupal/Core/Database/StatementPrefetch.php(163):
Drupal\Core\Database\Driver\sqlite\Statement->getStatement('INSERT OR REPLA...', Array)
#2 /home/drupal8/public_html/core/lib/Drupal/Core/Database/Driver/sqlite/Statement.php(95):
Drupal\Core\Database\StatementPrefetch->execute(Array, Array)
#3 /home/drupal8/public_html/core/lib/Drupal/Core/Database/Connection.php(615):
Drupal\Core\Database\Driver\sqlite\Statement->execute(Array, Array)
#4 /home/drupal8/public_html/core/lib/Drupal/Core/Database/Query/Upsert.php(111): Drupal\Core\Database\Connection->query('INSERT
OR REPLA...', Array, Array)
#5 /home/drupal8/public_html/core/lib/Drupal/Core/Cache/DatabaseBackend.php(239): Drupal\Core\Database\Query\Upsert->execute()
#6 /home/drupal8/public_html/core/lib/Drupal/Core/Cache/DatabaseBackend.php(169):
Drupal\Core\Cache\DatabaseBackend->doSetMultiple(Array)
#7 /home/drupal8/public_html/core/lib/Drupal/Core/Config/CachedStorage.php(110):
Drupal\Core\Cache\DatabaseBackend->setMultiple(Array)
#8 /home/drupal8/public_html/core/lib/Drupal/Core/Config/ConfigFactory.php(169):
Drupal\Core\Config\CachedStorage->readMultiple(Array)
#9 /home/drupal8/public_html/core/lib/Drupal/Core/Config/ConfigFactory.php(140):
Drupal\Core\Config\ConfigFactory->doLoadMultiple(Array)
#10 /home/drupal8/public_html/core/lib/Drupal/Core/Config/Entity/ConfigEntityStorage.php(189):
Drupal\Core\Config\ConfigFactory->loadMultiple(Array)
#11 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/EntityStorageBase.php(247):
Drupal\Core\Config\Entity\ConfigEntityStorage->doLoadMultiple(Array)
#12 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/EntityManager.php(565):
Drupal\Core\Entity\EntityStorageBase->loadMultiple(Array)
#13 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/EntityManager.php(525):
Drupal\Core\Entity\EntityManager->buildBundleFieldDefinitions('user', 'user', Array)
#14 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(569):
Drupal\Core\Entity\EntityManager->getFieldDefinitions('user', 'user')
#15 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(557):
Drupal\Core\Entity\ContentEntityBase->getFieldDefinitions()
#16 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(447):
Drupal\Core\Entity\ContentEntityBase->getFieldDefinition('langcode')
#17 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(631):
Drupal\Core\Entity\ContentEntityBase->hasField('langcode')
#18 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(228):
Drupal\Core\Entity\ContentEntityBase->setDefaultLangcode()
#19 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityStorageBase.php(89):
Drupal\Core\Entity\ContentEntityBase->__construct(Array, 'user', false)
#20 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/EntityStorageBase.php(189):
Drupal\Core\Entity\ContentEntityStorageBase->doCreate(Array)
#21 /home/drupal8/public_html/core/modules/user/user.install(74): Drupal\Core\Entity\EntityStorageBase->create(Array)
#22 [internal function]: user_install()
#23 /home/drupal8/public_html/core/lib/Drupal/Core/Extension/ModuleHandler.php(382): call_user_func_array('user_install', Array)
#24 /home/drupal8/public_html/core/lib/Drupal/Core/Extension/ModuleInstaller.php(288):
Drupal\Core\Extension\ModuleHandler->invoke('user', 'install')
#25 /home/drupal8/public_html/core/lib/Drupal/Core/ProxyClass/Extension/ModuleInstaller.php(87):
Drupal\Core\Extension\ModuleInstaller->install(Array, false)
#26 /home/drupal8/public_html/core/includes/install.core.inc(1040):
Drupal\Core\ProxyClass\Extension\ModuleInstaller->install(Array, false)
#27 /home/drupal8/public_html/core/includes/install.core.inc(645): install_base_system(Array)
#28 /home/drupal8/public_html/core/includes/install.core.inc(523): install_run_task(Array, Array)
#29 /home/drupal8/public_html/core/includes/install.core.inc(115): install_run_tasks(Array)
#30 /home/drupal8/.composer/vendor/drush/drush/includes/drush.inc(721): install_drupal(Object(Composer\Autoload\ClassLoader),
Array)
#31 /home/drupal8/.composer/vendor/drush/drush/includes/drush.inc(706): drush_call_user_func_array('install_drupal', Array)
#32 /home/drupal8/.composer/vendor/drush/drush/commands/core/drupal/site_install.inc(78): drush_op('install_drupal',
Object(Composer\Autoload\ClassLoader), Array)
#33 /home/drupal8/.composer/vendor/drush/drush/commands/core/site_install.drush.inc(289): drush_core_site_install_version(NULL,
Array)
#34 [internal function]: drush_core_site_install()
#35 /home/drupal8/.composer/vendor/drush/drush/includes/command.inc(364): call_user_func_array('drush_core_site...', Array)
#36 /home/drupal8/.composer/vendor/drush/drush/includes/command.inc(215): _drush_invoke_hooks(Array, Array)
#37 [internal function]: drush_command()
#38 /home/drupal8/.composer/vendor/drush/drush/includes/command.inc(183): call_user_func_array('drush_command', Array)
#39 /home/drupal8/.composer/vendor/drush/drush/lib/Drush/Boot/BaseBoot.php(62): drush_dispatch(Array)
#40 /home/drupal8/.composer/vendor/drush/drush/includes/preflight.inc(64): Drush\Boot\BaseBoot->bootstrap_and_dispatch()
#41 /home/drupal8/.composer/vendor/drush/drush/drush.php(12): drush_main()
#42 {main}

Next exception 'Drupal\Core\Database\DatabaseExceptionWrapper' with message 'SQLSTATE[HY000]: General error: 1 near ",": syntax
error: INSERT OR REPLACE INTO {cache_config} (cid, expire, created, tags, checksum, data, serialized) VALUES
(:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3,
:db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6), (:db_insert_placeholder_7,
:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11,
:db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15,
:db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19,
:db_insert_placeholder_20), (:db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23,
:db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27),
(:db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31,
:db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34), (:db_insert_placeholder_35,
:db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39,
:db_insert_placeholder_40, :db_insert_placeholder_41), (:db_insert_placeholder_42, :db_insert_placeholder_43,
:db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47,
:db_insert_placeholder_48), (:db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51,
:db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55),
(:db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59,
:db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62), (:db_insert_placeholder_63,
:db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67,
:db_insert_placeholder_68, :db_insert_placeholder_69), (:db_insert_placeholder_70, :db_insert_placeholder_71,
:db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75,
:db_insert_placeholder_76), (:db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79,
:db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83),
(:db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87,
:db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90), (:db_insert_placeholder_91,
:db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95,
:db_insert_placeholder_96, :db_insert_placeholder_97), (:db_insert_placeholder_98, :db_insert_placeholder_99,
:db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103,
:db_insert_placeholder_104), (:db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107,
:db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111),
(:db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115,
:db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118); Array
(
    [:db_insert_placeholder_0] => core.base_field_override.user.user.uid
    [:db_insert_placeholder_1] => -1
    [:db_insert_placeholder_2] => 1446309899.659
    [:db_insert_placeholder_3] => 
    [:db_insert_placeholder_4] => 0
    [:db_insert_placeholder_5] => b:0;
    [:db_insert_placeholder_6] => 1
    [:db_insert_placeholder_7] => core.base_field_override.user.user.uuid
    [:db_insert_placeholder_8] => -1
    [:db_insert_placeholder_9] => 1446309899.659
    [:db_insert_placeholder_10] => 
    [:db_insert_placeholder_11] => 0
    [:db_insert_placeholder_12] => b:0;
    [:db_insert_placeholder_13] => 1
    [:db_insert_placeholder_14] => core.base_field_override.user.user.langcode
    [:db_insert_placeholder_15] => -1
    [:db_insert_placeholder_16] => 1446309899.659
    [:db_insert_placeholder_17] => 
    [:db_insert_placeholder_18] => 0
    [:db_insert_placeholder_19] => b:0;
    [:db_insert_placeholder_20] => 1
    [:db_insert_placeholder_21] => core.base_field_override.user.user.preferred_langcode
    [:db_insert_placeholder_22] => -1
    [:db_insert_placeholder_23] => 1446309899.659
    [:db_insert_placeholder_24] => 
    [:db_insert_placeholder_25] => 0
    [:db_insert_placeholder_26] => b:0;
    [:db_insert_placeholder_27] => 1
    [:db_insert_placeholder_28] => core.base_field_override.user.user.preferred_admin_langcode
    [:db_insert_placeholder_29] => -1
    [:db_insert_placeholder_30] => 1446309899.659
    [:db_insert_placeholder_31] => 
    [:db_insert_placeholder_32] => 0
    [:db_insert_placeholder_33] => b:0;
    [:db_insert_placeholder_34] => 1
    [:db_insert_placeholder_35] => core.base_field_override.user.user.name
    [:db_insert_placeholder_36] => -1
    [:db_insert_placeholder_37] => 1446309899.659
    [:db_insert_placeholder_38] => 
    [:db_insert_placeholder_39] => 0
    [:db_insert_placeholder_40] => b:0;
    [:db_insert_placeholder_41] => 1
    [:db_insert_placeholder_42] => core.base_field_override.user.user.pass
    [:db_insert_placeholder_43] => -1
    [:db_insert_placeholder_44] => 1446309899.659
    [:db_insert_placeholder_45] => 
    [:db_insert_placeholder_46] => 0
    [:db_insert_placeholder_47] => b:0;
    [:db_insert_placeholder_48] => 1
    [:db_insert_placeholder_49] => core.base_field_override.user.user.mail
    [:db_insert_placeholder_50] => -1
    [:db_insert_placeholder_51] => 1446309899.659
    [:db_insert_placeholder_52] => 
    [:db_insert_placeholder_53] => 0
    [:db_insert_placeholder_54] => b:0;
    [:db_insert_placeholder_55] => 1
    [:db_insert_placeholder_56] => core.base_field_override.user.user.timezone
    [:db_insert_placeholder_57] => -1
    [:db_insert_placeholder_58] => 1446309899.659
    [:db_insert_placeholder_59] => 
    [:db_insert_placeholder_60] => 0
    [:db_insert_placeholder_61] => b:0;
    [:db_insert_placeholder_62] => 1
    [:db_insert_placeholder_63] => core.base_field_override.user.user.status
    [:db_insert_placeholder_64] => -1
    [:db_insert_placeholder_65] => 1446309899.659
    [:db_insert_placeholder_66] => 
    [:db_insert_placeholder_67] => 0
    [:db_insert_placeholder_68] => b:0;
    [:db_insert_placeholder_69] => 1
    [:db_insert_placeholder_70] => core.base_field_override.user.user.created
    [:db_insert_placeholder_71] => -1
    [:db_insert_placeholder_72] => 1446309899.659
    [:db_insert_placeholder_73] => 
    [:db_insert_placeholder_74] => 0
    [:db_insert_placeholder_75] => b:0;
    [:db_insert_placeholder_76] => 1
    [:db_insert_placeholder_77] => core.base_field_override.user.user.changed
    [:db_insert_placeholder_78] => -1
    [:db_insert_placeholder_79] => 1446309899.659
    [:db_insert_placeholder_80] => 
    [:db_insert_placeholder_81] => 0
    [:db_insert_placeholder_82] => b:0;
    [:db_insert_placeholder_83] => 1
    [:db_insert_placeholder_84] => core.base_field_override.user.user.access
    [:db_insert_placeholder_85] => -1
    [:db_insert_placeholder_86] => 1446309899.659
    [:db_insert_placeholder_87] => 
    [:db_insert_placeholder_88] => 0
    [:db_insert_placeholder_89] => b:0;
    [:db_insert_placeholder_90] => 1
    [:db_insert_placeholder_91] => core.base_field_override.user.user.login
    [:db_insert_placeholder_92] => -1
    [:db_insert_placeholder_93] => 1446309899.659
    [:db_insert_placeholder_94] => 
    [:db_insert_placeholder_95] => 0
    [:db_insert_placeholder_96] => b:0;
    [:db_insert_placeholder_97] => 1
    [:db_insert_placeholder_98] => core.base_field_override.user.user.init
    [:db_insert_placeholder_99] => -1
    [:db_insert_placeholder_100] => 1446309899.659
    [:db_insert_placeholder_101] => 
    [:db_insert_placeholder_102] => 0
    [:db_insert_placeholder_103] => b:0;
    [:db_insert_placeholder_104] => 1
    [:db_insert_placeholder_105] => core.base_field_override.user.user.roles
    [:db_insert_placeholder_106] => -1
    [:db_insert_placeholder_107] => 1446309899.659
    [:db_insert_placeholder_108] => 
    [:db_insert_placeholder_109] => 0
    [:db_insert_placeholder_110] => b:0;
    [:db_insert_placeholder_111] => 1
    [:db_insert_placeholder_112] => core.base_field_override.user.user.default_langcode
    [:db_insert_placeholder_113] => -1
    [:db_insert_placeholder_114] => 1446309899.659
    [:db_insert_placeholder_115] => 
    [:db_insert_placeholder_116] => 0
    [:db_insert_placeholder_117] => b:0;
    [:db_insert_placeholder_118] => 1
)
' in /home/drupal8/public_html/core/lib/Drupal/Core/Database/Connection.php:676
Stack trace:
#0 /home/drupal8/public_html/core/lib/Drupal/Core/Database/Driver/sqlite/Connection.php(324):
Drupal\Core\Database\Connection->handleQueryException(Object(PDOException), 'INSERT OR REPLA...', Array, Array)
#1 /home/drupal8/public_html/core/lib/Drupal/Core/Database/Connection.php(640):
Drupal\Core\Database\Driver\sqlite\Connection->handleQueryException(Object(PDOException), 'INSERT OR REPLA...', Array, Array)
#2 /home/drupal8/public_html/core/lib/Drupal/Core/Database/Query/Upsert.php(111): Drupal\Core\Database\Connection->query('INSERT
OR REPLA...', Array, Array)
#3 /home/drupal8/public_html/core/lib/Drupal/Core/Cache/DatabaseBackend.php(239): Drupal\Core\Database\Query\Upsert->execute()
#4 /home/drupal8/public_html/core/lib/Drupal/Core/Cache/DatabaseBackend.php(169):
Drupal\Core\Cache\DatabaseBackend->doSetMultiple(Array)
#5 /home/drupal8/public_html/core/lib/Drupal/Core/Config/CachedStorage.php(110):
Drupal\Core\Cache\DatabaseBackend->setMultiple(Array)
#6 /home/drupal8/public_html/core/lib/Drupal/Core/Config/ConfigFactory.php(169):
Drupal\Core\Config\CachedStorage->readMultiple(Array)
#7 /home/drupal8/public_html/core/lib/Drupal/Core/Config/ConfigFactory.php(140):
Drupal\Core\Config\ConfigFactory->doLoadMultiple(Array)
#8 /home/drupal8/public_html/core/lib/Drupal/Core/Config/Entity/ConfigEntityStorage.php(189):
Drupal\Core\Config\ConfigFactory->loadMultiple(Array)
#9 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/EntityStorageBase.php(247):
Drupal\Core\Config\Entity\ConfigEntityStorage->doLoadMultiple(Array)
#10 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/EntityManager.php(565):
Drupal\Core\Entity\EntityStorageBase->loadMultiple(Array)
#11 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/EntityManager.php(525):
Drupal\Core\Entity\EntityManager->buildBundleFieldDefinitions('user', 'user', Array)
#12 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(569):
Drupal\Core\Entity\EntityManager->getFieldDefinitions('user', 'user')
#13 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(557):
Drupal\Core\Entity\ContentEntityBase->getFieldDefinitions()
#14 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(447):
Drupal\Core\Entity\ContentEntityBase->getFieldDefinition('langcode')
#15 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(631):
Drupal\Core\Entity\ContentEntityBase->hasField('langcode')
#16 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityBase.php(228):
Drupal\Core\Entity\ContentEntityBase->setDefaultLangcode()
#17 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/ContentEntityStorageBase.php(89):
Drupal\Core\Entity\ContentEntityBase->__construct(Array, 'user', false)
#18 /home/drupal8/public_html/core/lib/Drupal/Core/Entity/EntityStorageBase.php(189):
Drupal\Core\Entity\ContentEntityStorageBase->doCreate(Array)
#19 /home/drupal8/public_html/core/modules/user/user.install(74): Drupal\Core\Entity\EntityStorageBase->create(Array)
#20 [internal function]: user_install()
#21 /home/drupal8/public_html/core/lib/Drupal/Core/Extension/ModuleHandler.php(382): call_user_func_array('user_install', Array)
#22 /home/drupal8/public_html/core/lib/Drupal/Core/Extension/ModuleInstaller.php(288):
Drupal\Core\Extension\ModuleHandler->invoke('user', 'install')
#23 /home/drupal8/public_html/core/lib/Drupal/Core/ProxyClass/Extension/ModuleInstaller.php(87):
Drupal\Core\Extension\ModuleInstaller->install(Array, false)
#24 /home/drupal8/public_html/core/includes/install.core.inc(1040):
Drupal\Core\ProxyClass\Extension\ModuleInstaller->install(Array, false)
#25 /home/drupal8/public_html/core/includes/install.core.inc(645): install_base_system(Array)
#26 /home/drupal8/public_html/core/includes/install.core.inc(523): install_run_task(Array, Array)
#27 /home/drupal8/public_html/core/includes/install.core.inc(115): install_run_tasks(Array)
#28 /home/drupal8/.composer/vendor/drush/drush/includes/drush.inc(721): install_drupal(Object(Composer\Autoload\ClassLoader),
Array)
#29 /home/drupal8/.composer/vendor/drush/drush/includes/drush.inc(706): drush_call_user_func_array('install_drupal', Array)
#30 /home/drupal8/.composer/vendor/drush/drush/commands/core/drupal/site_install.inc(78): drush_op('install_drupal',
Object(Composer\Autoload\ClassLoader), Array)
#31 /home/drupal8/.composer/vendor/drush/drush/commands/core/site_install.drush.inc(289): drush_core_site_install_version(NULL,
Array)
#32 [internal function]: drush_core_site_install()
#33 /home/drupal8/.composer/vendor/drush/drush/includes/command.inc(364): call_user_func_array('drush_core_site...', Array)
#34 /home/drupal8/.composer/vendor/drush/drush/includes/command.inc(215): _drush_invoke_hooks(Array, Array)
#35 [internal function]: drush_command()
#36 /home/drupal8/.composer/vendor/drush/drush/includes/command.inc(183): call_user_func_array('drush_command', Array)
#37 /home/drupal8/.composer/vendor/drush/drush/lib/Drush/Boot/BaseBoot.php(62): drush_dispatch(Array)
#38 /home/drupal8/.composer/vendor/drush/drush/includes/preflight.inc(64): Drush\Boot\BaseBoot->bootstrap_and_dispatch()
#39 /home/drupal8/.composer/vendor/drush/drush/drush.php(12): drush_main()
#40 {main}

Comment	File	Size	Author
#26	2605594-26.patch	1.08 KB	daffie
#26	8.1.x: PHP 5.5 & MySQL 5.5 18,655 pass PHP 5.5 & SQLite 3.8 18,650 pass PHP 7 & SQLite 3.14 18,640 pass
#19	2605594-19.patch	1.08 KB	daffie
#19	8.1.x: PHP 5.5 & MySQL 5.5 18,643 pass PHP 5.5 & SQLite 3.8 18,648 pass PHP 7 & SQLite 3.14 18,638 pass
#16	2605594-16.patch	1.08 KB	daffie
#16	8.1.x: PHP 5.5 & MySQL 5.5 18,640 pass PHP 5.5 & SQLite 3.8 14,106 pass, 3,252 fail PHP 7 & SQLite 3.14 18,625 pass

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

31 October 2015 at 17:49

yngens2 created an issue. See original summary.

Comment #2

pukku CreditAttribution: pukku commented 26 May 2016 at 15:14

Did you ever find a solution to this? I'm running into the same problem trying to install Drupal 8.1.1 on php 5.6.21, with sqlite 3.6.20.

Thanks,
Ricky

Comment #3

pukku CreditAttribution: pukku commented 26 May 2016 at 15:15

Version:

8.0.0-rc2

» 8.1.1

Comment #4

pukku CreditAttribution: pukku commented 1 June 2016 at 20:49

Title:	PDOException SQLSTATE[HY000]: General error: 1 near “,”: syntax error' in ../sqlite/Statement.php:87	» SQLite installation error (syntax error on INSERT OR REPLACE INTO {cache_config})
Priority:	Normal	» Critical

It's not possible to install Drupal 8.1.1 using SQLite as the database engine. Because of this error, none of the user tables get loaded, so you cannot log into the site.

Comment #5

alexpott

he/they

English

🇪🇺🌍

CreditAttribution: alexpott at Chapter Three commented 2 June 2016 at 09:21

Priority:

Critical

» Major

Works for me on:
sqlite3 --version
3.8.10.2 2015-05-20 18:17:19 2ef4f3a5b1d1d0c4338f8243d40a2452cc1f7fe4

This can't be a critical bug as SQLite support works for me and as you've not even got the site installed we're not rendering a site unusable. SQLite is just not the common use case.

Is there any chance that the full query that's failing can be extracted? Also SQLite 3.6 is 5 over years old... it's time to move on...

Comment #6

pukku CreditAttribution: pukku commented 2 June 2016 at 14:33

Hi! The full error, including the query is below. With regard to the version issue, the SQLite version is the one that is on my system (CentOS 6.7), which meets the requirements on https://www.drupal.org/requirements : SQLite 3.6.8 or higher . If this version is too old, this page should be updated. I apologize for making the severity too high; my thought was that being unable to install the software would count as highly critical; your logic also makes sense.

The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1 near ",": syntax error: INSERT OR REPLACE INTO {cache_config} (cid, expire, created, tags, checksum, data, serialized) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6), (:db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20), (:db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27), (:db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34), (:db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41), (:db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48), (:db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55), (:db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62), (:db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69), (:db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76), (:db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83), (:db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90), (:db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97), (:db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104), (:db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111), (:db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118); Array ( [:db_insert_placeholder_0] => core.base_field_override.user.user.uid [:db_insert_placeholder_1] => -1 [:db_insert_placeholder_2] => 1464813319.145 [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => b:0; [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => core.base_field_override.user.user.uuid [:db_insert_placeholder_8] => -1 [:db_insert_placeholder_9] => 1464813319.145 [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => b:0; [:db_insert_placeholder_13] => 1 [:db_insert_placeholder_14] => core.base_field_override.user.user.langcode [:db_insert_placeholder_15] => -1 [:db_insert_placeholder_16] => 1464813319.145 [:db_insert_placeholder_17] => [:db_insert_placeholder_18] => 0 [:db_insert_placeholder_19] => b:0; [:db_insert_placeholder_20] => 1 [:db_insert_placeholder_21] => core.base_field_override.user.user.preferred_langcode [:db_insert_placeholder_22] => -1 [:db_insert_placeholder_23] => 1464813319.145 [:db_insert_placeholder_24] => [:db_insert_placeholder_25] => 0 [:db_insert_placeholder_26] => b:0; [:db_insert_placeholder_27] => 1 [:db_insert_placeholder_28] => core.base_field_override.user.user.preferred_admin_langcode [:db_insert_placeholder_29] => -1 [:db_insert_placeholder_30] => 1464813319.145 [:db_insert_placeholder_31] => [:db_insert_placeholder_32] => 0 [:db_insert_placeholder_33] => b:0; [:db_insert_placeholder_34] => 1 [:db_insert_placeholder_35] => core.base_field_override.user.user.name [:db_insert_placeholder_36] => -1 [:db_insert_placeholder_37] => 1464813319.145 [:db_insert_placeholder_38] => [:db_insert_placeholder_39] => 0 [:db_insert_placeholder_40] => b:0; [:db_insert_placeholder_41] => 1 [:db_insert_placeholder_42] => core.base_field_override.user.user.pass [:db_insert_placeholder_43] => -1 [:db_insert_placeholder_44] => 1464813319.145 [:db_insert_placeholder_45] => [:db_insert_placeholder_46] => 0 [:db_insert_placeholder_47] => b:0; [:db_insert_placeholder_48] => 1 [:db_insert_placeholder_49] => core.base_field_override.user.user.mail [:db_insert_placeholder_50] => -1 [:db_insert_placeholder_51] => 1464813319.145 [:db_insert_placeholder_52] => [:db_insert_placeholder_53] => 0 [:db_insert_placeholder_54] => b:0; [:db_insert_placeholder_55] => 1 [:db_insert_placeholder_56] => core.base_field_override.user.user.timezone [:db_insert_placeholder_57] => -1 [:db_insert_placeholder_58] => 1464813319.145 [:db_insert_placeholder_59] => [:db_insert_placeholder_60] => 0 [:db_insert_placeholder_61] => b:0; [:db_insert_placeholder_62] => 1 [:db_insert_placeholder_63] => core.base_field_override.user.user.status [:db_insert_placeholder_64] => -1 [:db_insert_placeholder_65] => 1464813319.145 [:db_insert_placeholder_66] => [:db_insert_placeholder_67] => 0 [:db_insert_placeholder_68] => b:0; [:db_insert_placeholder_69] => 1 [:db_insert_placeholder_70] => core.base_field_override.user.user.created [:db_insert_placeholder_71] => -1 [:db_insert_placeholder_72] => 1464813319.145 [:db_insert_placeholder_73] => [:db_insert_placeholder_74] => 0 [:db_insert_placeholder_75] => b:0; [:db_insert_placeholder_76] => 1 [:db_insert_placeholder_77] => core.base_field_override.user.user.changed [:db_insert_placeholder_78] => -1 [:db_insert_placeholder_79] => 1464813319.145 [:db_insert_placeholder_80] => [:db_insert_placeholder_81] => 0 [:db_insert_placeholder_82] => b:0; [:db_insert_placeholder_83] => 1 [:db_insert_placeholder_84] => core.base_field_override.user.user.access [:db_insert_placeholder_85] => -1 [:db_insert_placeholder_86] => 1464813319.145 [:db_insert_placeholder_87] => [:db_insert_placeholder_88] => 0 [:db_insert_placeholder_89] => b:0; [:db_insert_placeholder_90] => 1 [:db_insert_placeholder_91] => core.base_field_override.user.user.login [:db_insert_placeholder_92] => -1 [:db_insert_placeholder_93] => 1464813319.145 [:db_insert_placeholder_94] => [:db_insert_placeholder_95] => 0 [:db_insert_placeholder_96] => b:0; [:db_insert_placeholder_97] => 1 [:db_insert_placeholder_98] => core.base_field_override.user.user.init [:db_insert_placeholder_99] => -1 [:db_insert_placeholder_100] => 1464813319.145 [:db_insert_placeholder_101] => [:db_insert_placeholder_102] => 0 [:db_insert_placeholder_103] => b:0; [:db_insert_placeholder_104] => 1 [:db_insert_placeholder_105] => core.base_field_override.user.user.roles [:db_insert_placeholder_106] => -1 [:db_insert_placeholder_107] => 1464813319.145 [:db_insert_placeholder_108] => [:db_insert_placeholder_109] => 0 [:db_insert_placeholder_110] => b:0; [:db_insert_placeholder_111] => 1 [:db_insert_placeholder_112] => core.base_field_override.user.user.default_langcode [:db_insert_placeholder_113] => -1 [:db_insert_placeholder_114] => 1464813319.146 [:db_insert_placeholder_115] => [:db_insert_placeholder_116] => 0 [:db_insert_placeholder_117] => b:0; [:db_insert_placeholder_118] => 1 ) in Drupal\Core\Config\CachedStorage->readMultiple() (line 105 of core/lib/Drupal/Core/Config/CachedStorage.php).
Drupal\Core\Config\CachedStorage->readMultiple(Array) (Line: 165)
Drupal\Core\Config\ConfigFactory->doLoadMultiple(Array) (Line: 136)
Drupal\Core\Config\ConfigFactory->loadMultiple(Array) (Line: 184)
Drupal\Core\Config\Entity\ConfigEntityStorage->doLoadMultiple(Array) (Line: 242)
Drupal\Core\Entity\EntityStorageBase->loadMultiple(Array) (Line: 338)
Drupal\Core\Entity\EntityFieldManager->buildBundleFieldDefinitions('user', 'user', Array) (Line: 298)
Drupal\Core\Entity\EntityFieldManager->getFieldDefinitions('user', 'user') (Line: 143)
Drupal\Core\Entity\EntityManager->getFieldDefinitions('user', 'user') (Line: 566)
Drupal\Core\Entity\ContentEntityBase->getFieldDefinitions() (Line: 554)
Drupal\Core\Entity\ContentEntityBase->getFieldDefinition('langcode') (Line: 444)
Drupal\Core\Entity\ContentEntityBase->hasField('langcode') (Line: 628)
Drupal\Core\Entity\ContentEntityBase->setDefaultLangcode() (Line: 225)
Drupal\Core\Entity\ContentEntityBase->__construct(Array, 'user', ) (Line: 87)
Drupal\Core\Entity\ContentEntityStorageBase->doCreate(Array) (Line: 184)
Drupal\Core\Entity\EntityStorageBase->create(Array) (Line: 74)
user_install()
call_user_func_array('user_install', Array) (Line: 391)
Drupal\Core\Extension\ModuleHandler->invoke('user', 'install') (Line: 287)
Drupal\Core\Extension\ModuleInstaller->install(Array, ) (Line: 83)
Drupal\Core\ProxyClass\Extension\ModuleInstaller->install(Array, ) (Line: 1047)
install_base_system(Array) (Line: 652)
install_run_task(Array, Array) (Line: 530)
install_run_tasks(Array) (Line: 115)
install_drupal(Object) (Line: 39)

Comment #7

amateescu CreditAttribution: amateescu for Pfizer, Inc. commented 2 June 2016 at 14:36

Version:	8.1.1	» 8.1.x-dev
Issue tags:	-installation

The version of SQLite is actually the problem here. According to http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-mult... , it seems that we need a different syntax for upsert queries if we want to continue supporting SQLite 3.6.8.

Alternatively, we could bump the minimum supported version to 3.7.11.

Comment #8

Chi CreditAttribution: Chi commented 2 June 2016 at 17:58

What is the default version of SQLite in the repositories of popular Linux distributions?

Comment #9

pukku CreditAttribution: pukku commented 3 June 2016 at 16:15

I'm not sure how you define popular. For CentOS 6.x, it seems to be SQLite 3.6.20. CentOS 7 (which is not yet supported by my hospital) is 3.7.17. I think that RHEL 6 and RHEL 7 are commensurate with CentOS (well, the other way around, really). It looks like Fedora 23 has 3.8.11, Fedora 22 has 3.8.9, and older Fedoras don't exist any more. Debian stable has 3.8.7 (and I assume that testing and unstable have at least that). Ubuntu probably follows Debian?

It does look like the older CentOS and RHEL are the outliers, but they may be popular? I don't know.

I do know that I've been explicitly told that you cannot upgrade SQLite on CentOS because it breaks a lot of the OS management software.

Is it possible that there was a change between 8.0 and 8.1 that added the multiple values statements? I could try installing 8.0 instead of 8.1, I suppose.

Comment #10

daffie CreditAttribution: daffie commented 27 June 2016 at 16:17

Priority:

Major

» Critical

I am putting the priority back to critical because https://www.drupal.org/requirements are saying that Drupal 8 is supported on SQLite 3.6.8 or higher. The problem is occurring on databases with SQLite 3.6.20 and that is higher then 3.6.8. Unable to install Drupal is for me "Render a site unusable and have no workaround." and that makes it priority critical.
User amateescu has confirmed in comment #7 that the problem is related to the version of SQLite that is being used. He is suggesting that we bump up the minimum version to SQLite 3.7.11.

Comment #11

catch

he/him

English

CreditAttribution: catch at Third and Grove commented 27 June 2016 at 16:32

A minimum version increase sounds fine to me, if you're running sqlite you're likely to be able to update it.

Comment #12

daffie CreditAttribution: daffie commented 27 June 2016 at 16:41

@catch: Is it possible to change the version of SQLite on the testbot to the minimum version in the https://www.drupal.org/requirements? Just as we are now doing with MySQL and PostgreSQL. We are now using SQLite version 3.8 on the testbot.

Comment #13

catch

he/him

English

CreditAttribution: catch at Third and Grove commented 27 June 2016 at 16:51

Title:

SQLite installation error (syntax error on INSERT OR REPLACE INTO {cache_config})

» Change minimum required sqlite version to 3.8

Re-titiling to get some more feedback. That's fine with me personally - if people are running < 3.8 already and if they don't upgrade, they're no worse off than they are now - we already don't test on lower versions and in this case have a critical bug with one.

Comment #14

daffie CreditAttribution: daffie commented 27 June 2016 at 17:03

+1 With upgrading the minimum version of SQLite to 3.8.

Comment #15

pukku CreditAttribution: pukku commented 27 June 2016 at 17:30

Hi! I disagree with the comment that if you are running SQLite you can upgrade it. For CentOS at least, which I'm required to use by the hospital, you cannot upgrade the SQLite version provided with the system without breaking it. It's tied in somehow to the package management system.

Comment #16

daffie CreditAttribution: daffie commented 28 June 2016 at 08:03

Status:

Active

» Needs review

File	Size
2605594-16.patch	1.08 KB
8.1.x: PHP 5.5 & MySQL 5.5 18,640 pass PHP 5.5 & SQLite 3.8 14,106 pass, 3,252 fail PHP 7 & SQLite 3.14 18,625 pass

alexpott is using version 3.8.10. I am not sure if that is the testbot version or his local development version. In the added patch I am upgrading the minimum version for SQLite to 3.8.10. If anybody knowns what version we are using on the testbot can you let me know.

Comment #17

daffie CreditAttribution: daffie commented 28 June 2016 at 08:12

Added change record.

Comment #18

Mixologic

He/Him/His

English

Portland, OR

CreditAttribution: Mixologic at Drupal Association commented 28 June 2016 at 13:50

Testbots are currently running 3.8.2

Comment #19

daffie CreditAttribution: daffie commented 28 June 2016 at 16:21

File	Size
2605594-19.patch	1.08 KB
8.1.x: PHP 5.5 & MySQL 5.5 18,643 pass PHP 5.5 & SQLite 3.8 18,648 pass PHP 7 & SQLite 3.14 18,638 pass

1 file was hidden/shown/deleted

File	Size
2605594-16.patch	1.08 KB
8.1.x: PHP 5.5 & MySQL 5.5 18,640 pass PHP 5.5 & SQLite 3.8 14,106 pass, 3,252 fail PHP 7 & SQLite 3.14 18,625 pass

Setting the minimum supported version of SQLite to 3.8.2. That is same version as the testbot.

@Mixologic: Thanks for the info.

Comment #20

alexpott

he/they

English

🇪🇺🌍

CreditAttribution: alexpott at Chapter Three commented 30 June 2016 at 18:27

Issue tags:

+Triaged D8 critical

Discussed with @catch, @xjm, @effulgentsia and @Cottser. We decided that bumping the minimum requirement to minimum needed version. As Drupal 8 has never worked on SQLLite 3.6.20 we're not breaking any exiting sites by bumping the version. Also if you have already installed D8 on a lower version then it won't break as this is an install time check. We agreed to keep this critical as Drupal not working on its declared requirements is wrong.

The minimum requirement should be bumped minimum needed version - this is lower than what testbot is testing but at least it is friendly to Centos 7 users - it comes with 3.7.17

Comment #21

effulgentsia CreditAttribution: effulgentsia at Acquia commented 30 June 2016 at 19:34

Title:

Change minimum required sqlite version to 3.8

» Change minimum required sqlite version to 3.7.11

The minimum requirement should be bumped minimum needed version

Retitling accordingly. See #7.

Comment #22

effulgentsia CreditAttribution: effulgentsia at Acquia commented 30 June 2016 at 19:34

Status:

Needs review

» Needs work

Comment #23

daffie CreditAttribution: daffie commented 1 July 2016 at 10:50

I understand why we want to support Centos 7 users and set the minimum version to 3.7.11. And as far as can see now that is fine by me. The problem that I see is that are now going to support a version of SQLite of which we have no idea how Drupal 8 will run on it. We are now supporting SQLite version 3.6.8 and we where completely supprised that on version 3.6.20 Drupal 8 was not even installable let alone workable. We have no idea if Drupal 8 is installable and workable on a SQLite version greater or equel then 3.7.11 and smaller then 3.8.2 (the testbot uses 3.8.2). And that is something I do not like. I see two options how to fix this:

Use SQLite 3.7.11 on the testbot
Set the minimum SQLite version to 3.8.2

Comment #24

Chi CreditAttribution: Chi commented 1 July 2016 at 11:15

@daffe, besides 3.7.11 and 3.8.2 there are other releases that may be not compatible with Drupal 8. We don't have an opportunity to run tests against all SQLite versions.

Comment #25

Mixologic

He/Him/His

English

Portland, OR

CreditAttribution: Mixologic at Drupal Association commented 1 July 2016 at 19:41

Use SQLite 3.7.11 on the testbot

Please open an issue in https://drupal.org/project/drupalci_testbot If that ends up being the plan.

Comment #26

daffie CreditAttribution: daffie commented 2 July 2016 at 09:04

Status:

Needs work

» Needs review

File	Size
2605594-26.patch	1.08 KB
8.1.x: PHP 5.5 & MySQL 5.5 18,655 pass PHP 5.5 & SQLite 3.8 18,650 pass PHP 7 & SQLite 3.14 18,640 pass

1 file was hidden/shown/deleted

File	Size
2605594-19.patch	1.08 KB
8.1.x: PHP 5.5 & MySQL 5.5 18,643 pass PHP 5.5 & SQLite 3.8 18,648 pass PHP 7 & SQLite 3.14 18,638 pass

The patch for upgrading the minimum version of SQLite to 3.7.11.

Comment #27

catch

he/him

English

CreditAttribution: catch at Third and Grove commented 4 July 2016 at 10:11

Status:

Needs review

» Reviewed & tested by the community

I think this is good. We can consider downgrading the test bot, or further raising the requirements elsewhere - but at least if we raise the requirements again, we can point CentOS 7 users to this issue and show that we tried to support it for as long as reasonable.

Comment #28

4 July 2016 at 11:09

Status:

Reviewed & tested by the community

» Needs work

The last submitted patch, 26: 2605594-26.patch, failed testing.

Comment #29

daffie CreditAttribution: daffie commented 4 July 2016 at 11:56

Status:

Needs work

» Reviewed & tested by the community

Back to RTBC.

Comment #30

alexpott

he/they

English

🇪🇺🌍

CreditAttribution: alexpott at Chapter Three commented 5 July 2016 at 08:46

Status:

Reviewed & tested by the community

» Fixed

Committed 46c9b4d and pushed to 8.1.x and 8.2.x. Thanks!

Comment #31

5 July 2016 at 08:46

alexpott committed eadde8d on 8.2.x

Issue #2605594 by daffie, pukku, catch, yngens2: Change minimum required...

Comment #32

5 July 2016 at 08:46

alexpott committed 46c9b4d on 8.1.x

Issue #2605594 by daffie, pukku, catch, yngens2: Change minimum required...

Comment #33

alexpott

he/they

English

🇪🇺🌍

CreditAttribution: alexpott at Chapter Three commented 5 July 2016 at 08:47

Issue tags:

+8.1.4 release notes

Comment #34

daffie CreditAttribution: daffie commented 5 July 2016 at 09:02

Created a followup for the testbot: #2760645: Downgrade SQLite to 3.7.11.

Comment #35

chx CreditAttribution: chx at Smartsheet commented 5 July 2016 at 12:08

As we just passed 3.7.0 WAL is now available. An issue should be opened to investigate whether it's the right choice for us. Extremely relevant #1120020-25: SQLite database locking errors cause fatal errors.

Also, we should point out that 3.8.11 is recommended as it is significantly faster (twice than 3.8.0, thrice than 3.3.0).

Also, daffie should be named SQLite maintainer if they accept.