[2025-05-01 00:00:03] local.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'published_date' in 'where clause' (SQL: select `id` from `questions` where `published_date` between 2025-04-30 00:00:00 and 2025-04-30 23:59:59 and `status` = 1 and `questions`.`deleted_at` is null) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'published_date' in 'where clause' (SQL: select `id` from `questions` where `published_date` between 2025-04-30 00:00:00 and 2025-04-30 23:59:59 and `status` = 1 and `questions`.`deleted_at` is null) at /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712) [stacktrace] #0 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select `id` fro...', Array, Object(Closure)) #1 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\\Database\\Connection->run('select `id` fro...', Array, Object(Closure)) #2 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\\Database\\Connection->select('select `id` fro...', Array, true) #3 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2626): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2628): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(775): Illuminate\\Database\\Query\\Builder->pluck('id', NULL) #7 /var/www/html/spaceagent/akisuku/app/Console/Commands/CreateTestCommand.php(49): Illuminate\\Database\\Eloquent\\Builder->pluck('id') #8 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\CreateTestCommand->handle() #9 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #10 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #11 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #12 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #13 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array) #14 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #15 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #16 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(1015): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #17 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(App\\Console\\Commands\\CreateTestCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #18 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #19 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #20 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #21 /var/www/html/spaceagent/akisuku/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #22 {main} [previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'published_date' in 'where clause' at /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368) [stacktrace] #0 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): PDO->prepare('select `id` fro...') #1 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select `id` fro...', Array) #2 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select `id` fro...', Array, Object(Closure)) #3 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\\Database\\Connection->run('select `id` fro...', Array, Object(Closure)) #4 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\\Database\\Connection->select('select `id` fro...', Array, true) #5 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2626): Illuminate\\Database\\Query\\Builder->runSelect() #6 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2628): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(775): Illuminate\\Database\\Query\\Builder->pluck('id', NULL) #9 /var/www/html/spaceagent/akisuku/app/Console/Commands/CreateTestCommand.php(49): Illuminate\\Database\\Eloquent\\Builder->pluck('id') #10 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\CreateTestCommand->handle() #11 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #12 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #13 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #14 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #15 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array) #16 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #17 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #18 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(1015): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #19 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(App\\Console\\Commands\\CreateTestCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #20 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #21 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #22 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #23 /var/www/html/spaceagent/akisuku/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #24 {main} "} [2025-05-01 00:00:06] local.INFO: {"id":"0flmlyqp8ccgkl5m4st67xvu6","resource":"payment","status":"captured","amount":11760,"tax":0,"customer":"e3c9cvkmq7fyytxoh56i7w4f2","payment_deadline":"2025-05-03T14:59:59Z","payment_details":{"type":"credit_card","email":"tranngocanh23595@gmail.com","brand":"master","last_four_digits":"4444","month":11,"year":2025},"payment_method_fee":0,"total":11760,"currency":"JPY","description":null,"captured_at":"2025-04-30T15:00:05Z","external_order_num":null,"metadata":{},"created_at":"2025-04-30T15:00:05Z","amount_refunded":0,"locale":"ja","session":null,"customer_family_name":null,"customer_given_name":null,"mcc":null,"statement_descriptor":null,"refunds":[],"refund_requests":[]} [2025-05-01 00:00:06] local.ERROR: Too few arguments to function App\Mail\PaymentMail::__construct(), 1 passed in /var/www/html/spaceagent/akisuku/app/Console/Commands/PaymentPlan.php on line 79 and exactly 2 expected {"exception":"[object] (ArgumentCountError(code: 0): Too few arguments to function App\\Mail\\PaymentMail::__construct(), 1 passed in /var/www/html/spaceagent/akisuku/app/Console/Commands/PaymentPlan.php on line 79 and exactly 2 expected at /var/www/html/spaceagent/akisuku/app/Mail/PaymentMail.php:22) [stacktrace] #0 /var/www/html/spaceagent/akisuku/app/Console/Commands/PaymentPlan.php(79): App\\Mail\\PaymentMail->__construct(Object(App\\Models\\User)) #1 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\PaymentPlan->handle() #2 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #3 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #4 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #5 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #6 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array) #7 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #8 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #9 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(1015): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #10 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(App\\Console\\Commands\\PaymentPlan), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #11 /var/www/html/spaceagent/akisuku/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #12 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #13 /var/www/html/spaceagent/akisuku/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #14 /var/www/html/spaceagent/akisuku/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #15 {main} "} [2025-05-01 00:00:06] local.INFO: array ( 'id' => '2e0k9ays96imqiqewngym39t0', 'type' => 'payment.captured', 'resource' => 'event', 'data' => array ( 'id' => '0flmlyqp8ccgkl5m4st67xvu6', 'resource' => 'payment', 'status' => 'captured', 'amount' => 11760, 'tax' => 0, 'customer' => 'e3c9cvkmq7fyytxoh56i7w4f2', 'payment_deadline' => '2025-05-03T14:59:59Z', 'payment_details' => array ( 'type' => 'credit_card', 'email' => 'tranngocanh23595@gmail.com', 'brand' => 'master', 'last_four_digits' => '4444', 'month' => 11, 'year' => 2025, ), 'payment_method_fee' => 0, 'total' => 11760, 'currency' => 'JPY', 'description' => NULL, 'captured_at' => '2025-04-30T15:00:05Z', 'external_order_num' => NULL, 'metadata' => array ( ), 'created_at' => '2025-04-30T15:00:05Z', 'amount_refunded' => 0, 'locale' => 'ja', 'session' => NULL, 'customer_family_name' => NULL, 'customer_given_name' => NULL, 'mcc' => NULL, 'statement_descriptor' => NULL, 'refunds' => array ( ), 'refund_requests' => array ( ), ), 'created_at' => '2025-04-30T15:00:05Z', 'reason' => NULL, )