search

webdna / commerce-admin-orders

Create a new commerce order from the admin
Other
9 stars 1 forks source link

`error: Undefined variable: cart` when adding products #15

Closed dwhoban closed 4 years ago

dwhoban commented 4 years ago

Using the latest version I am getting a 500 error when trying to add a item to the cart:

action: commerce-admin-orders/orders/add-to-cart
response: 500
error: Undefined variable: cart

This prevents the cart from completing and is not returning a full CraftCMS error.

mcjackson18 commented 4 years ago

@dwhoban which version of Craft Commerce are you using? There was an issue similar to this bug which was fixed in Commerce 2.1.12.

dwhoban commented 4 years ago 
craftcms/aws-s3": "^1.2.5",
    "craftcms/cms": "3.3.4.1",
    "craftcms/commerce": "2.1.13",
    "craftcms/commerce-stripe": "2.1.2",
    "craftcms/feed-me": "^4.1.2",
    "craftcms/mailgun": "^1.4.2",
    "craftcms/redactor": "^2.3.3.2",
    "ether/simplemap": "3.6.4.3",
    "fruitstudios/validateit": "^1.0.3",
    "hashtagerrors/user-initials-photo": "^1.1.1",
    "kuriousagency/commerce-admin-orders": "2.5.1",
    "lukeyouell/craft-sentry": "^1.5.1",
    "mediabeastnz/craft-commerce-xero": "^0.9.1",
    "nystudio107/craft-cookies": "^1.1.11",
    "nystudio107/craft-imageoptimize": "^1.6.1",
    "nystudio107/craft-minify": "^1.2.9",
    "nystudio107/craft-retour": "^3.1.22",
    "nystudio107/craft-scripts": "^1.2",
    "nystudio107/craft-seomatic": "3.2.25",
    "nystudio107/craft-similar": "^1.0.6",
    "nystudio107/craft-twigpack": "^1.1.8",
    "olivierbon/craft-concierge": "^2.1.0",
    "ostark/craft-async-queue": "^2.0.0",
    "rias/craft-contact-form-extensions": "^1.1.7",
    "rias/craft-position-fieldtype": "^1.0.14",
    "sebastianlenz/linkfield": "^1.0.19",
    "superbig/craft-entry-instructions": "^1.0.5",
    "topshelfcraft/wordsmith": "3.1.1",
    "vaersaagod/dospaces": "^1.1.2",
    "verbb/navigation": "dev-craft-3",
    "verbb/postie": "^2.0.8",
    "verbb/super-table": "^2.2.1",
    "vlucas/phpdotenv": "^2.4.0",
    "yiisoft/yii2-redis": "^2.0"
senpuukyakuu commented 4 years ago

I'm getting an error when completing an order. It returns an unknown error and no more craft info.

Uncaught TypeError: Cannot read property 'success' of null at CommerceOrderEdit.js?v=1568299505:83 at Object.complete (Craft.js:385) at n (jquery.js:3291) at Object.fireWith (jquery.js:3421) at l (jquery.js:9538) at XMLHttpRequest. (jquery.js:9775) /index.php?p=admin/actions/commerce/orders/complete-order:1 Failed to load resource: the server responded with a status of 500 (Internal Server Error) CommerceOrderEdit.js?v=1568299505:83 Uncaught TypeError: Cannot read property 'success' of null at CommerceOrderEdit.js?v=1568299505:83 at Object.complete (Craft.js:385) at n (jquery.js:3291) at Object.fireWith (jquery.js:3421) at l (jquery.js:9538) at XMLHttpRequest. (jquery.js:9775) jquery.js:9827 POST http://youngvoicesdev.test/index.php?p=admin/actions/commerce/orders/complete-order 500 (Internal Server Error) send @ jquery.js:9827 ajax @ jquery.js:9424 postActionRequest @ Craft.js:363 _markOrderCompleted @ CommerceOrderEdit.js?v=1568299505:82 (anonymous) @ CommerceOrderEdit.js?v=1568299505:36 i @ jquery.js:10492 (anonymous) @ garnish.js:893 i @ jquery.js:10492 dispatch @ jquery.js:5233 v.handle @ jquery.js:5040 CommerceOrderEdit.js?v=1568299505:83 Uncaught TypeError: Cannot read property 'success' of null at CommerceOrderEdit.js?v=1568299505:83 at Object.complete (Craft.js:385) at n (jquery.js:3291) at Object.fireWith (jquery.js:3421) at l (jquery.js:9538) at XMLHttpRequest. (jquery.js:9775) (anonymous) @ CommerceOrderEdit.js?v=1568299505:83 complete @ Craft.js:385 n @ jquery.js:3291 fireWith @ jquery.js:3421 l @ jquery.js:9538 (anonymous) @ jquery.js:9775 load (async) send @ jquery.js:9794 ajax @ jquery.js:9424 postActionRequest @ Craft.js:363 _markOrderCompleted @ CommerceOrderEdit.js?v=1568299505:82 (anonymous) @ CommerceOrderEdit.js?v=1568299505:36 i @ jquery.js:10492 (anonymous) @ garnish.js:893 i @ jquery.js:10492 dispatch @ jquery.js:5233 v.handle @ jquery.js:5040 jquery.js:9827 POST http://youngvoicesdev.test/index.php?p=admin/actions/commerce/orders/complete-order 500 (Internal Server Error) send @ jquery.js:9827 ajax @ jquery.js:9424 postActionRequest @ Craft.js:363 _markOrderCompleted @ CommerceOrderEdit.js?v=1568299505:82 (anonymous) @ CommerceOrderEdit.js?v=1568299505:36 i @ jquery.js:10492 (anonymous) @ garnish.js:893 i @ jquery.js:10492 dispatch @ jquery.js:5233 v.handle @ jquery.js:5040 CommerceOrderEdit.js?v=1568299505:83 Uncaught TypeError: Cannot read property 'success' of null at CommerceOrderEdit.js?v=1568299505:83 at Object.complete (Craft.js:385) at n (jquery.js:3291) at Object.fireWith (jquery.js:3421) at l (jquery.js:9538) at XMLHttpRequest. (jquery.js:9775)

samuelbirch commented 4 years ago

@dwhoban Latest version: 2.5.2 should fix your issue.

@senpuukyakuu I think the issue you are having is actually a Commerce bug rather than admin-orders. It looks like you're trying to complete an order by the "complete order" button instead of completing it by making a payment. I've created a PR with Commerce to fix this issue: https://github.com/craftcms/commerce/pull/1017

senpuukyakuu commented 4 years ago

Still having the same issue, tried the fix for commerce. Now it returns a proper error message, but still doesn't save the order. Any ideas? Thanks, D,

El mar., 24 sept. 2019 a las 13:49, Samuel Birch (notifications@github.com) escribió:

@dwhoban https://github.com/dwhoban Latest version: 2.5.2 should fix your issue.

@senpuukyakuu https://github.com/senpuukyakuu I think the issue you are having is actually a Commerce bug rather than admin-orders. It looks like you're trying to complete an order by the "complete order" button instead of completing it by making a payment. I've created a PR with Commerce to fix this issue: craftcms/commerce#1017 https://github.com/craftcms/commerce/pull/1017

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/KuriousAgency/commerce-admin-orders/issues/15?email_source=notifications&email_token=ACYXFUV47VXYD3IGQCXWQ7TQLH5FZA5CNFSM4IZHS2EKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD7OCS7A#issuecomment-534522236, or mute the thread https://github.com/notifications/unsubscribe-auth/ACYXFUVSTC5BXXNM74RPTLDQLH5FZANCNFSM4IZHS2EA .

samuelbirch commented 4 years ago

@senpuukyakuu what is the error message it is now returning? - and is there anything in the logs?

senpuukyakuu commented 4 years ago

It keeps returning some 500 errors on the console. ñFailed to load resource: the server responded with a status of 500 (Internal Server Error) CommerceOrderEdit.js?v=1568299505:83 Uncaught TypeError: Cannot read property 'success' of null at CommerceOrderEdit.js?v=1568299505:83 at Object.complete (Craft.js:385) at n (jquery.js:3291) at Object.fireWith (jquery.js:3421) at l (jquery.js:9538) at XMLHttpRequest. (jquery.js:9775)

2019-09-24 16:44:44 [-][1][-][error][yii\base\ErrorException:8] yii\base\ErrorException: Trying to get property 'handle' of non-object in /Applications/MAMP/youngvoices_testing/custom_plugins/globalpayments/src/Plugin.php:87 Stack trace:

0 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/ErrorHandler.php(80):

yii\base\ErrorHandler->handleError(8, 'Trying to get p...', '/Applications/M...', 87)

1 /Applications/MAMP/youngvoices_testing/custom_plugins/globalpayments/src/Plugin.php(87):

craft\web\ErrorHandler->handleError(8, 'Trying to get p...', '/Applications/M...', 87, Array)

2 [internal function]:

takefourtytwo\globalpayments\Plugin->takefourtytwo\globalpayments{closure}(Object(yii\base\Event))

3 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Event.php(312):

call_user_func(Object(Closure), Object(yii\base\Event))

4 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Component.php(636):

yii\base\Event::trigger('craft\commerce\...', 'beforeCompleteO...', Object(yii\base\Event))

5 /Applications/MAMP/youngvoices_testing/vendor/craftcms/commerce/src/elements/Order.php(702):

yii\base\Component->trigger('beforeCompleteO...')

6 /Applications/MAMP/youngvoices_testing/vendor/craftcms/commerce/src/controllers/OrdersController.php(329):

craft\commerce\elements\Order->markAsComplete()

7 [internal function]:

craft\commerce\controllers\OrdersController->actionCompleteOrder()

8 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/InlineAction.php(57):

call_user_func_array(Array, Array)

9 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Controller.php(157):

yii\base\InlineAction->runWithParams(Array)

10 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/Controller.php(187):

yii\base\Controller->runAction('complete-order', Array)

11 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Module.php(528):

craft\web\Controller->runAction('complete-order', Array)

12 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/Application.php(299):

yii\base\Module->runAction('commerce/orders...', Array)

13 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/Application.php(566):

craft\web\Application->runAction('commerce/orders...', Array)

14 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/Application.php(278):

craft\web\Application->_processActionRequest(Object(craft\web\Request))

15 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Application.php(386):

craft\web\Application->handleRequest(Object(craft\web\Request))

16 /Applications/MAMP/youngvoices_testing/web/index.php(21):

yii\base\Application->run()

17 {main}

2019-09-24 16:44:44 [-][1][-][info][application] $_GET = [ 'p' => 'admin/actions/commerce/orders/complete-order' ]

$_POST = [ 'orderId' => '1747' ]

$_FILES = []

$_COOKIE = [ '1031b8c41dfff97a311a7ac99863bdc5_username' => '1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca:2:{i:0;s:41:\"1031b8c41dfff97a311a7ac99863bdc5_username\";i:1;s:23:\"daniel@takefortytwo.com\";}' 'intercom-id-whxs6x8o' => 'a48b4315-9f07-49c2-83e2-992f335181da' '__stripe_mid' => '9e2da3ad-1859-4c40-be86-fba13eaeaec5' 'CraftSessionId' => 'uabfr5g10oa8jfr5ln8jutdktj' '1031b8c41dfff97a311a7ac99863bdc5_identity' => 'cbcf078fa28e4797b5243b9ce2f237ea3453bbeb3b347c02d0241d9fe5151796a:2:{i:0;s:41:\"1031b8c41dfff97a311a7ac99863bdc5_identity\";i:1;s:250:\"[\"1\",\"[\\"Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88\\",null,\\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36\\"]\",3600]\";}' 'CRAFT_CSRF_TOKEN' => '•••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' ]

$_SESSION = [ 'bd62416aa8538ede709019a5e113eea5flash' => [] '1031b8c41dfff97a311a7ac99863bdc5token' => '••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' '1031b8c41dfff97a311a7ac99863bdc5id' => '1' '1031b8c41dfff97a311a7ac99863bdc5expire' => 1569347084 'commerce_customer' => '1' ]

