Created
September 8, 2018 14:11
-
-
Save hendrikeng/67503b30b9b3e6e5faac40c6b4d984c1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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