Skip to content

Instantly share code, notes, and snippets.

@hendrikeng
Created September 8, 2018 14:11
Show Gist options
  • Save hendrikeng/67503b30b9b3e6e5faac40c6b4d984c1 to your computer and use it in GitHub Desktop.
Save hendrikeng/67503b30b9b3e6e5faac40c6b4d984c1 to your computer and use it in GitHub Desktop.
2018-09-08 16:08:42 [-][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=wfw;port=3306;
2018-09-08 16:08:42 [-][-][-][profile begin][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=wfw;port=3306;
2018-09-08 16:08:42 [-][-][-][profile end][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=wfw;port=3306;
2018-09-08 16:08:42 [-][-][-][info][yii\db\Command::query] SHOW TABLES
2018-09-08 16:08:42 [-][-][-][profile begin][yii\db\Command::query] SHOW TABLES
2018-09-08 16:08:42 [-][-][-][profile end][yii\db\Command::query] SHOW TABLES
2018-09-08 16:08:42 [-][-][-][info][yii\db\Command::query] SELECT *
FROM `info`
LIMIT 1
2018-09-08 16:08:42 [-][-][-][profile begin][yii\db\Command::query] SELECT *
FROM `info`
LIMIT 1
2018-09-08 16:08:42 [-][-][-][profile end][yii\db\Command::query] SELECT *
FROM `info`
LIMIT 1
2018-09-08 16:08:42 [-][-][-][trace][yii\base\Application::bootstrap] Bootstrap with craft\queue\Queue::bootstrap()
2018-09-08 16:08:42 [-][-][-][info][yii\db\Command::query] SELECT `id`, `handle`, `version`, `schemaVersion`, `licenseKey`, `licenseKeyStatus`, `settings`, `installDate`
FROM `plugins`
WHERE `enabled`=TRUE
2018-09-08 16:08:42 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `handle`, `version`, `schemaVersion`, `licenseKey`, `licenseKeyStatus`, `settings`, `installDate`
FROM `plugins`
WHERE `enabled`=TRUE
2018-09-08 16:08:42 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `handle`, `version`, `schemaVersion`, `licenseKey`, `licenseKeyStatus`, `settings`, `installDate`
FROM `plugins`
WHERE `enabled`=TRUE
2018-09-08 16:08:42 [-][-][-][info][nystudio107\cookies\Cookies::init] Cookies plugin loaded
2018-09-08 16:08:42 [-][-][-][info][martinherweg\craftgonzo\CraftGonzo::init] Craft Gonzo plugin loaded
2018-09-08 16:08:43 [-][-][-][info][nystudio107\minify\Minify::init] Minify plugin loaded
2018-09-08 16:08:43 [-][-][-][info][nystudio107\typogrify\Typogrify::init] Typogrify plugin loaded
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`
FROM `plugins`
WHERE `handle`='feed-me'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`
FROM `plugins`
WHERE `handle`='feed-me'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`
FROM `plugins`
WHERE `handle`='feed-me'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][trace][yii\base\Module::getModule] Loading module: sprout-base
2018-09-08 16:08:43 [-][-][-][trace][yii\base\Controller::runAction] Route to run: queue/exec
2018-09-08 16:08:43 [-][-][-][trace][yii\base\InlineAction::runWithParams] Running action: craft\queue\Command::actionExec()
2018-09-08 16:08:43 [-][-][-][info][craft\queue\QueueLogBehavior::beforeExec] [1] Importing Data. (attempt: 1) - Started
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `s`.`id`, `s`.`groupId`, `s`.`name`, `s`.`handle`, `language`, `s`.`primary`, `s`.`hasUrls`, `s`.`baseUrl`, `s`.`sortOrder`
FROM `sites` `s`
INNER JOIN `sitegroups` `sg` ON `sg`.`id` = `s`.`groupId`
ORDER BY `sg`.`name`, `s`.`sortOrder`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `s`.`id`, `s`.`groupId`, `s`.`name`, `s`.`handle`, `language`, `s`.`primary`, `s`.`hasUrls`, `s`.`baseUrl`, `s`.`sortOrder`
FROM `sites` `s`
INNER JOIN `sitegroups` `sg` ON `sg`.`id` = `s`.`groupId`
ORDER BY `sg`.`name`, `s`.`sortOrder`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `s`.`id`, `s`.`groupId`, `s`.`name`, `s`.`handle`, `language`, `s`.`primary`, `s`.`hasUrls`, `s`.`baseUrl`, `s`.`sortOrder`
FROM `sites` `s`
INNER JOIN `sitegroups` `sg` ON `sg`.`id` = `s`.`groupId`
ORDER BY `sg`.`name`, `s`.`sortOrder`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `type`
FROM `fieldlayouts`
WHERE `id`=66
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `type`
FROM `fieldlayouts`
WHERE `id`=66
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `type`
FROM `fieldlayouts`
WHERE `id`=66
LIMIT 1
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=66
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=66
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=66
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`
2018-09-08 16:08:43 [-][-][-][trace][yii\db\Transaction::begin] Begin transaction
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `elements`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM `elements`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM `elements`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements' AND kcu.table_name = 'elements'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements' AND kcu.table_name = 'elements'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements' AND kcu.table_name = 'elements'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements' AND kcu.table_name = 'elements'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements' AND kcu.table_name = 'elements'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements' AND kcu.table_name = 'elements'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::execute] INSERT INTO `elements` (`type`, `fieldLayoutId`, `enabled`, `archived`, `dateCreated`, `uid`, `dateUpdated`) VALUES ('craft\\commerce\\elements\\Order', 66, 1, 0, '2018-09-08 14:08:43', 'a1554773-1f9a-4a29-9ee8-aff9941a9c3d', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::execute] INSERT INTO `elements` (`type`, `fieldLayoutId`, `enabled`, `archived`, `dateCreated`, `uid`, `dateUpdated`) VALUES ('craft\\commerce\\elements\\Order', 66, 1, 0, '2018-09-08 14:08:43', 'a1554773-1f9a-4a29-9ee8-aff9941a9c3d', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::execute] INSERT INTO `elements` (`type`, `fieldLayoutId`, `enabled`, `archived`, `dateCreated`, `uid`, `dateUpdated`) VALUES ('craft\\commerce\\elements\\Order', 66, 1, 0, '2018-09-08 14:08:43', 'a1554773-1f9a-4a29-9ee8-aff9941a9c3d', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `elements_sites`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM `elements_sites`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM `elements_sites`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements_sites' AND kcu.table_name = 'elements_sites'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements_sites' AND kcu.table_name = 'elements_sites'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements_sites' AND kcu.table_name = 'elements_sites'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements_sites' AND kcu.table_name = 'elements_sites'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements_sites' AND kcu.table_name = 'elements_sites'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'elements_sites' AND kcu.table_name = 'elements_sites'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::execute] INSERT INTO `elements_sites` (`elementId`, `siteId`, `slug`, `uri`, `enabled`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 1, NULL, NULL, 1, '2018-09-08 14:08:43', '9f1cef09-4e2b-45a0-bdb8-dccd7da942d1', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::execute] INSERT INTO `elements_sites` (`elementId`, `siteId`, `slug`, `uri`, `enabled`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 1, NULL, NULL, 1, '2018-09-08 14:08:43', '9f1cef09-4e2b-45a0-bdb8-dccd7da942d1', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::execute] INSERT INTO `elements_sites` (`elementId`, `siteId`, `slug`, `uri`, `enabled`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 1, NULL, NULL, 1, '2018-09-08 14:08:43', '9f1cef09-4e2b-45a0-bdb8-dccd7da942d1', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `content`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM `content`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM `content`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'content' AND kcu.table_name = 'content'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'content' AND kcu.table_name = 'content'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'content' AND kcu.table_name = 'content'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'content' AND kcu.table_name = 'content'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'content' AND kcu.table_name = 'content'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'content' AND kcu.table_name = 'content'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::execute] INSERT INTO `content` (`elementId`, `siteId`, `dateCreated`, `dateUpdated`, `uid`) VALUES (10567, 1, '2018-09-08 14:08:43', '2018-09-08 14:08:43', '071b38e7-24ad-48f7-9d53-e20fe02ae214')
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::execute] INSERT INTO `content` (`elementId`, `siteId`, `dateCreated`, `dateUpdated`, `uid`) VALUES (10567, 1, '2018-09-08 14:08:43', '2018-09-08 14:08:43', '071b38e7-24ad-48f7-9d53-e20fe02ae214')
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::execute] INSERT INTO `content` (`elementId`, `siteId`, `dateCreated`, `dateUpdated`, `uid`) VALUES (10567, 1, '2018-09-08 14:08:43', '2018-09-08 14:08:43', '071b38e7-24ad-48f7-9d53-e20fe02ae214')
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `options`, `price`, `saleAmount`, `salePrice`, `weight`, `length`, `height`, `width`, `qty`, `snapshot`, `note`, `purchasableId`, `orderId`, `taxCategoryId`, `shippingCategoryId`
FROM `commerce_lineitems` `lineItems`
WHERE `orderId`=10567
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `options`, `price`, `saleAmount`, `salePrice`, `weight`, `length`, `height`, `width`, `qty`, `snapshot`, `note`, `purchasableId`, `orderId`, `taxCategoryId`, `shippingCategoryId`
FROM `commerce_lineitems` `lineItems`
WHERE `orderId`=10567
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `options`, `price`, `saleAmount`, `salePrice`, `weight`, `length`, `height`, `width`, `qty`, `snapshot`, `note`, `purchasableId`, `orderId`, `taxCategoryId`, `shippingCategoryId`
FROM `commerce_lineitems` `lineItems`
WHERE `orderId`=10567
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `name`, `handle`, `enabled`
FROM `commerce_shippingmethods`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `name`, `handle`, `enabled`
FROM `commerce_shippingmethods`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `name`, `handle`, `enabled`
FROM `commerce_shippingmethods`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `shippingZoneId`, `name`, `description`, `methodId`, `priority`, `enabled`, `minQty`, `maxQty`, `minTotal`, `maxTotal`, `minWeight`, `maxWeight`, `baseRate`, `perItemRate`, `weightRate`, `percentageRate`, `minRate`, `maxRate`
FROM `commerce_shippingrules`
WHERE `methodId`='2'
ORDER BY `priority`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `shippingZoneId`, `name`, `description`, `methodId`, `priority`, `enabled`, `minQty`, `maxQty`, `minTotal`, `maxTotal`, `minWeight`, `maxWeight`, `baseRate`, `perItemRate`, `weightRate`, `percentageRate`, `minRate`, `maxRate`
FROM `commerce_shippingrules`
WHERE `methodId`='2'
ORDER BY `priority`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `shippingZoneId`, `name`, `description`, `methodId`, `priority`, `enabled`, `minQty`, `maxQty`, `minTotal`, `maxTotal`, `minWeight`, `maxWeight`, `baseRate`, `perItemRate`, `weightRate`, `percentageRate`, `minRate`, `maxRate`
FROM `commerce_shippingrules`
WHERE `methodId`='2'
ORDER BY `priority`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=2
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=2
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=2
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=3
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=3
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=3
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=4
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=4
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=4
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `shippingZoneId`, `name`, `description`, `methodId`, `priority`, `enabled`, `minQty`, `maxQty`, `minTotal`, `maxTotal`, `minWeight`, `maxWeight`, `baseRate`, `perItemRate`, `weightRate`, `percentageRate`, `minRate`, `maxRate`
FROM `commerce_shippingrules`
WHERE `methodId`='3'
ORDER BY `priority`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `shippingZoneId`, `name`, `description`, `methodId`, `priority`, `enabled`, `minQty`, `maxQty`, `minTotal`, `maxTotal`, `minWeight`, `maxWeight`, `baseRate`, `perItemRate`, `weightRate`, `percentageRate`, `minRate`, `maxRate`
FROM `commerce_shippingrules`
WHERE `methodId`='3'
ORDER BY `priority`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `shippingZoneId`, `name`, `description`, `methodId`, `priority`, `enabled`, `minQty`, `maxQty`, `minTotal`, `maxTotal`, `minWeight`, `maxWeight`, `baseRate`, `perItemRate`, `weightRate`, `percentageRate`, `minRate`, `maxRate`
FROM `commerce_shippingrules`
WHERE `methodId`='3'
ORDER BY `priority`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=5
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=5
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `shippingRuleId`, `shippingCategoryId`, `condition`, `perItemRate`, `weightRate`, `percentageRate`
FROM `commerce_shippingrule_categories`
WHERE `shippingRuleId`=5
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `discounts`.`id`, `discounts`.`name`, `discounts`.`description`, `discounts`.`code`, `discounts`.`perUserLimit`, `discounts`.`perEmailLimit`, `discounts`.`totalUseLimit`, `discounts`.`totalUses`, `discounts`.`dateFrom`, `discounts`.`dateTo`, `discounts`.`purchaseTotal`, `discounts`.`purchaseQty`, `discounts`.`maxPurchaseQty`, `discounts`.`baseDiscount`, `discounts`.`perItemDiscount`, `discounts`.`percentDiscount`, `discounts`.`percentageOffSubject`, `discounts`.`excludeOnSale`, `discounts`.`freeShipping`, `discounts`.`allGroups`, `discounts`.`allPurchasables`, `discounts`.`allCategories`, `discounts`.`enabled`, `discounts`.`stopProcessing`, `discounts`.`sortOrder`, `discounts`.`dateCreated`, `discounts`.`dateUpdated`, `dp`.`purchasableId`, `dpt`.`categoryId`, `dug`.`userGroupId`
FROM `commerce_discounts` `discounts`
LEFT JOIN `commerce_discount_purchasables` `dp` ON `dp`.`discountId`=`discounts`.`id`
LEFT JOIN `commerce_discount_categories` `dpt` ON `dpt`.`discountId`=`discounts`.`id`
LEFT JOIN `commerce_discount_usergroups` `dug` ON `dug`.`discountId`=`discounts`.`id`
ORDER BY `sortOrder`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `discounts`.`id`, `discounts`.`name`, `discounts`.`description`, `discounts`.`code`, `discounts`.`perUserLimit`, `discounts`.`perEmailLimit`, `discounts`.`totalUseLimit`, `discounts`.`totalUses`, `discounts`.`dateFrom`, `discounts`.`dateTo`, `discounts`.`purchaseTotal`, `discounts`.`purchaseQty`, `discounts`.`maxPurchaseQty`, `discounts`.`baseDiscount`, `discounts`.`perItemDiscount`, `discounts`.`percentDiscount`, `discounts`.`percentageOffSubject`, `discounts`.`excludeOnSale`, `discounts`.`freeShipping`, `discounts`.`allGroups`, `discounts`.`allPurchasables`, `discounts`.`allCategories`, `discounts`.`enabled`, `discounts`.`stopProcessing`, `discounts`.`sortOrder`, `discounts`.`dateCreated`, `discounts`.`dateUpdated`, `dp`.`purchasableId`, `dpt`.`categoryId`, `dug`.`userGroupId`
FROM `commerce_discounts` `discounts`
LEFT JOIN `commerce_discount_purchasables` `dp` ON `dp`.`discountId`=`discounts`.`id`
LEFT JOIN `commerce_discount_categories` `dpt` ON `dpt`.`discountId`=`discounts`.`id`
LEFT JOIN `commerce_discount_usergroups` `dug` ON `dug`.`discountId`=`discounts`.`id`
ORDER BY `sortOrder`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `discounts`.`id`, `discounts`.`name`, `discounts`.`description`, `discounts`.`code`, `discounts`.`perUserLimit`, `discounts`.`perEmailLimit`, `discounts`.`totalUseLimit`, `discounts`.`totalUses`, `discounts`.`dateFrom`, `discounts`.`dateTo`, `discounts`.`purchaseTotal`, `discounts`.`purchaseQty`, `discounts`.`maxPurchaseQty`, `discounts`.`baseDiscount`, `discounts`.`perItemDiscount`, `discounts`.`percentDiscount`, `discounts`.`percentageOffSubject`, `discounts`.`excludeOnSale`, `discounts`.`freeShipping`, `discounts`.`allGroups`, `discounts`.`allPurchasables`, `discounts`.`allCategories`, `discounts`.`enabled`, `discounts`.`stopProcessing`, `discounts`.`sortOrder`, `discounts`.`dateCreated`, `discounts`.`dateUpdated`, `dp`.`purchasableId`, `dpt`.`categoryId`, `dug`.`userGroupId`
FROM `commerce_discounts` `discounts`
LEFT JOIN `commerce_discount_purchasables` `dp` ON `dp`.`discountId`=`discounts`.`id`
LEFT JOIN `commerce_discount_categories` `dpt` ON `dpt`.`discountId`=`discounts`.`id`
LEFT JOIN `commerce_discount_usergroups` `dug` ON `dug`.`discountId`=`discounts`.`id`
ORDER BY `sortOrder`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `taxZoneId`, `taxCategoryId`, `name`, `rate`, `include`, `isVat`, `taxable`
FROM `commerce_taxrates`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `taxZoneId`, `taxCategoryId`, `name`, `rate`, `include`, `isVat`, `taxable`
FROM `commerce_taxrates`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `taxZoneId`, `taxCategoryId`, `name`, `rate`, `include`, `isVat`, `taxable`
FROM `commerce_taxrates`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `name`, `description`, `isCountryBased`, `default`
FROM `commerce_taxzones`
WHERE `id`='1'
ORDER BY `name`
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `name`, `description`, `isCountryBased`, `default`
FROM `commerce_taxzones`
WHERE `id`='1'
ORDER BY `name`
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `name`, `description`, `isCountryBased`, `default`
FROM `commerce_taxzones`
WHERE `id`='1'
ORDER BY `name`
LIMIT 1
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `commerce_orders`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM `commerce_orders`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM `commerce_orders`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'commerce_orders' AND kcu.table_name = 'commerce_orders'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'commerce_orders' AND kcu.table_name = 'commerce_orders'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'commerce_orders' AND kcu.table_name = 'commerce_orders'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'commerce_orders' AND kcu.table_name = 'commerce_orders'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'commerce_orders' AND kcu.table_name = 'commerce_orders'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'commerce_orders' AND kcu.table_name = 'commerce_orders'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `iso`, `primary`, `rate`
FROM `commerce_paymentcurrencies`
ORDER BY `primary` DESC, `iso`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `iso`, `primary`, `rate`
FROM `commerce_paymentcurrencies`
ORDER BY `primary` DESC, `iso`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `iso`, `primary`, `rate`
FROM `commerce_paymentcurrencies`
ORDER BY `primary` DESC, `iso`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT `id`, `name`, `handle`, `fieldLayoutId`
FROM `commerce_ordersettings`
WHERE `handle`='order'
LIMIT 1
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type` IN ('purchase', 'capture'))
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT SUM(amount)
FROM `commerce_transactions`
WHERE (`orderId`=10567) AND (`status`='success') AND (`type`='refund')
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::execute] INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 'fcfb9fb3b6e700c85285cc1de018ce80', '0', '', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '0', NULL, NULL, NULL, 'CHF', NULL, NULL, NULL, NULL, 'unpaid', '2018-09-08 14:08:43', 'd32715a3-ba49-4c30-b7fa-4e93f5ed1fce', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::execute] INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 'fcfb9fb3b6e700c85285cc1de018ce80', '0', '', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '0', NULL, NULL, NULL, 'CHF', NULL, NULL, NULL, NULL, 'unpaid', '2018-09-08 14:08:43', 'd32715a3-ba49-4c30-b7fa-4e93f5ed1fce', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::execute] INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 'fcfb9fb3b6e700c85285cc1de018ce80', '0', '', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '0', NULL, NULL, NULL, 'CHF', NULL, NULL, NULL, NULL, 'unpaid', '2018-09-08 14:08:43', 'd32715a3-ba49-4c30-b7fa-4e93f5ed1fce', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][trace][yii\db\Transaction::rollBack] Roll back transaction
2018-09-08 16:08:43 [-][-][-][error][sprout-import] Unable to run Sprout Import job.
2018-09-08 16:08:43 [-][-][-][error][sprout-import] SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'orderLanguage' cannot be null
The SQL being executed was: INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 'fcfb9fb3b6e700c85285cc1de018ce80', '0', '', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '0', NULL, NULL, NULL, 'CHF', NULL, NULL, NULL, NULL, 'unpaid', '2018-09-08 14:08:43', 'd32715a3-ba49-4c30-b7fa-4e93f5ed1fce', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][error][craft\queue\QueueLogBehavior::afterError] [1] Importing Data. (attempt: 1) - Error (time: 0.236s): SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'orderLanguage' cannot be null
The SQL being executed was: INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 'fcfb9fb3b6e700c85285cc1de018ce80', '0', '', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '0', NULL, NULL, NULL, 'CHF', NULL, NULL, NULL, NULL, 'unpaid', '2018-09-08 14:08:43', 'd32715a3-ba49-4c30-b7fa-4e93f5ed1fce', '2018-09-08 14:08:43')
2018-09-08 16:08:43 [-][-][-][error][yii\db\IntegrityException] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'orderLanguage' cannot be null in /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/Command.php:1258
Stack trace:
#0 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/Command.php(1258): PDOStatement->execute()
#1 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/Command.php(1075): yii\db\Command->internalExecute('INSERT INTO `co...')
#2 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/Schema.php(433): yii\db\Command->execute()
#3 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/ActiveRecord.php(549): yii\db\Schema->insert('{{%commerce_ord...', Array)
#4 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/ActiveRecord.php(515): yii\db\ActiveRecord->insertInternal(NULL)
#5 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/BaseActiveRecord.php(670): yii\db\ActiveRecord->insert(false, NULL)
#6 /Users/hendrik/Documents/Github/Projects/wfw/vendor/craftcms/commerce/src/elements/Order.php(817): yii\db\BaseActiveRecord->save(false)
#7 /Users/hendrik/Documents/Github/Projects/wfw/vendor/craftcms/cms/src/services/Elements.php(490): craft\commerce\elements\Order->afterSave(true)
#8 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-import/src/importers/elements/Order.php(79): craft\services\Elements->saveElement(Object(craft\commerce\elements\Order), false)
#9 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-base/src/app/import/base/Importer.php(93): barrelstrength\sproutimport\importers\elements\Order->setModel(Object(craft\commerce\elements\Order), Array)
#10 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-base/src/app/import/services/Importers.php(268): barrelstrength\sproutbase\app\import\base\Importer->__construct(Array)
#11 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-base/src/app/import/services/Importers.php(300): barrelstrength\sproutbase\app\import\services\Importers->getImporter(Array)
#12 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-import/src/queue/jobs/Import.php(43): barrelstrength\sproutbase\app\import\services\Importers->save(Array, Object(barrelstrength\sproutimport\models\Weed))
#13 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2-queue/src/Queue.php(214): barrelstrength\sproutimport\queue\jobs\Import->execute(Object(craft\queue\Queue))
#14 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2-queue/src/cli/Queue.php(162): yii\queue\Queue->handleMessage('1', 'O:45:"barrelstr...', '300', '1')
#15 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2-queue/src/cli/Command.php(145): yii\queue\cli\Queue->execute('1', 'O:45:"barrelstr...', '300', '1', '')
#16 [internal function]: yii\queue\cli\Command->actionExec('1', '300', '1', '')
#17 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#18 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#19 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction('exec', Array)
#20 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction('exec', Array)
#21 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('queue/exec', Array)
#22 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('queue/exec', Array)
#23 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest(Object(craft\console\Request))
#24 /Users/hendrik/Documents/Github/Projects/wfw/craft(43): yii\base\Application->run()
#25 {main}
Next yii\db\IntegrityException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'orderLanguage' cannot be null
The SQL being executed was: INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, 'fcfb9fb3b6e700c85285cc1de018ce80', '0', '', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '0', NULL, NULL, NULL, 'CHF', NULL, NULL, NULL, NULL, 'unpaid', '2018-09-08 14:08:43', 'd32715a3-ba49-4c30-b7fa-4e93f5ed1fce', '2018-09-08 14:08:43') in /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/Schema.php:664
Stack trace:
#0 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/Command.php(1263): yii\db\Schema->convertException(Object(PDOException), 'INSERT INTO `co...')
#1 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/Command.php(1075): yii\db\Command->internalExecute('INSERT INTO `co...')
#2 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/Schema.php(433): yii\db\Command->execute()
#3 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/ActiveRecord.php(549): yii\db\Schema->insert('{{%commerce_ord...', Array)
#4 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/ActiveRecord.php(515): yii\db\ActiveRecord->insertInternal(NULL)
#5 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/db/BaseActiveRecord.php(670): yii\db\ActiveRecord->insert(false, NULL)
#6 /Users/hendrik/Documents/Github/Projects/wfw/vendor/craftcms/commerce/src/elements/Order.php(817): yii\db\BaseActiveRecord->save(false)
#7 /Users/hendrik/Documents/Github/Projects/wfw/vendor/craftcms/cms/src/services/Elements.php(490): craft\commerce\elements\Order->afterSave(true)
#8 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-import/src/importers/elements/Order.php(79): craft\services\Elements->saveElement(Object(craft\commerce\elements\Order), false)
#9 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-base/src/app/import/base/Importer.php(93): barrelstrength\sproutimport\importers\elements\Order->setModel(Object(craft\commerce\elements\Order), Array)
#10 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-base/src/app/import/services/Importers.php(268): barrelstrength\sproutbase\app\import\base\Importer->__construct(Array)
#11 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-base/src/app/import/services/Importers.php(300): barrelstrength\sproutbase\app\import\services\Importers->getImporter(Array)
#12 /Users/hendrik/Documents/Github/Projects/wfw/vendor/barrelstrength/sprout-import/src/queue/jobs/Import.php(43): barrelstrength\sproutbase\app\import\services\Importers->save(Array, Object(barrelstrength\sproutimport\models\Weed))
#13 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2-queue/src/Queue.php(214): barrelstrength\sproutimport\queue\jobs\Import->execute(Object(craft\queue\Queue))
#14 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2-queue/src/cli/Queue.php(162): yii\queue\Queue->handleMessage('1', 'O:45:"barrelstr...', '300', '1')
#15 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2-queue/src/cli/Command.php(145): yii\queue\cli\Queue->execute('1', 'O:45:"barrelstr...', '300', '1', '')
#16 [internal function]: yii\queue\cli\Command->actionExec('1', '300', '1', '')
#17 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#18 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#19 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction('exec', Array)
#20 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction('exec', Array)
#21 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('queue/exec', Array)
#22 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('queue/exec', Array)
#23 /Users/hendrik/Documents/Github/Projects/wfw/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest(Object(craft\console\Request))
#24 /Users/hendrik/Documents/Github/Projects/wfw/craft(43): yii\base\Application->run()
#25 {main}
Additional Information:
Array
(
[0] => 23000
[1] => 1048
[2] => Column 'orderLanguage' cannot be null
)
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `queue`
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM `queue`
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM `queue`
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'queue' AND kcu.table_name = 'queue'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'queue' AND kcu.table_name = 'queue'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'queue' AND kcu.table_name = 'queue'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'queue' AND kcu.table_name = 'queue'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'queue' AND kcu.table_name = 'queue'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::query] SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.referenced_column_name,
rc.UPDATE_RULE,
rc.DELETE_RULE
FROM information_schema.referential_constraints AS rc
JOIN information_schema.key_column_usage AS kcu ON
(
kcu.constraint_catalog = rc.constraint_catalog OR
(kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL)
) AND
kcu.constraint_schema = rc.constraint_schema AND
kcu.constraint_name = rc.constraint_name
WHERE rc.constraint_schema = database() AND kcu.table_schema = database()
AND rc.table_name = 'queue' AND kcu.table_name = 'queue'
2018-09-08 16:08:43 [-][-][-][info][yii\db\Command::execute] UPDATE `queue` SET `fail`=1, `dateFailed`='2018-09-08 14:08:43', `error`='SQLSTATE[23000]: Integrity constraint violation: 1048 Column \'orderLanguage\' cannot be null\nThe SQL being executed was: INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, \'fcfb9fb3b6e700c85285cc1de018ce80\', \'0\', \'\', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, \'0\', \'0\', NULL, NULL, NULL, \'CHF\', NULL, NULL, NULL, NULL, \'unpaid\', \'2018-09-08 14:08:43\', \'d32715a3-ba49-4c30-b7fa-4e93f5ed1fce\', \'2018-09-08 14:08:43\')' WHERE `id`='1'
2018-09-08 16:08:43 [-][-][-][profile begin][yii\db\Command::execute] UPDATE `queue` SET `fail`=1, `dateFailed`='2018-09-08 14:08:43', `error`='SQLSTATE[23000]: Integrity constraint violation: 1048 Column \'orderLanguage\' cannot be null\nThe SQL being executed was: INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, \'fcfb9fb3b6e700c85285cc1de018ce80\', \'0\', \'\', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, \'0\', \'0\', NULL, NULL, NULL, \'CHF\', NULL, NULL, NULL, NULL, \'unpaid\', \'2018-09-08 14:08:43\', \'d32715a3-ba49-4c30-b7fa-4e93f5ed1fce\', \'2018-09-08 14:08:43\')' WHERE `id`='1'
2018-09-08 16:08:43 [-][-][-][profile end][yii\db\Command::execute] UPDATE `queue` SET `fail`=1, `dateFailed`='2018-09-08 14:08:43', `error`='SQLSTATE[23000]: Integrity constraint violation: 1048 Column \'orderLanguage\' cannot be null\nThe SQL being executed was: INSERT INTO `commerce_orders` (`id`, `number`, `itemTotal`, `email`, `isCompleted`, `dateOrdered`, `datePaid`, `shippingMethodHandle`, `paymentSourceId`, `gatewayId`, `orderStatusId`, `couponCode`, `totalPrice`, `totalPaid`, `currency`, `lastIp`, `orderLanguage`, `paymentCurrency`, `customerId`, `returnUrl`, `cancelUrl`, `message`, `paidStatus`, `dateCreated`, `uid`, `dateUpdated`) VALUES (10567, \'fcfb9fb3b6e700c85285cc1de018ce80\', \'0\', \'\', 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, \'0\', \'0\', NULL, NULL, NULL, \'CHF\', NULL, NULL, NULL, NULL, \'unpaid\', \'2018-09-08 14:08:43\', \'d32715a3-ba49-4c30-b7fa-4e93f5ed1fce\', \'2018-09-08 14:08:43\')' WHERE `id`='1'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment