[2025-01-24 07:32:14] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1055 'maestro.cd.monto_cobrar' isn't in GROUP BY (SQL: SELECT id_credito_detalle, SUM(monto_inicial), SUM(saldo), cd.monto_cobrar, (SUM(saldo) - cd.monto_cobrar) diferencia, cd.monto_cobrado, (cd.monto_cobrar + cd.monto_cobrado) total from conceptos.`items`, maestro.credito_detalle cd where id_credito_detalle = cd.id /*and cd.monto_cobrado > 0 and estado = 'mora' and id_credito in ()*/ GROUP by id_credito_detalle HAVING diferencia < -100 or diferencia > 100 ORDER BY `diferencia` DESC; ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'maestro.cd.monto_cobrar' isn't in GROUP BY (SQL: SELECT id_credito_detalle, SUM(monto_inicial), SUM(saldo), cd.monto_cobrar, (SUM(saldo) - cd.monto_cobrar) diferencia, cd.monto_cobrado, (cd.monto_cobrar + cd.monto_cobrado) total from conceptos.`items`, maestro.credito_detalle cd where id_credito_detalle = cd.id /*and cd.monto_cobrado > 0 and estado = 'mora' and id_credito in ()*/ GROUP by id_credito_detalle HAVING diferencia < -100 or diferencia > 100 ORDER BY `diferencia` DESC; ) at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712) [stacktrace] #0 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\\Database\\Connection->run() #2 /var/www/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(442): Illuminate\\Database\\Connection->select() #3 /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\DatabaseManager->__call() #4 /var/www/app/Services/Checkeos/Chequeos/DiferenciaItemsCd.php(29): Illuminate\\Support\\Facades\\Facade::__callStatic() #5 /var/www/app/Services/Checkeos/Chequeos/DiferenciaItemsCd.php(34): App\\Services\\Checkeos\\Chequeos\\DiferenciaItemsCd->ejecutar() #6 /var/www/app/Services/Checkeos/CheckeosService.php(19): App\\Services\\Checkeos\\Chequeos\\DiferenciaItemsCd->chequear() #7 /var/www/app/Console/Commands/Checkeos.php(59): App\\Services\\Checkeos\\CheckeosService->ejecutar() #8 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\Checkeos->handle() #9 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #10 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure() #11 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod() #12 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call() #13 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call() #14 /var/www/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute() #15 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run() #16 /var/www/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run() #17 /var/www/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand() #18 /var/www/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun() #19 /var/www/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run() #20 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run() #21 /var/www/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle() #22 {main} [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'maestro.cd.monto_cobrar' isn't in GROUP BY at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368) [stacktrace] #0 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): PDO->prepare() #1 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\\Database\\Connection->run() #4 /var/www/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(442): Illuminate\\Database\\Connection->select() #5 /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\DatabaseManager->__call() #6 /var/www/app/Services/Checkeos/Chequeos/DiferenciaItemsCd.php(29): Illuminate\\Support\\Facades\\Facade::__callStatic() #7 /var/www/app/Services/Checkeos/Chequeos/DiferenciaItemsCd.php(34): App\\Services\\Checkeos\\Chequeos\\DiferenciaItemsCd->ejecutar() #8 /var/www/app/Services/Checkeos/CheckeosService.php(19): App\\Services\\Checkeos\\Chequeos\\DiferenciaItemsCd->chequear() #9 /var/www/app/Console/Commands/Checkeos.php(59): App\\Services\\Checkeos\\CheckeosService->ejecutar() #10 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\Checkeos->handle() #11 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #12 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure() #13 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod() #14 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call() #15 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call() #16 /var/www/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute() #17 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run() #18 /var/www/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run() #19 /var/www/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand() #20 /var/www/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun() #21 /var/www/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run() #22 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run() #23 /var/www/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle() #24 {main} "} [2025-01-24 07:35:23] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1055 'maestro.credito_detalle.monto_cobrado' isn't in GROUP BY (SQL: SELECT credito_detalle.id, credito_detalle.monto_cobrado, sum(desglose_pago.monto) suma_pagos, credito_detalle.monto_cobrar, credito_detalle.estado FROM maestro.credito_detalle, maestro.desglose_pago WHERE maestro.credito_detalle.id = maestro.desglose_pago.id_credito_detalle and (maestro.credito_detalle.estado is null or maestro.credito_detalle.estado = 'mora') GROUP BY maestro.credito_detalle.id HAVING maestro.credito_detalle.monto_cobrado < sum(maestro.desglose_pago.monto) ORDER BY maestro.credito_detalle.`monto_cobrado` ASC ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'maestro.credito_detalle.monto_cobrado' isn't in GROUP BY (SQL: SELECT credito_detalle.id, credito_detalle.monto_cobrado, sum(desglose_pago.monto) suma_pagos, credito_detalle.monto_cobrar, credito_detalle.estado FROM maestro.credito_detalle, maestro.desglose_pago WHERE maestro.credito_detalle.id = maestro.desglose_pago.id_credito_detalle and (maestro.credito_detalle.estado is null or maestro.credito_detalle.estado = 'mora') GROUP BY maestro.credito_detalle.id HAVING maestro.credito_detalle.monto_cobrado < sum(maestro.desglose_pago.monto) ORDER BY maestro.credito_detalle.`monto_cobrado` ASC ) at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712) [stacktrace] #0 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\\Database\\Connection->run() #2 /var/www/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(442): Illuminate\\Database\\Connection->select() #3 /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\DatabaseManager->__call() #4 /var/www/app/Services/Checkeos/Chequeos/MontoCobradoMenorSumaPagos.php(27): Illuminate\\Support\\Facades\\Facade::__callStatic() #5 /var/www/app/Services/Checkeos/Chequeos/MontoCobradoMenorSumaPagos.php(32): App\\Services\\Checkeos\\Chequeos\\MontoCobradoMenorSumaPagos->ejecutar() #6 /var/www/app/Services/Checkeos/CheckeosService.php(19): App\\Services\\Checkeos\\Chequeos\\MontoCobradoMenorSumaPagos->chequear() #7 /var/www/app/Console/Commands/Checkeos.php(59): App\\Services\\Checkeos\\CheckeosService->ejecutar() #8 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\Checkeos->handle() #9 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #10 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure() #11 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod() #12 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call() #13 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call() #14 /var/www/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute() #15 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run() #16 /var/www/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run() #17 /var/www/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand() #18 /var/www/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun() #19 /var/www/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run() #20 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run() #21 /var/www/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle() #22 {main} [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'maestro.credito_detalle.monto_cobrado' isn't in GROUP BY at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368) [stacktrace] #0 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): PDO->prepare() #1 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\\Database\\Connection->run() #4 /var/www/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(442): Illuminate\\Database\\Connection->select() #5 /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\DatabaseManager->__call() #6 /var/www/app/Services/Checkeos/Chequeos/MontoCobradoMenorSumaPagos.php(27): Illuminate\\Support\\Facades\\Facade::__callStatic() #7 /var/www/app/Services/Checkeos/Chequeos/MontoCobradoMenorSumaPagos.php(32): App\\Services\\Checkeos\\Chequeos\\MontoCobradoMenorSumaPagos->ejecutar() #8 /var/www/app/Services/Checkeos/CheckeosService.php(19): App\\Services\\Checkeos\\Chequeos\\MontoCobradoMenorSumaPagos->chequear() #9 /var/www/app/Console/Commands/Checkeos.php(59): App\\Services\\Checkeos\\CheckeosService->ejecutar() #10 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\Checkeos->handle() #11 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #12 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure() #13 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod() #14 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call() #15 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call() #16 /var/www/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute() #17 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run() #18 /var/www/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run() #19 /var/www/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand() #20 /var/www/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun() #21 /var/www/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run() #22 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run() #23 /var/www/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle() #24 {main} "}