$_SERVER = [ 'HTTP_HOST' => 'youngvoicesdev.test' 'HTTP_CONNECTION' => 'keep-alive' 'CONTENT_LENGTH' => '12' 'HTTP_ORIGIN' => 'http://youngvoicesdev.test' 'HTTP_X_CSRF_TOKEN' => '••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' 'HTTP_X_REGISTERED_ASSET_BUNDLES' => ',wbrowar\guide\assetbundles\Guide\GuideAsset,craft\web\assets\cp\CpAsset,craft\web\assets\d3\D3Asset,craft\web\assets\elementresizedetector\ElementResizeDetectorAsset,craft\web\assets\garnish\GarnishAsset,yii\web\JqueryAsset,craft\web\assets\jquerytouchevents\JqueryTouchEventsAsset,craft\web\assets\velocity\VelocityAsset,craft\web\assets\jqueryui\JqueryUiAsset,craft\web\assets\jquerypayment\JqueryPaymentAsset,craft\web\assets\datepickeri18n\DatepickerI18nAsset,craft\web\assets\picturefill\PicturefillAsset,craft\web\assets\selectize\SelectizeAsset,craft\web\assets\fileupload\FileUploadAsset,craft\web\assets\xregexp\XregexpAsset,craft\web\assets\fabric\FabricAsset,craftconditions\conditions\assets\ConditionsAssets,verbb\iconpicker\assetbundles\IconPickerCacheAsset,craft\commerce\web\assets\commercecp\CommerceCpAsset,kuriousagency\commerce\adminorders\assetbundles\neworder\NewOrder,craft\web\assets\prismjs\PrismJsAsset' 'CONTENT_TYPE' => 'application/x-www-form-urlencoded; charset=UTF-8' 'HTTP_X_REGISTERED_JS_FILES' => ',http://youngvoicesdev.test/cpresources/fb0f4b04/d3.js?v=1568293184,http://youngvoicesdev.test/cpresources/5690fc27/element-resize-detector.js?v=1568293184,http://youngvoicesdev.test/cpresources/790057d2/jquery.js?v=1568293184,http://youngvoicesdev.test/cpresources/f20e5797/jquery.mobile-events.min.js?v=1568293184,http://youngvoicesdev.test/cpresources/688fa0af/velocity.js?v=1568293184,http://youngvoicesdev.test/cpresources/c8b25c82/garnish.js?v=1568293184,http://youngvoicesdev.test/cpresources/26263b0a/jquery-ui.min.js?v=1568293184,http://youngvoicesdev.test/cpresources/74a80f47/jquery.payment.js?v=1568293184,http://youngvoicesdev.test/cpresources/f5aa6b55/picturefill.js?v=1568293184,http://youngvoicesdev.test/cpresources/a1d446d1/selectize.js?v=1568293184,http://youngvoicesdev.test/cpresources/ed426aab/jquery.fileupload.js?v=1568293184,http://youngvoicesdev.test/cpresources/abb8025b/xregexp-all.js?v=1568293184,http://youngvoicesdev.test/cpresources/ddf488bc/fabric.js?v=1568293184,http://youngvoicesdev.test/cpresources/1d8b9d35/js/Craft.min.js?v=1568293184,http://youngvoicesdev.test/cpresources/20678e55/js/guide.2.0.0.js?v=1567973901,http://youngvoicesdev.test/cpresources/41eb5a47/javascripts/conditions-atest3dc3r.js?v=1567973907,http://youngvoicesdev.test/cpresources/577762fa/js/icon-picker-cache.js?v=1567973901,http://youngvoicesdev.test/cpresources/654ed717/js/Commerce.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceAddressBox.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceEditAddressModal.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceOrderEdit.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceOrderIndex.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceOrderTableView.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommercePaymentModal.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceShippingItemRatesValuesInput.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceSubscriptionIndex.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceUpdateOrderStatusModal.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceVariantValuesInput.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/TableRowAdditionalInfoIcon.js?v=1568299505,http://youngvoicesdev.test/cpresources/64ccf56c/js/Modal.js?v=1569337229,http://youngvoicesdev.test/cpresources/64ccf56c/js/Edit.js?v=1569337229,http://youngvoicesdev.test/cpresources/f0885d1e/prism.js?v=1568299833' 'HTTP_ACCEPT' => 'application/json, text/javascript, /; q=0.01' 'HTTP_X_REQUESTED_WITH' => 'XMLHttpRequest' 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36' 'HTTP_REFERER' => 'http://youngvoicesdev.test/admin/commerce/orders/1747' 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate' 'HTTP_ACCEPT_LANGUAGE' => 'es-ES,es;q=0.9,en-US;q=0.8,en;q=0.7' 'HTTP_COOKIE' => '1031b8c41dfff97a311a7ac99863bdc5_username=1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca%3A2%3A%7Bi%3A0%3Bs%3A41%3A%221031b8c41dfff97a311a7ac99863bdc5_username%22%3Bi%3A1%3Bs%3A23%3A%22daniel%40takefortytwo.com%22%3B%7D; intercom-id-whxs6x8o=a48b4315-9f07-49c2-83e2-992f335181da; __stripe_mid=9e2da3ad-1859-4c40-be86-fba13eaeaec5; CraftSessionId=uabfr5g10oa8jfr5ln8jutdktj; 1031b8c41dfff97a311a7ac99863bdc5_identity=cbcf078fa28e4797b5243b9ce2f237ea3453bbeb3b347c02d0241d9fe5151796a%3A2%3A%7Bi%3A0%3Bs%3A41%3A%221031b8c41dfff97a311a7ac99863bdc5_identity%22%3Bi%3A1%3Bs%3A250%3A%22%5B%221%22%2C%22%5B%5C%22Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88%5C%22%2Cnull%2C%5C%22Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_6%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F76.0.3809.132+Safari%2F537.36%5C%22%5D%22%2C3600%5D%22%3B%7D; CRAFT_CSRF_TOKEN=f4b60c9cf93cb18ec7d202b9c78af83d4e7cd923b9d48db279976f727a163522a%3A2%3A%7Bi%3A0%3Bs%3A16%3A%22CRAFT_CSRF_TOKEN%22%3Bi%3A1%3Bs%3A208%3A%223kEVOeORATAJpOoOvANcz3qX0tl6430f5NXVgy2j%7C796d40196e67ef88029c2d0708048d778cf78bd440f4606cdd8e19f10c0254773kEVOeORATAJpOoOvANcz3qX0tl6430f5NXVgy2j%7C1%7C%242y%2413%24kB1MijxNcE3GG.faj5QO5efBk4LWfvOIGxirKWXApWHRLpFJB1cQG%22%3B%7D' 'PATH' => '/usr/bin:/bin:/usr/sbin:/sbin' 'SERVER_SIGNATURE' => '' 'SERVER_SOFTWARE' => 'Apache' 'SERVER_NAME' => 'youngvoicesdev.test' 'SERVER_ADDR' => '::1' 'SERVER_PORT' => '80' 'REMOTE_ADDR' => '::1' 'DOCUMENT_ROOT' => '/Applications/MAMP/youngvoices_testing/web' 'SERVER_ADMIN' => 'you@example.com' 'SCRIPT_FILENAME' => '/Applications/MAMP/youngvoices_testing/web/index.php' 'REMOTE_PORT' => '59043' 'GATEWAY_INTERFACE' => 'CGI/1.1' 'SERVER_PROTOCOL' => 'HTTP/1.1' 'REQUEST_METHOD' => 'POST' 'QUERY_STRING' => 'p=admin/actions/commerce/orders/complete-order' 'REQUEST_URI' => '/index.php?p=admin/actions/commerce/orders/complete-order' 'SCRIPT_NAME' => '/index.php' 'PHP_SELF' => '/index.php' 'REQUEST_TIME_FLOAT' => 1569343484.623 'REQUEST_TIME' => 1569343484 'argv' => [ 0 => 'p=admin/actions/commerce/orders/complete-order' ] 'argc' => 1 'ENVIRONMENT' => 'dev' 'SECURITY_KEY' => '••••••••••••••••••••••••••••••••' 'DB_DRIVER' => 'mysql' 'DB_SERVER' => 'localhost' 'DB_USER' => 'root' 'DB_PASSWORD' => '••••' 'DB_DATABASE' => 'youngvoi_2019' 'DB_SCHEMA' => 'public' 'DB_TABLE_PREFIX' => '' 'DB_PORT' => '3306' 'BASE_CP_URL' => 'http://youngvoicesdev.test' 'BACKUP_COMMAND' => '/Applications/MAMP/Library/bin/mysqldump -h localhost -u root -proot --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --set-charset --triggers --single-transaction --no-data --result-file=\"{file}\" {database} && /Applications/MAMP/Library/bin/mysqldump -h localhost -u root -proot --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --set-charset --triggers --no-create-info --ignore-table={database}.assetindexdata --ignore-table={database}.assettransformindex --ignore-table={database}.cache --ignore-table={database}.sessions --ignore-table={database}.templatecaches --ignore-table={database}.templatecachecriteria --ignore-table={database}.templatecacheelements {database} >> \"{file}\"' 'RESTORE_COMMAND' => '/Applications/MAMP/Library/bin/mysql -h localhost -u root -proot {database} < \"{file}\"' ] 2019-09-24 16:44:46 [-][1][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=youngvoi_2019;port=3306; 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=youngvoi_2019;port=3306; 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=youngvoi_2019;port=3306; 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SHOW TABLES 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SHOW TABLES 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SHOW TABLES 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT s.id, s.groupId, s.name, s.handle, language, s.primary, s.hasUrls, s.baseUrl, s.sortOrder, s.uid, s.dateCreated, s.dateUpdated FROM sites s INNER JOIN sitegroups sg ON sg.id = s.groupId WHERE (s.dateDeleted IS NULL) AND (sg.dateDeleted IS NULL) ORDER BY sg.name, s.sortOrder 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT s.id, s.groupId, s.name, s.handle, language, s.primary, s.hasUrls, s.baseUrl, s.sortOrder, s.uid, s.dateCreated, s.dateUpdated FROM sites s INNER JOIN sitegroups sg ON sg.id = s.groupId WHERE (s.dateDeleted IS NULL) AND (sg.dateDeleted IS NULL) ORDER BY sg.name, s.sortOrder 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT s.id, s.groupId, s.name, s.handle, language, s.primary, s.hasUrls, s.baseUrl, s.sortOrder, s.uid, s.dateCreated, s.dateUpdated FROM sites s INNER JOIN sitegroups sg ON sg.id = s.groupId WHERE (s.dateDeleted IS NULL) AND (sg.dateDeleted IS NULL) ORDER BY sg.name, s.sortOrder 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT FROM info LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT FROM info LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT * FROM info LIMIT 1 2019-09-24 16:44:46 [-][1][-][info][yii\web\Session::open] Session started 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT preferences FROM userpreferences WHERE userId=1 LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT preferences FROM userpreferences WHERE userId=1 LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT preferences FROM userpreferences WHERE userId=1 LIMIT 1 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM seomatic_metabundles 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM seomatic_metabundles 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM seomatic_metabundles 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][info][nystudio107\seomatic\Seomatic::init] SEOmatic plugin loaded 2019-09-24 16:44:46 [-][1][-][info][hestabit\craftajaxinate\CraftAjaxinate::init] Craft Ajaxinate plugin loaded 2019-09-24 16:44:46 [-][1][-][info][unionco\craftsyncdb\SyncDbPlugin::init] SyncDb plugin loaded 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT id FROM sessions WHERE (token='Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88') AND (userId='1') LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT id FROM sessions WHERE (token='Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88') AND (userId='1') LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT id FROM sessions WHERE (token='Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88') AND (userId='1') LIMIT 1 2019-09-24 16:44:46 [-][1][-][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, fields.uid, fields.searchable FROM fields fields ORDER BY fields.name, fields.handle 2019-09-24 16:44:46 [-][1][-][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, fields.uid, fields.searchable FROM fields fields ORDER BY fields.name, fields.handle 2019-09-24 16:44:46 [-][1][-][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, fields.uid, fields.searchable FROM fields fields ORDER BY fields.name, fields.handle 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT users.password, elements.id, elements.fieldLayoutId, elements.uid, elements.enabled, elements.archived, elements.dateCreated, elements.dateUpdated, elements_sites.slug, elements_sites.siteId, elements_sites.enabled AS enabledForSite, elements_sites.uri, users.username, users.firstName, users.lastName, users.email, users.admin, users.locked, users.pending, users.suspended, users.lastLoginDate, users.lockoutDate, users.photoId, users.hasDashboard, content.id AS contentId, content.field_additionToFooter, content.field_additionToHead, content.field_altText, content.field_attribution, content.field_callToAction, content.field_caption, content.field_confirmedChoirNumbers, content.field_copy, content.field_description, content.field_embed, content.field_freeformForm, content.field_headline, content.field_highlight, content.field_icon, content.field_isPrivate, content.field_marketing, content.field_myNumber, content.field_phone, content.field_pricebookId, content.field_productFamily, content.field_registrationId, content.field_salesforce_id, content.field_seo, content.field_thirdParty, content.field_transactional, content.field_usr_type, content.field_userGroup, content.field_video, content.field_xeroAccountCode FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM elements elements INNER JOIN users users ON users.id = elements.id INNER JOIN elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN content content ON (content.elementId = elements.id) AND (content.siteId = elements_sites.siteId) WHERE (elements_sites.siteId='1') AND (elements.id='1') AND (elements.archived=FALSE) AND (elements.dateDeleted IS NULL) AND (elements.draftId IS NULL) AND (elements.revisionId IS NULL) ORDER BY users.username LIMIT 1) subquery INNER JOIN users users ON users.id = subquery.elementsId INNER JOIN elements elements ON elements.id = subquery.elementsId INNER JOIN elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN content content ON content.id = subquery.contentId ORDER BY users.username 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT users.password, elements.id, elements.fieldLayoutId, elements.uid, elements.enabled, elements.archived, elements.dateCreated, elements.dateUpdated, elements_sites.slug, elements_sites.siteId, elements_sites.enabled AS enabledForSite, elements_sites.uri, users.username, users.firstName, users.lastName, users.email, users.admin, users.locked, users.pending, users.suspended, users.lastLoginDate, users.lockoutDate, users.photoId, users.hasDashboard, content.id AS contentId, content.field_additionToFooter, content.field_additionToHead, content.field_altText, content.field_attribution, content.field_callToAction, content.field_caption, content.field_confirmedChoirNumbers, content.field_copy, content.field_description, content.field_embed, content.field_freeformForm, content.field_headline, content.field_highlight, content.field_icon, content.field_isPrivate, content.field_marketing, content.field_myNumber, content.field_phone, content.field_pricebookId, content.field_productFamily, content.field_registrationId, content.field_salesforce_id, content.field_seo, content.field_thirdParty, content.field_transactional, content.field_usr_type, content.field_userGroup, content.field_video, content.field_xeroAccountCode FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM elements elements INNER JOIN users users ON users.id = elements.id INNER JOIN elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN content content ON (content.elementId = elements.id) AND (content.siteId = elements_sites.siteId) WHERE (elements_sites.siteId='1') AND (elements.id='1') AND (elements.archived=FALSE) AND (elements.dateDeleted IS NULL) AND (elements.draftId IS NULL) AND (elements.revisionId IS NULL) ORDER BY users.username LIMIT 1) subquery INNER JOIN users users ON users.id = subquery.elementsId INNER JOIN elements elements ON elements.id = subquery.elementsId INNER JOIN elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN content content ON content.id = subquery.contentId ORDER BY users.username 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT users.password, elements.id, elements.fieldLayoutId, elements.uid, elements.enabled, elements.archived, elements.dateCreated, elements.dateUpdated, elements_sites.slug, elements_sites.siteId, elements_sites.enabled AS enabledForSite, elements_sites.uri, users.username, users.firstName, users.lastName, users.email, users.admin, users.locked, users.pending, users.suspended, users.lastLoginDate, users.lockoutDate, users.photoId, users.hasDashboard, content.id AS contentId, content.field_additionToFooter, content.field_additionToHead, content.field_altText, content.field_attribution, content.field_callToAction, content.field_caption, content.field_confirmedChoirNumbers, content.field_copy, content.field_description, content.field_embed, content.field_freeformForm, content.field_headline, content.field_highlight, content.field_icon, content.field_isPrivate, content.field_marketing, content.field_myNumber, content.field_phone, content.field_pricebookId, content.field_productFamily, content.field_registrationId, content.field_salesforce_id, content.field_seo, content.field_thirdParty, content.field_transactional, content.field_usr_type, content.field_userGroup, content.field_video, content.field_xeroAccountCode FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM elements elements INNER JOIN users users ON users.id = elements.id INNER JOIN elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN content content ON (content.elementId = elements.id) AND (content.siteId = elements_sites.siteId) WHERE (elements_sites.siteId='1') AND (elements.id='1') AND (elements.archived=FALSE) AND (elements.dateDeleted IS NULL) AND (elements.draftId IS NULL) AND (elements.revisionId IS NULL) ORDER BY users.username LIMIT 1) subquery INNER JOIN users users ON users.id = subquery.elementsId INNER JOIN elements elements ON elements.id = subquery.elementsId INNER JOIN elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN content content ON content.id = subquery.contentId ORDER BY users.username 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM resourcepaths 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM resourcepaths 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM resourcepaths 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, CASE WHEN NULL IS NULL AND kcu.REFERENCED_TABLE_SCHEMA = DATABASE() THEN NULL ELSE kcu.REFERENCED_TABLE_SCHEMA END AS foreign_table_schema, kcu.REFERENCED_TABLE_NAME AS foreign_table_name, kcu.REFERENCED_COLUMN_NAME AS foreign_column_name, rc.UPDATE_RULE AS on_update, rc.DELETE_RULE AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.REFERENTIAL_CONSTRAINTS AS rc, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND kcu.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND rc.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE = 'FOREIGN KEY' UNION SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, NULL AS foreign_table_schema, NULL AS foreign_table_name, NULL AS foreign_column_name, NULL AS on_update, NULL AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.TABLE_NAME = 'resourcepaths' AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY position ASC 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, CASE WHEN NULL IS NULL AND kcu.REFERENCED_TABLE_SCHEMA = DATABASE() THEN NULL ELSE kcu.REFERENCED_TABLE_SCHEMA END AS foreign_table_schema, kcu.REFERENCED_TABLE_NAME AS foreign_table_name, kcu.REFERENCED_COLUMN_NAME AS foreign_column_name, rc.UPDATE_RULE AS on_update, rc.DELETE_RULE AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.REFERENTIAL_CONSTRAINTS AS rc, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND kcu.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND rc.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE = 'FOREIGN KEY' UNION SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, NULL AS foreign_table_schema, NULL AS foreign_table_name, NULL AS foreign_column_name, NULL AS on_update, NULL AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.TABLE_NAME = 'resourcepaths' AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY position ASC 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, CASE WHEN NULL IS NULL AND kcu.REFERENCED_TABLE_SCHEMA = DATABASE() THEN NULL ELSE kcu.REFERENCED_TABLE_SCHEMA END AS foreign_table_schema, kcu.REFERENCED_TABLE_NAME AS foreign_table_name, kcu.REFERENCED_COLUMN_NAME AS foreign_column_name, rc.UPDATE_RULE AS on_update, rc.DELETE_RULE AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.REFERENTIAL_CONSTRAINTS AS rc, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND kcu.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND rc.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE = 'FOREIGN KEY' UNION SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, NULL AS foreign_table_schema, NULL AS foreign_table_name, NULL AS foreign_column_name, NULL AS on_update, NULL AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.TABLE_NAME = 'resourcepaths' AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY position ASC 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT s.INDEX_NAME AS name, s.COLUMN_NAME AS column_name, s.NON_UNIQUE ^ 1 AS index_is_unique, s.INDEX_NAME = 'PRIMARY' AS index_is_primary FROM information_schema.STATISTICS AS s WHERE s.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND s.INDEX_SCHEMA = s.TABLE_SCHEMA AND s.TABLE_NAME = 'resourcepaths' ORDER BY s.SEQ_IN_INDEX ASC 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT s.INDEX_NAME AS name, s.COLUMN_NAME AS column_name, s.NON_UNIQUE ^ 1 AS index_is_unique, s.INDEX_NAME = 'PRIMARY' AS index_is_primary FROM information_schema.STATISTICS AS s WHERE s.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND s.INDEX_SCHEMA = s.TABLE_SCHEMA AND s.TABLE_NAME = 'resourcepaths' ORDER BY s.SEQ_IN_INDEX ASC 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT s.INDEX_NAME AS name, s.COLUMN_NAME AS column_name, s.NON_UNIQUE ^ 1 AS index_is_unique, s.INDEX_NAME = 'PRIMARY' AS index_is_primary FROM information_schema.STATISTICS AS s WHERE s.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND s.INDEX_SCHEMA = s.TABLE_SCHEMA AND s.TABLE_NAME = 'resourcepaths' ORDER BY s.SEQ_IN_INDEX ASC 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@wbrowar/guide/assetbundles/guide/dist', '20678e55') ON DUPLICATE KEY UPDATE path='@wbrowar/guide/assetbundles/guide/dist' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@wbrowar/guide/assetbundles/guide/dist', '20678e55') ON DUPLICATE KEY UPDATE path='@wbrowar/guide/assetbundles/guide/dist' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@wbrowar/guide/assetbundles/guide/dist', '20678e55') ON DUPLICATE KEY UPDATE path='@wbrowar/guide/assetbundles/guide/dist' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@app/web/assets/cp/dist', '1d8b9d35') ON DUPLICATE KEY UPDATE path='@app/web/assets/cp/dist' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@app/web/assets/cp/dist', '1d8b9d35') ON DUPLICATE KEY UPDATE path='@app/web/assets/cp/dist' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@app/web/assets/cp/dist', '1d8b9d35') ON DUPLICATE KEY UPDATE path='@app/web/assets/cp/dist' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/d3', 'fb0f4b04') ON DUPLICATE KEY UPDATE path='@lib/d3' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/d3', 'fb0f4b04') ON DUPLICATE KEY UPDATE path='@lib/d3' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/d3', 'fb0f4b04') ON DUPLICATE KEY UPDATE path='@lib/d3' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/element-resize-detector', '5690fc27') ON DUPLICATE KEY UPDATE path='@lib/element-resize-detector' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/element-resize-detector', '5690fc27') ON DUPLICATE KEY UPDATE path='@lib/element-resize-detector' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/element-resize-detector', '5690fc27') ON DUPLICATE KEY UPDATE path='@lib/element-resize-detector' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/garnishjs', 'c8b25c82') ON DUPLICATE KEY UPDATE path='@lib/garnishjs' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/garnishjs', 'c8b25c82') ON DUPLICATE KEY UPDATE path='@lib/garnishjs' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/garnishjs', 'c8b25c82') ON DUPLICATE KEY UPDATE path='@lib/garnishjs' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@bower/jquery/dist', '790057d2') ON DUPLICATE KEY UPDATE path='@bower/jquery/dist' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@bower/jquery/dist', '790057d2') ON DUPLICATE KEY UPDATE path='@bower/jquery/dist' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@bower/jquery/dist', '790057d2') ON DUPLICATE KEY UPDATE path='@bower/jquery/dist' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-touch-events', 'f20e5797') ON DUPLICATE KEY UPDATE path='@lib/jquery-touch-events' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-touch-events', 'f20e5797') ON DUPLICATE KEY UPDATE path='@lib/jquery-touch-events' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-touch-events', 'f20e5797') ON DUPLICATE KEY UPDATE path='@lib/jquery-touch-events' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/velocity', '688fa0af') ON DUPLICATE KEY UPDATE path='@lib/velocity' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/velocity', '688fa0af') ON DUPLICATE KEY UPDATE path='@lib/velocity' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/velocity', '688fa0af') ON DUPLICATE KEY UPDATE path='@lib/velocity' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-ui', '26263b0a') ON DUPLICATE KEY UPDATE path='@lib/jquery-ui' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-ui', '26263b0a') ON DUPLICATE KEY UPDATE path='@lib/jquery-ui' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-ui', '26263b0a') ON DUPLICATE KEY UPDATE path='@lib/jquery-ui' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery.payment', '74a80f47') ON DUPLICATE KEY UPDATE path='@lib/jquery.payment' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery.payment', '74a80f47') ON DUPLICATE KEY UPDATE path='@lib/jquery.payment' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery.payment', '74a80f47') ON DUPLICATE KEY UPDATE path='@lib/jquery.payment' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/picturefill', 'f5aa6b55') ON DUPLICATE KEY UPDATE path='@lib/picturefill' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/picturefill', 'f5aa6b55') ON DUPLICATE KEY UPDATE path='@lib/picturefill' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/picturefill', 'f5aa6b55') ON DUPLICATE KEY UPDATE path='@lib/picturefill' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/selectize', 'a1d446d1') ON DUPLICATE KEY UPDATE path='@lib/selectize' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/selectize', 'a1d446d1') ON DUPLICATE KEY UPDATE path='@lib/selectize' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/selectize', 'a1d446d1') ON DUPLICATE KEY UPDATE path='@lib/selectize' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fileupload', 'ed426aab') ON DUPLICATE KEY UPDATE path='@lib/fileupload' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fileupload', 'ed426aab') ON DUPLICATE KEY UPDATE path='@lib/fileupload' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fileupload', 'ed426aab') ON DUPLICATE KEY UPDATE path='@lib/fileupload' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/xregexp', 'abb8025b') ON DUPLICATE KEY UPDATE path='@lib/xregexp' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/xregexp', 'abb8025b') ON DUPLICATE KEY UPDATE path='@lib/xregexp' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/xregexp', 'abb8025b') ON DUPLICATE KEY UPDATE path='@lib/xregexp' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fabric', 'ddf488bc') ON DUPLICATE KEY UPDATE path='@lib/fabric' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fabric', 'ddf488bc') ON DUPLICATE KEY UPDATE path='@lib/fabric' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fabric', 'ddf488bc') ON DUPLICATE KEY UPDATE path='@lib/fabric' 2019-09-24 16:44:46 [-][1][-][info][wbrowar\guide\Guide::init] Guide plugin loaded 2019-09-24 16:44:46 [-][1][-][info][chasegiunta\scss\Scss::init] SCSS plugin loaded 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT EXISTS(SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins WHERE handle='fieldlabels') 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT EXISTS(SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins WHERE handle='fieldlabels') 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT EXISTS(SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins WHERE handle='fieldlabels') 2019-09-24 16:44:46 [-][1][-][info][craftconditions\conditions\Conditions::init] Conditions plugin loaded 2019-09-24 16:44:46 [-][1][-][info][kuriousagency\commerce\adminorders\AdminOrders::init] Commerce Admin Orders plugin loaded 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@verbb/iconpicker/resources/dist', '577762fa') ON DUPLICATE KEY UPDATE path='@verbb/iconpicker/resources/dist' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@verbb/iconpicker/resources/dist', '577762fa') ON DUPLICATE KEY UPDATE path='@verbb/iconpicker/resources/dist' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@verbb/iconpicker/resources/dist', '577762fa') ON DUPLICATE KEY UPDATE path='@verbb/iconpicker/resources/dist' 2019-09-24 16:44:46 [-][1][-][info][wideweb\plugindev\PluginDev::init] Plugin Dev plugin loaded 2019-09-24 16:44:46 [-][1][-][trace][craft\web\Application::_processActionRequest] Route requested: 'users/get-remaining-session-time' 2019-09-24 16:44:46 [-][1][-][trace][yii\base\Controller::runAction] Route to run: users/get-remaining-session-time 2019-09-24 16:44:46 [-][1][-][trace][yii\base\InlineAction::runWithParams] Running action: craft\controllers\UsersController::actionGetRemainingSessionTime() 2019-09-24 16:44:46 [-][1][-][info][application] $_GET = [ 'p' => 'admin/actions/users/get-remaining-session-time' 'dontExtendSession' => '1' ]

$_POST = []

$_FILES = []

$_COOKIE = [ '1031b8c41dfff97a311a7ac99863bdc5_username' => '1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca:2:{i:0;s:41:\"1031b8c41dfff97a311a7ac99863bdc5_username\";i:1;s:23:\"daniel@takefortytwo.com\";}' 'intercom-id-whxs6x8o' => 'a48b4315-9f07-49c2-83e2-992f335181da' '__stripe_mid' => '9e2da3ad-1859-4c40-be86-fba13eaeaec5' 'CraftSessionId' => 'uabfr5g10oa8jfr5ln8jutdktj' '1031b8c41dfff97a311a7ac99863bdc5_identity' => 'cbcf078fa28e4797b5243b9ce2f237ea3453bbeb3b347c02d0241d9fe5151796a:2:{i:0;s:41:\"1031b8c41dfff97a311a7ac99863bdc5_identity\";i:1;s:250:\"[\"1\",\"[\\"Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88\\",null,\\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36\\"]\",3600]\";}' 'CRAFT_CSRF_TOKEN' => '•••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' ]

$_SESSION = [ 'bd62416aa8538ede709019a5e113eea5flash' => [] '1031b8c41dfff97a311a7ac99863bdc5token' => '••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' '1031b8c41dfff97a311a7ac99863bdc5id' => '1' '1031b8c41dfff97a311a7ac99863bdc5expire' => 1569347084 'commerce_customer' => '1' ]

$_SERVER = [ 'HTTP_HOST' => 'youngvoicesdev.test' 'HTTP_CONNECTION' => 'keep-alive' 'HTTP_ACCEPT' => 'application/json, text/javascript, /; q=0.01' 'HTTP_X_REQUESTED_WITH' => 'XMLHttpRequest' 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36' 'HTTP_REFERER' => 'http://youngvoicesdev.test/admin/commerce/orders' 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate' 'HTTP_ACCEPT_LANGUAGE' => 'es-ES,es;q=0.9,en-US;q=0.8,en;q=0.7' 'HTTP_COOKIE' => '1031b8c41dfff97a311a7ac99863bdc5_username=1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca%3A2%3A%7Bi%3A0%3Bs%3A41%3A%221031b8c41dfff97a311a7ac99863bdc5_username%22%3Bi%3A1%3Bs%3A23%3A%22daniel%40takefortytwo.com%22%3B%7D; intercom-id-whxs6x8o=a48b4315-9f07-49c2-83e2-992f335181da; __stripe_mid=9e2da3ad-1859-4c40-be86-fba13eaeaec5; CraftSessionId=uabfr5g10oa8jfr5ln8jutdktj; 1031b8c41dfff97a311a7ac99863bdc5_identity=cbcf078fa28e4797b5243b9ce2f237ea3453bbeb3b347c02d0241d9fe5151796a%3A2%3A%7Bi%3A0%3Bs%3A41%3A%221031b8c41dfff97a311a7ac99863bdc5_identity%22%3Bi%3A1%3Bs%3A250%3A%22%5B%221%22%2C%22%5B%5C%22Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88%5C%22%2Cnull%2C%5C%22Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_6%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F76.0.3809.132+Safari%2F537.36%5C%22%5D%22%2C3600%5D%22%3B%7D; CRAFT_CSRF_TOKEN=f4b60c9cf93cb18ec7d202b9c78af83d4e7cd923b9d48db279976f727a163522a%3A2%3A%7Bi%3A0%3Bs%3A16%3A%22CRAFT_CSRF_TOKEN%22%3Bi%3A1%3Bs%3A208%3A%223kEVOeORATAJpOoOvANcz3qX0tl6430f5NXVgy2j%7C796d40196e67ef88029c2d0708048d778cf78bd440f4606cdd8e19f10c0254773kEVOeORATAJpOoOvANcz3qX0tl6430f5NXVgy2j%7C1%7C%242y%2413%24kB1MijxNcE3GG.faj5QO5efBk4LWfvOIGxirKWXApWHRLpFJB1cQG%22%3B%7D' 'PATH' => '/usr/bin:/bin:/usr/sbin:/sbin' 'SERVER_SIGNATURE' => '' 'SERVER_SOFTWARE' => 'Apache' 'SERVER_NAME' => 'youngvoicesdev.test' 'SERVER_ADDR' => '::1' 'SERVER_PORT' => '80' 'REMOTE_ADDR' => '::1' 'DOCUMENT_ROOT' => '/Applications/MAMP/youngvoices_testing/web' 'SERVER_ADMIN' => 'you@example.com' 'SCRIPT_FILENAME' => '/Applications/MAMP/youngvoices_testing/web/index.php' 'REMOTE_PORT' => '59046' 'GATEWAY_INTERFACE' => 'CGI/1.1' 'SERVER_PROTOCOL' => 'HTTP/1.1' 'REQUEST_METHOD' => 'GET' 'QUERY_STRING' => 'p=admin/actions/users/get-remaining-session-time&dontExtendSession=1' 'REQUEST_URI' => '/index.php?p=admin/actions/users/get-remaining-session-time&dontExtendSession=1' 'SCRIPT_NAME' => '/index.php' 'PHP_SELF' => '/index.php' 'REQUEST_TIME_FLOAT' => 1569343486.22 'REQUEST_TIME' => 1569343486 'argv' => [ 0 => 'p=admin/actions/users/get-remaining-session-time&dontExtendSession=1' ] 'argc' => 1 'ENVIRONMENT' => 'dev' 'SECURITY_KEY' => '••••••••••••••••••••••••••••••••' 'DB_DRIVER' => 'mysql' 'DB_SERVER' => 'localhost' 'DB_USER' => 'root' 'DB_PASSWORD' => '••••' 'DB_DATABASE' => 'youngvoi_2019' 'DB_SCHEMA' => 'public' 'DB_TABLE_PREFIX' => ''

El mar., 24 sept. 2019 a las 17:55, Samuel Birch (notifications@github.com) escribió:

Reopened #15 https://github.com/KuriousAgency/commerce-admin-orders/issues/15.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/KuriousAgency/commerce-admin-orders/issues/15?email_source=notifications&email_token=ACYXFUVD67V5SBGZ44G5BDDQLIZ7BA5CNFSM4IZHS2EKYY3PNVWWK3TUL52HS4DFWZEXG43VMVCXMZLOORHG65DJMZUWGYLUNFXW5KTDN5WW2ZLOORPWSZGOTZ3W56Y#event-2658627323, or mute the thread https://github.com/notifications/unsubscribe-auth/ACYXFUUZ2TNMAFFN5UAD3LTQLIZ7BANCNFSM4IZHS2EA .

senpuukyakuu commented 4 years ago

Sorry to keep shooting issues your way, now I'm getting:

products:1 Failed to load resource: the server responded with a status of 500 (Internal Server Error)

D,

El mar., 24 sept. 2019 a las 18:46, Daniel Rico (senpuukyakuu@gmail.com) escribió:

It keeps returning some 500 errors on the console. ñFailed to load resource: the server responded with a status of 500 (Internal Server Error) CommerceOrderEdit.js?v=1568299505:83 Uncaught TypeError: Cannot read property 'success' of null at CommerceOrderEdit.js?v=1568299505:83 at Object.complete (Craft.js:385) at n (jquery.js:3291) at Object.fireWith (jquery.js:3421) at l (jquery.js:9538) at XMLHttpRequest. (jquery.js:9775)

2019-09-24 16:44:44 [-][1][-][error][yii\base\ErrorException:8] yii\base\ErrorException: Trying to get property 'handle' of non-object in /Applications/MAMP/youngvoices_testing/custom_plugins/globalpayments/src/Plugin.php:87 Stack trace:

0 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/ErrorHandler.php(80): yii\base\ErrorHandler->handleError(8, 'Trying to get p...', '/Applications/M...', 87)

1 /Applications/MAMP/youngvoices_testing/custom_plugins/globalpayments/src/Plugin.php(87): craft\web\ErrorHandler->handleError(8, 'Trying to get p...', '/Applications/M...', 87, Array)

2 [internal function]: takefourtytwo\globalpayments\Plugin->takefourtytwo\globalpayments{closure}(Object(yii\base\Event))

3 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Event.php(312): call_user_func(Object(Closure), Object(yii\base\Event))

4 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Component.php(636): yii\base\Event::trigger('craft\commerce\...', 'beforeCompleteO...', Object(yii\base\Event))

5 /Applications/MAMP/youngvoices_testing/vendor/craftcms/commerce/src/elements/Order.php(702): yii\base\Component->trigger('beforeCompleteO...')

6 /Applications/MAMP/youngvoices_testing/vendor/craftcms/commerce/src/controllers/OrdersController.php(329): craft\commerce\elements\Order->markAsComplete()

7 [internal function]: craft\commerce\controllers\OrdersController->actionCompleteOrder()

8 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)

9 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)

10 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/Controller.php(187): yii\base\Controller->runAction('complete-order', Array)

11 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('complete-order', Array)

12 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/Application.php(299): yii\base\Module->runAction('commerce/orders...', Array)

13 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/Application.php(566): craft\web\Application->runAction('commerce/orders...', Array)

14 /Applications/MAMP/youngvoices_testing/vendor/craftcms/cms/src/web/Application.php(278): craft\web\Application->_processActionRequest(Object(craft\web\Request))

15 /Applications/MAMP/youngvoices_testing/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))

16 /Applications/MAMP/youngvoices_testing/web/index.php(21): yii\base\Application->run()

17 {main}

2019-09-24 16:44:44 [-][1][-][info][application] $_GET = [ 'p' => 'admin/actions/commerce/orders/complete-order' ]

$_POST = [ 'orderId' => '1747' ]

$_FILES = []

$_COOKIE = [ '1031b8c41dfff97a311a7ac99863bdc5_username' => '1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca:2:{i:0;s:41:\"1031b8c41dfff97a311a7ac99863bdc5_username\";i:1;s:23:\"daniel@takefortytwo.com\";}' 'intercom-id-whxs6x8o' => 'a48b4315-9f07-49c2-83e2-992f335181da' '__stripe_mid' => '9e2da3ad-1859-4c40-be86-fba13eaeaec5' 'CraftSessionId' => 'uabfr5g10oa8jfr5ln8jutdktj' '1031b8c41dfff97a311a7ac99863bdc5_identity' => 'cbcf078fa28e4797b5243b9ce2f237ea3453bbeb3b347c02d0241d9fe5151796a:2:{i:0;s:41:\"1031b8c41dfff97a311a7ac99863bdc5_identity\";i:1;s:250:\"[\"1\",\"[\\"Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88\\",null,\\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36\\"]\",3600]\";}' 'CRAFT_CSRF_TOKEN' => '•••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' ]

