· 8 years ago · Aug 29, 2018, 10:08 AM
1
2Exception Caught
3SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'email_body' can't have a default value:
4CREATE TABLE IF NOT EXISTS `exp_formgrab_forms` ( `form_id` INT UNSIGNED AUTO_INCREMENT, `site_id` INT UNSIGNED DEFAULT '0', `name` VARCHAR(255) DEFAULT '', `title` VARCHAR(255) DEFAULT '', `save_submission` CHAR(1) DEFAULT 'y', `status` VARCHAR(64) DEFAULT 'open', `return_url` VARCHAR(255) DEFAULT '', `email_notification` CHAR(1) DEFAULT 'n', `email_to` VARCHAR(512) DEFAULT '', `email_subject` VARCHAR(255) DEFAULT '', `email_body` TEXT DEFAULT '', `email_from_email` VARCHAR(255) DEFAULT '', `email_from_name` VARCHAR(255) DEFAULT '', `view_order` INT UNSIGNED DEFAULT '0', `created_at` INT(10) NOT NULL, `updated_at` INT(10) NOT NULL, PRIMARY KEY `form_id` (`form_id`), KEY `site_id` (`site_id`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE=InnoDB;
5
6ee/legacy/database/drivers/mysqli/mysqli_connection.php:116
7Stack Trace: Please include when reporting this error
8
9 #0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('CREATE TABLE IF...')
10 #1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('CREATE TABLE IF...')
11 #2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('CREATE TABLE IF...')
12 #3 ee/legacy/database/DB_forge.php(179): CI_DB_driver->query('CREATE TABLE IF...')
13 #4 user/addons/formgrab/upd.formgrab.php(82): CI_DB_forge->create_table('formgrab_forms', true)
14 #5 ee/legacy/libraries/addons/Addons_installer.php(67): Formgrab_upd->install()
15 #6 ee/legacy/libraries/addons/Addons_installer.php(385): Addons_installer->install_module('formgrab')
16 #7 ee/legacy/libraries/addons/Addons_installer.php(34): Addons_installer->_update_addon('formgrab', 'module', 'install', false)
17 #8 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(1502): Addons_installer->install('formgrab', 'module', false)
18 #9 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(736): EllisLab\ExpressionEngine\Controller\Addons\Addons->installModule('formgrab')
19 #10 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->install(Array)
20 #11 ee/EllisLab/ExpressionEngine/Core/Core.php(240): call_user_func_array(Array, Array)
21 #12 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
22 #13 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
23 #14 public/admin.php(147): require_once('...')
24 #14 public/admin.php(147): require_once('...')