$_SESSION = [ 'bd62416aa8538ede709019a5e113eea5flash' => [] '1031b8c41dfff97a311a7ac99863bdc5token' => '••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' '1031b8c41dfff97a311a7ac99863bdc5id' => '1' '1031b8c41dfff97a311a7ac99863bdc5expire' => 1569347084 'commerce_customer' => '1' ]

$_SERVER = [ 'HTTP_HOST' => 'youngvoicesdev.test' 'HTTP_CONNECTION' => 'keep-alive' 'CONTENT_LENGTH' => '12' 'HTTP_ORIGIN' => 'http://youngvoicesdev.test' 'HTTP_X_CSRF_TOKEN' => '••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' 'HTTP_X_REGISTERED_ASSET_BUNDLES' => ',wbrowar\guide\assetbundles\Guide\GuideAsset,craft\web\assets\cp\CpAsset,craft\web\assets\d3\D3Asset,craft\web\assets\elementresizedetector\ElementResizeDetectorAsset,craft\web\assets\garnish\GarnishAsset,yii\web\JqueryAsset,craft\web\assets\jquerytouchevents\JqueryTouchEventsAsset,craft\web\assets\velocity\VelocityAsset,craft\web\assets\jqueryui\JqueryUiAsset,craft\web\assets\jquerypayment\JqueryPaymentAsset,craft\web\assets\datepickeri18n\DatepickerI18nAsset,craft\web\assets\picturefill\PicturefillAsset,craft\web\assets\selectize\SelectizeAsset,craft\web\assets\fileupload\FileUploadAsset,craft\web\assets\xregexp\XregexpAsset,craft\web\assets\fabric\FabricAsset,craftconditions\conditions\assets\ConditionsAssets,verbb\iconpicker\assetbundles\IconPickerCacheAsset,craft\commerce\web\assets\commercecp\CommerceCpAsset,kuriousagency\commerce\adminorders\assetbundles\neworder\NewOrder,craft\web\assets\prismjs\PrismJsAsset' 'CONTENT_TYPE' => 'application/x-www-form-urlencoded; charset=UTF-8' 'HTTP_X_REGISTERED_JS_FILES' => ',http://youngvoicesdev.test/cpresources/fb0f4b04/d3.js?v=1568293184,http://youngvoicesdev.test/cpresources/5690fc27/element-resize-detector.js?v=1568293184,http://youngvoicesdev.test/cpresources/790057d2/jquery.js?v=1568293184,http://youngvoicesdev.test/cpresources/f20e5797/jquery.mobile-events.min.js?v=1568293184,http://youngvoicesdev.test/cpresources/688fa0af/velocity.js?v=1568293184,http://youngvoicesdev.test/cpresources/c8b25c82/garnish.js?v=1568293184,http://youngvoicesdev.test/cpresources/26263b0a/jquery-ui.min.js?v=1568293184,http://youngvoicesdev.test/cpresources/74a80f47/jquery.payment.js?v=1568293184,http://youngvoicesdev.test/cpresources/f5aa6b55/picturefill.js?v=1568293184,http://youngvoicesdev.test/cpresources/a1d446d1/selectize.js?v=1568293184,http://youngvoicesdev.test/cpresources/ed426aab/jquery.fileupload.js?v=1568293184,http://youngvoicesdev.test/cpresources/abb8025b/xregexp-all.js?v=1568293184,http://youngvoicesdev.test/cpresources/ddf488bc/fabric.js?v=1568293184,http://youngvoicesdev.test/cpresources/1d8b9d35/js/Craft.min.js?v=1568293184,http://youngvoicesdev.test/cpresources/20678e55/js/guide.2.0.0.js?v=1567973901,http://youngvoicesdev.test/cpresources/41eb5a47/javascripts/conditions-atest3dc3r.js?v=1567973907,http://youngvoicesdev.test/cpresources/577762fa/js/icon-picker-cache.js?v=1567973901,http://youngvoicesdev.test/cpresources/654ed717/js/Commerce.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceAddressBox.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceEditAddressModal.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceOrderEdit.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceOrderIndex.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceOrderTableView.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommercePaymentModal.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceShippingItemRatesValuesInput.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceSubscriptionIndex.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceUpdateOrderStatusModal.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/CommerceVariantValuesInput.js?v=1568299505,http://youngvoicesdev.test/cpresources/654ed717/js/TableRowAdditionalInfoIcon.js?v=1568299505,http://youngvoicesdev.test/cpresources/64ccf56c/js/Modal.js?v=1569337229,http://youngvoicesdev.test/cpresources/64ccf56c/js/Edit.js?v=1569337229,http://youngvoicesdev.test/cpresources/f0885d1e/prism.js?v=1568299833' 'HTTP_ACCEPT' => 'application/json, text/javascript, /; q=0.01' 'HTTP_X_REQUESTED_WITH' => 'XMLHttpRequest' 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36' 'HTTP_REFERER' => 'http://youngvoicesdev.test/admin/commerce/orders/1747' 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate' 'HTTP_ACCEPT_LANGUAGE' => 'es-ES,es;q=0.9,en-US;q=0.8,en;q=0.7' 'HTTP_COOKIE' => '1031b8c41dfff97a311a7ac99863bdc5_username=1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca%3A2%3A%7Bi%3A0%3Bs%3A41%3A%221031b8c41dfff97a311a7ac99863bdc5_username%22%3Bi%3A1%3Bs%3A23%3A%22daniel%40takefortytwo.com%22%3B%7D; intercom-id-whxs6x8o=a48b4315-9f07-49c2-83e2-992f335181da; __stripe_mid=9e2da3ad-1859-4c40-be86-fba13eaeaec5; CraftSessionId=uabfr5g10oa8jfr5ln8jutdktj; 1031b8c41dfff97a311a7ac99863bdc5_identity=cbcf078fa28e4797b5243b9ce2f237ea3453bbeb3b347c02d0241d9fe5151796a%3A2%3A%7Bi%3A0%3Bs%3A41%3A%221031b8c41dfff97a311a7ac99863bdc5_identity%22%3Bi%3A1%3Bs%3A250%3A%22%5B%221%22%2C%22%5B%5C%22Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88%5C%22%2Cnull%2C%5C%22Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_6%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F76.0.3809.132+Safari%2F537.36%5C%22%5D%22%2C3600%5D%22%3B%7D; CRAFT_CSRF_TOKEN=f4b60c9cf93cb18ec7d202b9c78af83d4e7cd923b9d48db279976f727a163522a%3A2%3A%7Bi%3A0%3Bs%3A16%3A%22CRAFT_CSRF_TOKEN%22%3Bi%3A1%3Bs%3A208%3A%223kEVOeORATAJpOoOvANcz3qX0tl6430f5NXVgy2j%7C796d40196e67ef88029c2d0708048d778cf78bd440f4606cdd8e19f10c0254773kEVOeORATAJpOoOvANcz3qX0tl6430f5NXVgy2j%7C1%7C%242y%2413%24kB1MijxNcE3GG.faj5QO5efBk4LWfvOIGxirKWXApWHRLpFJB1cQG%22%3B%7D' 'PATH' => '/usr/bin:/bin:/usr/sbin:/sbin' 'SERVER_SIGNATURE' => '' 'SERVER_SOFTWARE' => 'Apache' 'SERVER_NAME' => 'youngvoicesdev.test' 'SERVER_ADDR' => '::1' 'SERVER_PORT' => '80' 'REMOTE_ADDR' => '::1' 'DOCUMENT_ROOT' => '/Applications/MAMP/youngvoices_testing/web' 'SERVER_ADMIN' => 'you@example.com' 'SCRIPT_FILENAME' => '/Applications/MAMP/youngvoices_testing/web/index.php' 'REMOTE_PORT' => '59043' 'GATEWAY_INTERFACE' => 'CGI/1.1' 'SERVER_PROTOCOL' => 'HTTP/1.1' 'REQUEST_METHOD' => 'POST' 'QUERY_STRING' => 'p=admin/actions/commerce/orders/complete-order' 'REQUEST_URI' => '/index.php?p=admin/actions/commerce/orders/complete-order' 'SCRIPT_NAME' => '/index.php' 'PHP_SELF' => '/index.php' 'REQUEST_TIME_FLOAT' => 1569343484.623 'REQUEST_TIME' => 1569343484 'argv' => [ 0 => 'p=admin/actions/commerce/orders/complete-order' ] 'argc' => 1 'ENVIRONMENT' => 'dev' 'SECURITY_KEY' => '••••••••••••••••••••••••••••••••' 'DB_DRIVER' => 'mysql' 'DB_SERVER' => 'localhost' 'DB_USER' => 'root' 'DB_PASSWORD' => '••••' 'DB_DATABASE' => 'youngvoi_2019' 'DB_SCHEMA' => 'public' 'DB_TABLE_PREFIX' => '' 'DB_PORT' => '3306' 'BASE_CP_URL' => 'http://youngvoicesdev.test' 'BACKUP_COMMAND' => '/Applications/MAMP/Library/bin/mysqldump -h localhost -u root -proot --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --set-charset --triggers --single-transaction --no-data --result-file=\"{file}\" {database} && /Applications/MAMP/Library/bin/mysqldump -h localhost -u root -proot --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --set-charset --triggers --no-create-info --ignore-table={database}.assetindexdata --ignore-table={database}.assettransformindex --ignore-table={database}.cache --ignore-table={database}.sessions --ignore-table={database}.templatecaches --ignore-table={database}.templatecachecriteria --ignore-table={database}.templatecacheelements {database} >> \"{file}\"' 'RESTORE_COMMAND' => '/Applications/MAMP/Library/bin/mysql -h localhost -u root -proot {database} < \"{file}\"' ] 2019-09-24 16:44:46 [-][1][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=youngvoi_2019;port=3306; 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=youngvoi_2019;port=3306; 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=youngvoi_2019;port=3306; 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SHOW TABLES 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SHOW TABLES 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SHOW TABLES 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT s.id, s.groupId, s.name, s.handle, language, s.primary, s.hasUrls, s.baseUrl, s.sortOrder, s.uid, s.dateCreated, s.dateUpdated FROM sites s INNER JOIN sitegroups sg ON sg.id = s.groupId WHERE (s.dateDeleted IS NULL) AND (sg.dateDeleted IS NULL) ORDER BY sg.name, s.sortOrder 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT s.id, s.groupId, s.name, s.handle, language, s.primary, s.hasUrls, s.baseUrl, s.sortOrder, s.uid, s.dateCreated, s.dateUpdated FROM sites s INNER JOIN sitegroups sg ON sg.id = s.groupId WHERE (s.dateDeleted IS NULL) AND (sg.dateDeleted IS NULL) ORDER BY sg.name, s.sortOrder 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT s.id, s.groupId, s.name, s.handle, language, s.primary, s.hasUrls, s.baseUrl, s.sortOrder, s.uid, s.dateCreated, s.dateUpdated FROM sites s INNER JOIN sitegroups sg ON sg.id = s.groupId WHERE (s.dateDeleted IS NULL) AND (sg.dateDeleted IS NULL) ORDER BY sg.name, s.sortOrder 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT FROM info LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT FROM info LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT * FROM info LIMIT 1 2019-09-24 16:44:46 [-][1][-][info][yii\web\Session::open] Session started 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT preferences FROM userpreferences WHERE userId=1 LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT preferences FROM userpreferences WHERE userId=1 LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT preferences FROM userpreferences WHERE userId=1 LIMIT 1 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM seomatic_metabundles 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM seomatic_metabundles 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM seomatic_metabundles 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][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 = 'seomatic_metabundles' AND kcu.table_name = 'seomatic_metabundles' 2019-09-24 16:44:46 [-][1][-][info][nystudio107\seomatic\Seomatic::init] SEOmatic plugin loaded 2019-09-24 16:44:46 [-][1][-][info][hestabit\craftajaxinate\CraftAjaxinate::init] Craft Ajaxinate plugin loaded 2019-09-24 16:44:46 [-][1][-][info][unionco\craftsyncdb\SyncDbPlugin::init] SyncDb plugin loaded 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT id FROM sessions WHERE (token='Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88') AND (userId='1') LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT id FROM sessions WHERE (token='Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88') AND (userId='1') LIMIT 1 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT id FROM sessions WHERE (token='Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88') AND (userId='1') LIMIT 1 2019-09-24 16:44:46 [-][1][-][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, fields.uid, fields.searchable FROM fields fields ORDER BY fields.name, fields.handle 2019-09-24 16:44:46 [-][1][-][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, fields.uid, fields.searchable FROM fields fields ORDER BY fields.name, fields.handle 2019-09-24 16:44:46 [-][1][-][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, fields.uid, fields.searchable FROM fields fields ORDER BY fields.name, fields.handle 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT users.password, elements.id, elements.fieldLayoutId, elements.uid, elements.enabled, elements.archived, elements.dateCreated, elements.dateUpdated, elements_sites.slug, elements_sites.siteId, elements_sites.enabled AS enabledForSite, elements_sites.uri, users.username, users.firstName, users.lastName, users.email, users.admin, users.locked, users.pending, users.suspended, users.lastLoginDate, users.lockoutDate, users.photoId, users.hasDashboard, content.id AS contentId, content.field_additionToFooter, content.field_additionToHead, content.field_altText, content.field_attribution, content.field_callToAction, content.field_caption, content.field_confirmedChoirNumbers, content.field_copy, content.field_description, content.field_embed, content.field_freeformForm, content.field_headline, content.field_highlight, content.field_icon, content.field_isPrivate, content.field_marketing, content.field_myNumber, content.field_phone, content.field_pricebookId, content.field_productFamily, content.field_registrationId, content.field_salesforce_id, content.field_seo, content.field_thirdParty, content.field_transactional, content.field_usr_type, content.field_userGroup, content.field_video, content.field_xeroAccountCode FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM elements elements INNER JOIN users users ON users.id = elements.id INNER JOIN elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN content content ON (content.elementId = elements.id) AND (content.siteId = elements_sites.siteId) WHERE (elements_sites.siteId='1') AND (elements.id='1') AND (elements.archived=FALSE) AND (elements.dateDeleted IS NULL) AND (elements.draftId IS NULL) AND (elements.revisionId IS NULL) ORDER BY users.username LIMIT 1) subquery INNER JOIN users users ON users.id = subquery.elementsId INNER JOIN elements elements ON elements.id = subquery.elementsId INNER JOIN elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN content content ON content.id = subquery.contentId ORDER BY users.username 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT users.password, elements.id, elements.fieldLayoutId, elements.uid, elements.enabled, elements.archived, elements.dateCreated, elements.dateUpdated, elements_sites.slug, elements_sites.siteId, elements_sites.enabled AS enabledForSite, elements_sites.uri, users.username, users.firstName, users.lastName, users.email, users.admin, users.locked, users.pending, users.suspended, users.lastLoginDate, users.lockoutDate, users.photoId, users.hasDashboard, content.id AS contentId, content.field_additionToFooter, content.field_additionToHead, content.field_altText, content.field_attribution, content.field_callToAction, content.field_caption, content.field_confirmedChoirNumbers, content.field_copy, content.field_description, content.field_embed, content.field_freeformForm, content.field_headline, content.field_highlight, content.field_icon, content.field_isPrivate, content.field_marketing, content.field_myNumber, content.field_phone, content.field_pricebookId, content.field_productFamily, content.field_registrationId, content.field_salesforce_id, content.field_seo, content.field_thirdParty, content.field_transactional, content.field_usr_type, content.field_userGroup, content.field_video, content.field_xeroAccountCode FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM elements elements INNER JOIN users users ON users.id = elements.id INNER JOIN elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN content content ON (content.elementId = elements.id) AND (content.siteId = elements_sites.siteId) WHERE (elements_sites.siteId='1') AND (elements.id='1') AND (elements.archived=FALSE) AND (elements.dateDeleted IS NULL) AND (elements.draftId IS NULL) AND (elements.revisionId IS NULL) ORDER BY users.username LIMIT 1) subquery INNER JOIN users users ON users.id = subquery.elementsId INNER JOIN elements elements ON elements.id = subquery.elementsId INNER JOIN elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN content content ON content.id = subquery.contentId ORDER BY users.username 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT users.password, elements.id, elements.fieldLayoutId, elements.uid, elements.enabled, elements.archived, elements.dateCreated, elements.dateUpdated, elements_sites.slug, elements_sites.siteId, elements_sites.enabled AS enabledForSite, elements_sites.uri, users.username, users.firstName, users.lastName, users.email, users.admin, users.locked, users.pending, users.suspended, users.lastLoginDate, users.lockoutDate, users.photoId, users.hasDashboard, content.id AS contentId, content.field_additionToFooter, content.field_additionToHead, content.field_altText, content.field_attribution, content.field_callToAction, content.field_caption, content.field_confirmedChoirNumbers, content.field_copy, content.field_description, content.field_embed, content.field_freeformForm, content.field_headline, content.field_highlight, content.field_icon, content.field_isPrivate, content.field_marketing, content.field_myNumber, content.field_phone, content.field_pricebookId, content.field_productFamily, content.field_registrationId, content.field_salesforce_id, content.field_seo, content.field_thirdParty, content.field_transactional, content.field_usr_type, content.field_userGroup, content.field_video, content.field_xeroAccountCode FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM elements elements INNER JOIN users users ON users.id = elements.id INNER JOIN elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN content content ON (content.elementId = elements.id) AND (content.siteId = elements_sites.siteId) WHERE (elements_sites.siteId='1') AND (elements.id='1') AND (elements.archived=FALSE) AND (elements.dateDeleted IS NULL) AND (elements.draftId IS NULL) AND (elements.revisionId IS NULL) ORDER BY users.username LIMIT 1) subquery INNER JOIN users users ON users.id = subquery.elementsId INNER JOIN elements elements ON elements.id = subquery.elementsId INNER JOIN elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN content content ON content.id = subquery.contentId ORDER BY users.username 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM resourcepaths 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SHOW FULL COLUMNS FROM resourcepaths 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SHOW FULL COLUMNS FROM resourcepaths 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][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 = 'resourcepaths' AND kcu.table_name = 'resourcepaths' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, CASE WHEN NULL IS NULL AND kcu.REFERENCED_TABLE_SCHEMA = DATABASE() THEN NULL ELSE kcu.REFERENCED_TABLE_SCHEMA END AS foreign_table_schema, kcu.REFERENCED_TABLE_NAME AS foreign_table_name, kcu.REFERENCED_COLUMN_NAME AS foreign_column_name, rc.UPDATE_RULE AS on_update, rc.DELETE_RULE AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.REFERENTIAL_CONSTRAINTS AS rc, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND kcu.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND rc.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE = 'FOREIGN KEY' UNION SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, NULL AS foreign_table_schema, NULL AS foreign_table_name, NULL AS foreign_column_name, NULL AS on_update, NULL AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.TABLE_NAME = 'resourcepaths' AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY position ASC 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, CASE WHEN NULL IS NULL AND kcu.REFERENCED_TABLE_SCHEMA = DATABASE() THEN NULL ELSE kcu.REFERENCED_TABLE_SCHEMA END AS foreign_table_schema, kcu.REFERENCED_TABLE_NAME AS foreign_table_name, kcu.REFERENCED_COLUMN_NAME AS foreign_column_name, rc.UPDATE_RULE AS on_update, rc.DELETE_RULE AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.REFERENTIAL_CONSTRAINTS AS rc, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND kcu.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND rc.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE = 'FOREIGN KEY' UNION SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, NULL AS foreign_table_schema, NULL AS foreign_table_name, NULL AS foreign_column_name, NULL AS on_update, NULL AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.TABLE_NAME = 'resourcepaths' AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY position ASC 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, CASE WHEN NULL IS NULL AND kcu.REFERENCED_TABLE_SCHEMA = DATABASE() THEN NULL ELSE kcu.REFERENCED_TABLE_SCHEMA END AS foreign_table_schema, kcu.REFERENCED_TABLE_NAME AS foreign_table_name, kcu.REFERENCED_COLUMN_NAME AS foreign_column_name, rc.UPDATE_RULE AS on_update, rc.DELETE_RULE AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.REFERENTIAL_CONSTRAINTS AS rc, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND kcu.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_SCHEMA = kcu.TABLE_SCHEMA AND rc.TABLE_NAME = 'resourcepaths' AND rc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE = 'FOREIGN KEY' UNION SELECT kcu.CONSTRAINT_NAME AS name, kcu.COLUMN_NAME AS column_name, tc.CONSTRAINT_TYPE AS type, NULL AS foreign_table_schema, NULL AS foreign_table_name, NULL AS foreign_column_name, NULL AS on_update, NULL AS on_delete, kcu.ORDINAL_POSITION AS position FROM information_schema.KEY_COLUMN_USAGE AS kcu, information_schema.TABLE_CONSTRAINTS AS tc WHERE kcu.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND kcu.TABLE_NAME = 'resourcepaths' AND tc.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND tc.TABLE_NAME = 'resourcepaths' AND tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME AND tc.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY position ASC 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT s.INDEX_NAME AS name, s.COLUMN_NAME AS column_name, s.NON_UNIQUE ^ 1 AS index_is_unique, s.INDEX_NAME = 'PRIMARY' AS index_is_primary FROM information_schema.STATISTICS AS s WHERE s.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND s.INDEX_SCHEMA = s.TABLE_SCHEMA AND s.TABLE_NAME = 'resourcepaths' ORDER BY s.SEQ_IN_INDEX ASC 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT s.INDEX_NAME AS name, s.COLUMN_NAME AS column_name, s.NON_UNIQUE ^ 1 AS index_is_unique, s.INDEX_NAME = 'PRIMARY' AS index_is_primary FROM information_schema.STATISTICS AS s WHERE s.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND s.INDEX_SCHEMA = s.TABLE_SCHEMA AND s.TABLE_NAME = 'resourcepaths' ORDER BY s.SEQ_IN_INDEX ASC 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT s.INDEX_NAME AS name, s.COLUMN_NAME AS column_name, s.NON_UNIQUE ^ 1 AS index_is_unique, s.INDEX_NAME = 'PRIMARY' AS index_is_primary FROM information_schema.STATISTICS AS s WHERE s.TABLE_SCHEMA = COALESCE(NULL, DATABASE()) AND s.INDEX_SCHEMA = s.TABLE_SCHEMA AND s.TABLE_NAME = 'resourcepaths' ORDER BY s.SEQ_IN_INDEX ASC 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@wbrowar/guide/assetbundles/guide/dist', '20678e55') ON DUPLICATE KEY UPDATE path='@wbrowar/guide/assetbundles/guide/dist' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@wbrowar/guide/assetbundles/guide/dist', '20678e55') ON DUPLICATE KEY UPDATE path='@wbrowar/guide/assetbundles/guide/dist' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@wbrowar/guide/assetbundles/guide/dist', '20678e55') ON DUPLICATE KEY UPDATE path='@wbrowar/guide/assetbundles/guide/dist' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@app/web/assets/cp/dist', '1d8b9d35') ON DUPLICATE KEY UPDATE path='@app/web/assets/cp/dist' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@app/web/assets/cp/dist', '1d8b9d35') ON DUPLICATE KEY UPDATE path='@app/web/assets/cp/dist' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@app/web/assets/cp/dist', '1d8b9d35') ON DUPLICATE KEY UPDATE path='@app/web/assets/cp/dist' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/d3', 'fb0f4b04') ON DUPLICATE KEY UPDATE path='@lib/d3' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/d3', 'fb0f4b04') ON DUPLICATE KEY UPDATE path='@lib/d3' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/d3', 'fb0f4b04') ON DUPLICATE KEY UPDATE path='@lib/d3' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/element-resize-detector', '5690fc27') ON DUPLICATE KEY UPDATE path='@lib/element-resize-detector' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/element-resize-detector', '5690fc27') ON DUPLICATE KEY UPDATE path='@lib/element-resize-detector' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/element-resize-detector', '5690fc27') ON DUPLICATE KEY UPDATE path='@lib/element-resize-detector' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/garnishjs', 'c8b25c82') ON DUPLICATE KEY UPDATE path='@lib/garnishjs' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/garnishjs', 'c8b25c82') ON DUPLICATE KEY UPDATE path='@lib/garnishjs' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/garnishjs', 'c8b25c82') ON DUPLICATE KEY UPDATE path='@lib/garnishjs' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@bower/jquery/dist', '790057d2') ON DUPLICATE KEY UPDATE path='@bower/jquery/dist' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@bower/jquery/dist', '790057d2') ON DUPLICATE KEY UPDATE path='@bower/jquery/dist' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@bower/jquery/dist', '790057d2') ON DUPLICATE KEY UPDATE path='@bower/jquery/dist' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-touch-events', 'f20e5797') ON DUPLICATE KEY UPDATE path='@lib/jquery-touch-events' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-touch-events', 'f20e5797') ON DUPLICATE KEY UPDATE path='@lib/jquery-touch-events' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-touch-events', 'f20e5797') ON DUPLICATE KEY UPDATE path='@lib/jquery-touch-events' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/velocity', '688fa0af') ON DUPLICATE KEY UPDATE path='@lib/velocity' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/velocity', '688fa0af') ON DUPLICATE KEY UPDATE path='@lib/velocity' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/velocity', '688fa0af') ON DUPLICATE KEY UPDATE path='@lib/velocity' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-ui', '26263b0a') ON DUPLICATE KEY UPDATE path='@lib/jquery-ui' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-ui', '26263b0a') ON DUPLICATE KEY UPDATE path='@lib/jquery-ui' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery-ui', '26263b0a') ON DUPLICATE KEY UPDATE path='@lib/jquery-ui' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery.payment', '74a80f47') ON DUPLICATE KEY UPDATE path='@lib/jquery.payment' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery.payment', '74a80f47') ON DUPLICATE KEY UPDATE path='@lib/jquery.payment' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/jquery.payment', '74a80f47') ON DUPLICATE KEY UPDATE path='@lib/jquery.payment' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/picturefill', 'f5aa6b55') ON DUPLICATE KEY UPDATE path='@lib/picturefill' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/picturefill', 'f5aa6b55') ON DUPLICATE KEY UPDATE path='@lib/picturefill' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/picturefill', 'f5aa6b55') ON DUPLICATE KEY UPDATE path='@lib/picturefill' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/selectize', 'a1d446d1') ON DUPLICATE KEY UPDATE path='@lib/selectize' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/selectize', 'a1d446d1') ON DUPLICATE KEY UPDATE path='@lib/selectize' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/selectize', 'a1d446d1') ON DUPLICATE KEY UPDATE path='@lib/selectize' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fileupload', 'ed426aab') ON DUPLICATE KEY UPDATE path='@lib/fileupload' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fileupload', 'ed426aab') ON DUPLICATE KEY UPDATE path='@lib/fileupload' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fileupload', 'ed426aab') ON DUPLICATE KEY UPDATE path='@lib/fileupload' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/xregexp', 'abb8025b') ON DUPLICATE KEY UPDATE path='@lib/xregexp' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/xregexp', 'abb8025b') ON DUPLICATE KEY UPDATE path='@lib/xregexp' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/xregexp', 'abb8025b') ON DUPLICATE KEY UPDATE path='@lib/xregexp' 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fabric', 'ddf488bc') ON DUPLICATE KEY UPDATE path='@lib/fabric' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fabric', 'ddf488bc') ON DUPLICATE KEY UPDATE path='@lib/fabric' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@lib/fabric', 'ddf488bc') ON DUPLICATE KEY UPDATE path='@lib/fabric' 2019-09-24 16:44:46 [-][1][-][info][wbrowar\guide\Guide::init] Guide plugin loaded 2019-09-24 16:44:46 [-][1][-][info][chasegiunta\scss\Scss::init] SCSS plugin loaded 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::query] SELECT EXISTS(SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins WHERE handle='fieldlabels') 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::query] SELECT EXISTS(SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins WHERE handle='fieldlabels') 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::query] SELECT EXISTS(SELECT id, handle, version, schemaVersion, licenseKeyStatus, installDate, licensedEdition FROM plugins WHERE handle='fieldlabels') 2019-09-24 16:44:46 [-][1][-][info][craftconditions\conditions\Conditions::init] Conditions plugin loaded 2019-09-24 16:44:46 [-][1][-][info][kuriousagency\commerce\adminorders\AdminOrders::init] Commerce Admin Orders plugin loaded 2019-09-24 16:44:46 [-][1][-][info][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@verbb/iconpicker/resources/dist', '577762fa') ON DUPLICATE KEY UPDATE path='@verbb/iconpicker/resources/dist' 2019-09-24 16:44:46 [-][1][-][profile begin][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@verbb/iconpicker/resources/dist', '577762fa') ON DUPLICATE KEY UPDATE path='@verbb/iconpicker/resources/dist' 2019-09-24 16:44:46 [-][1][-][profile end][yii\db\Command::execute] INSERT INTO resourcepaths (path, hash) VALUES ('@verbb/iconpicker/resources/dist', '577762fa') ON DUPLICATE KEY UPDATE path='@verbb/iconpicker/resources/dist' 2019-09-24 16:44:46 [-][1][-][info][wideweb\plugindev\PluginDev::init] Plugin Dev plugin loaded 2019-09-24 16:44:46 [-][1][-][trace][craft\web\Application::_processActionRequest] Route requested: 'users/get-remaining-session-time' 2019-09-24 16:44:46 [-][1][-][trace][yii\base\Controller::runAction] Route to run: users/get-remaining-session-time 2019-09-24 16:44:46 [-][1][-][trace][yii\base\InlineAction::runWithParams] Running action: craft\controllers\UsersController::actionGetRemainingSessionTime() 2019-09-24 16:44:46 [-][1][-][info][application] $_GET = [ 'p' => 'admin/actions/users/get-remaining-session-time' 'dontExtendSession' => '1' ]

$_POST = []

$_FILES = []

$_COOKIE = [ '1031b8c41dfff97a311a7ac99863bdc5_username' => '1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca:2:{i:0;s:41:\"1031b8c41dfff97a311a7ac99863bdc5_username\";i:1;s:23:\"daniel@takefortytwo.com\";}' 'intercom-id-whxs6x8o' => 'a48b4315-9f07-49c2-83e2-992f335181da' '__stripe_mid' => '9e2da3ad-1859-4c40-be86-fba13eaeaec5' 'CraftSessionId' => 'uabfr5g10oa8jfr5ln8jutdktj' '1031b8c41dfff97a311a7ac99863bdc5_identity' => 'cbcf078fa28e4797b5243b9ce2f237ea3453bbeb3b347c02d0241d9fe5151796a:2:{i:0;s:41:\"1031b8c41dfff97a311a7ac99863bdc5_identity\";i:1;s:250:\"[\"1\",\"[\\"Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88\\",null,\\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36\\"]\",3600]\";}' 'CRAFT_CSRF_TOKEN' => '•••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' ]

$_SESSION = [ 'bd62416aa8538ede709019a5e113eea5flash' => [] '1031b8c41dfff97a311a7ac99863bdc5token' => '••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••' '1031b8c41dfff97a311a7ac99863bdc5id' => '1' '1031b8c41dfff97a311a7ac99863bdc5expire' => 1569347084 'commerce_customer' => '1' ]

$_SERVER = [ 'HTTP_HOST' => 'youngvoicesdev.test' 'HTTP_CONNECTION' => 'keep-alive' 'HTTP_ACCEPT' => 'application/json, text/javascript, /; q=0.01' 'HTTP_X_REQUESTED_WITH' => 'XMLHttpRequest' 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36' 'HTTP_REFERER' => 'http://youngvoicesdev.test/admin/commerce/orders' 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate' 'HTTP_ACCEPT_LANGUAGE' => 'es-ES,es;q=0.9,en-US;q=0.8,en;q=0.7' 'HTTP_COOKIE' => '1031b8c41dfff97a311a7ac99863bdc5_username=1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca%3A2%3A%7Bi%3A0%3Bs%3A41%3A%221031b8c41dfff97a311a7ac99863bdc5_username%22%3Bi%3A1%3Bs%3A23%3A%22daniel%40takefortytwo.com%22%3B%7D; intercom-id-whxs6x8o=a48b4315-9f07-49c2-83e2-992f335181da; __stripe_mid=9e2da3ad-1859-4c40-be86-fba13eaeaec5; CraftSessionId=uabfr5g10oa8jfr5ln8jutdktj; 1031b8c41dfff97a311a7ac99863bdc5_identity=cbcf078fa28e4797b5243b9ce2f237ea3453bbeb3b347c02d0241d9fe5151796a%3A2%3A%7Bi%3A0%3Bs%3A41%3A%221031b8c41dfff97a311a7ac99863bdc5_identity%22%3Bi%3A1%3Bs%3A250%3A%22%5B%221%22%2C%22%5B%5C%22Ukzy1mfGbr4brIbbKxx2AsZc7f7B8RSHBLD3501h3jTa6MXewU3mHnhJ-fNiBV09HHOb8MUhH8YbODI17Kk07DYg4K5j_TRtdp88%5C%22%2Cnull%2C%5C%22Mozilla%2F5.0+%28Macintosh%3B+Intel+Mac+OS+X+10_14_6%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F76.0.3809.132+Safari%2F537.36%5C%22%5D%22%2C3600%5D%22%3B%7D; CRAFT_CSRF_TOKEN=f4b60c9cf93cb18ec7d202b9c78af83d4e7cd923b9d48db279976f727a163522a%3A2%3A%7Bi%3A0%3Bs%3A16%3A%22CRAFT_CSRF_TOKEN%22%3Bi%3A1%3Bs%3A208%3A%223kEVOeORATAJpOoOvANcz3qX0tl6430f5NXVgy2j%7C796d40196e67ef88029c2d0708048d778cf78bd440f4606cdd8e19f10c0254773kEVOeORATAJpOoOvANcz3qX0tl6430f5NXVgy2j%7C1%7C%242y%2413%24kB1MijxNcE3GG.faj5QO5efBk4LWfvOIGxirKWXApWHRLpFJB1cQG%22%3B%7D' 'PATH' => '/usr/bin:/bin:/usr/sbin:/sbin' 'SERVER_SIGNATURE' => '' 'SERVER_SOFTWARE' => 'Apache' 'SERVER_NAME' => 'youngvoicesdev.test' 'SERVER_ADDR' => '::1' 'SERVER_PORT' => '80' 'REMOTE_ADDR' => '::1' 'DOCUMENT_ROOT' => '/Applications/MAMP/youngvoices_testing/web' 'SERVER_ADMIN' => 'you@example.com' 'SCRIPT_FILENAME' => '/Applications/MAMP/youngvoices_testing/web/index.php' 'REMOTE_PORT' => '59046' 'GATEWAY_INTERFACE' => 'CGI/1.1' 'SERVER_PROTOCOL' => 'HTTP/1.1' 'REQUEST_METHOD' => 'GET' 'QUERY_STRING' => 'p=admin/actions/users/get-remaining-session-time&dontExtendSession=1' 'REQUEST_URI' => '/index.php?p=admin/actions/users/get-remaining-session-time&dontExtendSession=1' 'SCRIPT_NAME' => '/index.php' 'PHP_SELF' => '/index.php' 'REQUEST_TIME_FLOAT' => 1569343486.22 'REQUEST_TIME' => 1569343486 'argv' => [ 0 => 'p=admin/actions/users/get-remaining-session-time&dontExtendSession=1' ] 'argc' => 1 'ENVIRONMENT' => 'dev' 'SECURITY_KEY' => '••••••••••••••••••••••••••••••••' 'DB_DRIVER' => 'mysql' 'DB_SERVER' => 'localhost' 'DB_USER' => 'root' 'DB_PASSWORD' => '••••' 'DB_DATABASE' => 'youngvoi_2019' 'DB_SCHEMA' => 'public' 'DB_TABLE_PREFIX' => ''

El mar., 24 sept. 2019 a las 17:55, Samuel Birch (< notifications@github.com>) escribió:

Reopened #15 https://github.com/KuriousAgency/commerce-admin-orders/issues/15.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/KuriousAgency/commerce-admin-orders/issues/15?email_source=notifications&email_token=ACYXFUVD67V5SBGZ44G5BDDQLIZ7BA5CNFSM4IZHS2EKYY3PNVWWK3TUL52HS4DFWZEXG43VMVCXMZLOORHG65DJMZUWGYLUNFXW5KTDN5WW2ZLOORPWSZGOTZ3W56Y#event-2658627323, or mute the thread https://github.com/notifications/unsubscribe-auth/ACYXFUUZ2TNMAFFN5UAD3LTQLIZ7BANCNFSM4IZHS2EA .

samuelbirch commented 4 years ago

@senpuukyakuu The error you are getting is not actually related to this plugin, the error is coming from commerce itself. But looking at your logs it looks like the issue is initiating from the globalpayments plugin:

Trying to get property 'handle' of non-object in /Applications/MAMP/youngvoices_testing/custom_plugins/globalpayments/src/Plugin.php:87

senpuukyakuu commented 4 years ago

@samuelbirch fixed that, not really sure what the issue is, although I'm having another early in the process. Which is here: $request = Craft::$app->getRequest();

    if($number = $request->getParam('orderNumber')) {
        $cart = Commerce::getInstance()->getOrders()->getOrderByNumber($number);
    } elseif($orderId = $request->getParam('orderId')) {
        $cart = Commerce::getInstance()->getOrders()->getOrderById($orderId);
    }

line 451 to 457 of OrdersController.php doesn't seem to be getting the cart from Commerce.

samuelbirch commented 4 years ago

when you check the logs after you try to add something to the cart, is an orderNumber or orderId being passed through?

senpuukyakuu commented 4 years ago

This is what's being passed to the controller.

action: commerce-admin-orders/orders/add-to-cart purchasableId: 1724 adminOrderQty: 1

D,

El mié., 25 sept. 2019 a las 12:46, Samuel Birch (notifications@github.com) escribió:

when you check the logs after you try to add something to the cart, is an orderNumber or orderId being passed through?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/KuriousAgency/commerce-admin-orders/issues/15?email_source=notifications&email_token=ACYXFUU5BI53SK4XBJZKLZLQLM6OPA5CNFSM4IZHS2EKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD7RORLQ#issuecomment-534964398, or mute the thread https://github.com/notifications/unsubscribe-auth/ACYXFUX2PQM6OOD6BCCMVO3QLM6OPANCNFSM4IZHS2EA .

samuelbirch commented 4 years ago

@senpuukyakuu just published 2.5.3, see if this fixes it?

senpuukyakuu commented 4 years ago

OK, thanks, let me give it a try. D,

El mié., 25 sept. 2019 a las 13:12, Samuel Birch (notifications@github.com) escribió:

@senpuukyakuu https://github.com/senpuukyakuu just published 2.5.3, see if this fixes it?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/KuriousAgency/commerce-admin-orders/issues/15?email_source=notifications&email_token=ACYXFUVPL72OVPGPU6UU4JLQLNBQ5A5CNFSM4IZHS2EKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD7RQR7Q#issuecomment-534972670, or mute the thread https://github.com/notifications/unsubscribe-auth/ACYXFUTGFWU2LOHFD24VYBDQLNBQ5ANCNFSM4IZHS2EA .

senpuukyakuu commented 4 years ago

Seems to be working ok now. Thanks!

El mié., 25 sept. 2019 a las 13:15, Daniel Rico (senpuukyakuu@gmail.com) escribió:

OK, thanks, let me give it a try. D,

El mié., 25 sept. 2019 a las 13:12, Samuel Birch (< notifications@github.com>) escribió:

@senpuukyakuu https://github.com/senpuukyakuu just published 2.5.3, see if this fixes it?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/KuriousAgency/commerce-admin-orders/issues/15?email_source=notifications&email_token=ACYXFUVPL72OVPGPU6UU4JLQLNBQ5A5CNFSM4IZHS2EKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD7RQR7Q#issuecomment-534972670, or mute the thread https://github.com/notifications/unsubscribe-auth/ACYXFUTGFWU2LOHFD24VYBDQLNBQ5ANCNFSM4IZHS2EA .

senpuukyakuu commented 4 years ago

Hi Samuel, I'm now having issues with the manual payment gateway, When I create a manual order, no transactions is created, so when I try to select the manual payment gateway is just returns.

HTTP 400 – Bad Request – yii\web\BadRequestHttpException Unable to verify your data submission.

  1. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/yiisoft/yii2/web/Controller.php at line 166 157158159160161162163164165166167168169170171172173174175 }

    /**

    • {@inheritdoc} */ public function beforeAction($action) { if (parent::beforeAction($action)) { if ($this->enableCsrfValidation && Yii::$app->getErrorHandler()->exception === null && !Yii::$app->getRequest()->validateCsrfToken()) { throw new BadRequestHttpException(Yii::t('yii', 'Unable to verify your data submission.')); }

      return true;

      }

      return false; }

    /**

  2. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/craftcms/cms/src/web/Controller.php at line 143 – yii\web\Controller::beforeAction(yii\base\InlineAction) 137138139140141142143144145146147148149 // Don't enable CSRF validation for Live Preview requests if ($request->getIsLivePreview()) { $this->enableCsrfValidation = false; }

    if (!parent::beforeAction($action)) {
    return false;
}

// Enforce $allowAnonymous
$isLive = Craft::$app->getIsLive();
$test = $isLive ? self::ALLOW_ANONYMOUS_LIVE : self::ALLOW_ANONYMOUS_OFFLINE;

  3. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/yiisoft/yii2/base/Controller.php at line 155 – craft\web\Controller::beforeAction(yii\base\InlineAction)

  4. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/craftcms/cms/src/web/Controller.php at line 187 – yii\base\Controller::runAction('edit-order', ['orderId' => '8237', 'p' => 'admin/commerce/orders/8237']) 181182183184185186187188189190191192193 /**

    • @inheritdoc */ public function runAction($id, $params = []) { try { return parent::runAction($id, $params); } catch (\Throwable $e) { if (Craft::$app->getRequest()->getAcceptsJson()) { Craft::$app->getErrorHandler()->logException($e); if (!YII_DEBUG && !$e instanceof UserException) { $message = Craft::t('app', 'An unknown error occurred.'); } else {

  5. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/yiisoft/yii2/base/Module.php at line 528 – craft\web\Controller::runAction('edit-order', ['orderId' => '8237', 'p' => 'admin/commerce/orders/8237'])

  6. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/craftcms/cms/src/web/Application.php at line 299 – yii\base\Module::runAction('commerce/orders/edit-order', ['orderId' => '8237', 'p' => 'admin/commerce/orders/8237']) 293294295296297298299300301302303304305 * @param string $route

    • @param array $params

    • @return Response|null The result of the action, normalized into a Response object */ public function runAction($route, $params = []) { $result = parent::runAction($route, $params);

      if ($result !== null) { if ($result instanceof Response) { return $result; }

  7. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/yiisoft/yii2/web/Application.php at line 103 – craft\web\Application::runAction('commerce/orders/edit-order', ['orderId' => '8237', 'p' => 'admin/commerce/orders/8237'])

  8. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/craftcms/cms/src/web/Application.php at line 284 – yii\web\Application::handleRequest(craft\web\Request) 278279280281282283284285286287288289290 if (($response = $this->_processActionRequest($request)) !== null) { return $response; }

    // If we're still here, finally let Yii do it's thing.
try {
    return parent::handleRequest($request);
} catch (\Throwable $e) {
    $this->_unregisterDebugModule();
    throw $e;
}

    }

  9. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/vendor/yiisoft/yii2/base/Application.php at line 386 – craft\web\Application::handleRequest(craft\web\Request)

  10. in /chroot/home/youngvoi/youngvoices.co.uk/youngvoices_testing/web/index.php at line 21 – yii\base\Application::run() 15161718192021 (new Dotenv\Dotenv(CRAFT_BASE_PATH))->load(); }

// Load and run Craft define('CRAFT_ENVIRONMENT', getenv('ENVIRONMENT') ?: 'production'); $app = require CRAFT_VENDOR_PATH.'/craftcms/cms/bootstrap/web.php'; $app->run();

  1. in /chroot/home/youngvoi/youngvoices.co.uk/html/testing/index.php at line 19 – require_once('/chroot/home/youngvoi/youngvoice...') 13141516171819 http_response_code(503); }

    exit('Could not find your craft/ folder. Please ensure that $craftPath is set correctly in '.FILE); }

require_once $path; $_GET = [ 'p' => 'admin/commerce/orders/8237', ];

$_POST = [ 'redirect' => '16be7068ed4d29e7cfa6aacd3050d75c0ed7b269c0d85049fe94d5367c79263chttps://testing.youngvoices.co.uk/admin/commerce/orders/8237', ];

$_COOKIE = [ '1031b8c41dfff97a311a7ac99863bdc5_username' => '1311d21373ed25250e8d41fc878c8a98698881dc6c1d2e5c062817ac8ad6fb9ca:2:{i:0;s:41:"1031b8c41dfff97a311a7ac99863bdc5_username";i:1;s:23:"daniel@takefortytwo.com";}', 'stripe_mid' => 'f5d0ed18-5f2d-47e7-ae10-5c83f42fb5e5', '_ga' => 'GA1.3.1357054459.1567685000', 'intercom-id-whxs6x8o' => '6e96d3c0-d480-4e4d-8306-e69461831dde', 'CraftSessionId' => '7c50ad644c90034a324ba6cf8e88ecee', '1031b8c41dfff97a311a7ac99863bdc5_identity' => 'fb2796a047b44ad32175e26e26df9ff42278d1e2a52d620955309217c7ebf25ea:2:{i:0;s:41:"1031b8c41dfff97a311a7ac99863bdc5_identity";i:1;s:250:"["1","[\"G-ehV5D69qo60lHhExzS8W6VMLyTSo597BRg73WUFqHN6p9k8xzOt_n-oY9TDlS3sht3U7PCD7lqeupEwg4uLnxKxmtYXK99TQvn\",null,\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36\"]",3600]";}', 'CRAFT_CSRF_TOKEN' => 'f2547a871f85edde7289f1b5d359ef172af007dee5adc315649eb38ae2cc19b7a:2:{i:0;s:16:"CRAFT_CSRF_TOKEN";i:1;s:208:"-__6cdqAma3FQrcTFhJZxJob_D5zj8yKaduxlcrf|0efcac42ba85e034a42fb46ee9914a303943bfa3188678a259ead3df073b0f49-6cdqAma3FQrcTFhJZxJob_D5zj8yKaduxlcrf|1|$2y$13$kB1MijxNcE3GG.faj5QO5efBk4LWfvOIGxirKWXApWHRLpFJB1cQG";}', ];

$_SESSION = [ 'bd62416aa8538ede709019a5e113eea5flash' => [], '1031b8c41dfff97a311a7ac99863bdc5token' => 'G-ehV5D69qo60lHhExzS8W6VMLyTSo597BRg73WUFqHN6p9k8xzOt_n-oY9TDlS3sht3U7PCD7lqeupEwg4uLnxKxmtYXK99TQvn', '1031b8c41dfff97a311a7ac99863bdc5id' => '1', '1031b8c41dfff97a311a7ac99863bdc5expire' => 1569583575, 'commerce_customer' => '1', 'commerce_cart' => 'f053cdd8370c12112f44d14f1df06a2a', ];

And if it's paid via CC, it marks the cart as paid but doesn't complete it, and when I try to mark it as complete it returns an unkwnown error. Thanks, D,