[2025-05-15 08:22:40] production.ERROR: CalendarRepository, get() [2025-05-15 08:22:40] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 10:14:06] production.ERROR: Division by zero {"userId":112,"exception":"[object] (DivisionByZeroError(code: 0): Division by zero at /var/www/html/api/app/models/Repositories/Report/Type/ReportTable.php:604) [stacktrace] #0 /var/www/html/api/app/models/Repositories/Report/Type/ReportTable.php(578): App\\Models\\Repositories\\Report\\Type\\ReportTable->generateReportResultResponse() #1 /var/www/html/api/app/models/Repositories/Report/ReportRepository.php(540): App\\Models\\Repositories\\Report\\Type\\ReportTable->getReportsExportResult() #2 /var/www/html/api/app/Http/Controllers/Reports/ReportController.php(114): App\\Models\\Repositories\\Report\\ReportRepository->getReportsExportResult() #3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Reports\\ReportController->show() #4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #9 /var/www/html/api/app/Services/Acl/Acl.php(161): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): App\\Services\\Acl\\Acl->loadAcl() #11 /var/www/html/api/app/Http/Middleware/Acl.php(36): Illuminate\\Support\\Facades\\Facade::__callStatic() #12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Acl->handle() #13 /var/www/html/api/app/Http/Middleware/JWTCheck.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTCheck->handle() #15 /var/www/html/api/app/Http/Middleware/JWTResponse.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTResponse->handle() #17 /var/www/html/api/app/Http/Middleware/AfterResponseMiddleware.php(11): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AfterResponseMiddleware->handle() #19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #21 /var/www/html/api/app/Http/Middleware/AfterMiddleware.php(17): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AfterMiddleware->handle() #23 /var/www/html/api/app/Http/Middleware/UserActivity.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\UserActivity->handle() #25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #40 /var/www/html/api/app/Http/Middleware/JWTCheck.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTCheck->handle() #42 /var/www/html/api/app/Http/Middleware/Cors.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Cors->handle() #44 /var/www/html/api/app/Http/Middleware/BeforeMiddleware.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\BeforeMiddleware->handle() #46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle() #49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #52 /var/www/html/api/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #53 {main} "} [2025-05-15 10:14:06] production.ERROR: Exceptions: Division by zero [2025-05-15 10:14:06] production.ERROR: Exceptions Class: DivisionByZeroError [2025-05-15 10:14:06] production.ERROR: File: /var/www/html/api/app/models/Repositories/Report/Type/ReportTable.php [2025-05-15 10:14:06] production.ERROR: Line: 604 [2025-05-15 12:13:41] production.ERROR: CalendarRepository, get() [2025-05-15 12:13:41] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:42:00] production.ERROR: CalendarRepository, get() [2025-05-15 19:42:00] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:42:38] production.ERROR: file_key Полетата за Влага, Примеси и Зърнени Примеси са задаължителни за попълване в договорите!!! Прегледайте редовете на договора, въведете пропуснатите показатели и опитайте да запишете документа отново!!! does not have a _ and cannot be translated! [2025-05-15 19:42:38] production.ERROR: BaseDocumentRepository, checkSqlError(): errorMsgValidation Error! [2025-05-15 19:42:38] production.ERROR: Document type:47Internal number: 11369 [2025-05-15 19:43:16] production.ERROR: file_key Полетата за Влага, Примеси и Зърнени Примеси са задаължителни за попълване в договорите!!! Прегледайте редовете на договора, въведете пропуснатите показатели и опитайте да запишете документа отново!!! does not have a _ and cannot be translated! [2025-05-15 19:43:16] production.ERROR: BaseDocumentRepository, checkSqlError(): errorMsgValidation Error! [2025-05-15 19:43:16] production.ERROR: Document type:47Internal number: 11369 [2025-05-15 19:43:23] production.ERROR: CalendarRepository, get() [2025-05-15 19:43:23] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:44:21] production.ERROR: BaseRepository getAppVersion() [2025-05-15 19:44:21] production.ERROR: Unable to retrieve the last_modified for file at location: .git/refs/heads/master. [2025-05-15 19:44:25] production.ERROR: CalendarRepository, get() [2025-05-15 19:44:25] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:46:39] production.ERROR: CalendarRepository, get() [2025-05-15 19:46:39] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:46:52] production.ERROR: SQLSTATE[22018]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'null' to data type int. (SQL: select distinct top 1 [so].[label], [oref].[objectable_id], [oref].[sys_systemObjects_id] as [sys_systemObjects_id], [e].[name] as [element_name], [t].[name] as [table_name] from [sys_systemObjects] as [so] inner join [sys_objectReference] as [oref] on [so].[id] = [oref].[sys_systemObjects_id] inner join [sys_referenceMap_dynamic] as [rmd] on [rmd].[sys_form_id] = [oref].[sys_form_id] inner join [sys_element] as [e] on [rmd].[sys_element_id] = [e].[id] inner join [sys_table] as [t] on [rmd].[sys_table_id] = [t].[id] where [rmd].[id] = null) {"userId":87,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22018): SQLSTATE[22018]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'null' to data type int. (SQL: select distinct top 1 [so].[label], [oref].[objectable_id], [oref].[sys_systemObjects_id] as [sys_systemObjects_id], [e].[name] as [element_name], [t].[name] as [table_name] from [sys_systemObjects] as [so] inner join [sys_objectReference] as [oref] on [so].[id] = [oref].[sys_systemObjects_id] inner join [sys_referenceMap_dynamic] as [rmd] on [rmd].[sys_form_id] = [oref].[sys_form_id] inner join [sys_element] as [e] on [rmd].[sys_element_id] = [e].[id] inner join [sys_table] as [t] on [rmd].[sys_table_id] = [t].[id] where [rmd].[id] = null) at /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760) [stacktrace] #0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run() #2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select() #3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\\Database\\Query\\Builder->get() #7 /var/www/html/api/app/models/Repositories/systemObject/systemObjectRepository.php(1157): Illuminate\\Database\\Query\\Builder->first() #8 /var/www/html/api/app/models/Repositories/Element/ElementRepository.php(200): App\\Models\\Repositories\\SystemObject\\SystemObjectRepository->checkObjectTypeByRefMapDynamicID() #9 /var/www/html/api/app/Http/Controllers/FormsController.php(112): App\\Models\\Repositories\\Element\\ElementRepository->updateElementCache() #10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\FormsController->updateElementCache() #11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api/app/Http/Middleware/JWTCheck.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTCheck->handle() #18 /var/www/html/api/app/Http/Middleware/JWTResponse.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTResponse->handle() #20 /var/www/html/api/app/Http/Middleware/AfterResponseMiddleware.php(11): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AfterResponseMiddleware->handle() #22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #24 /var/www/html/api/app/Http/Middleware/AfterMiddleware.php(17): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AfterMiddleware->handle() #26 /var/www/html/api/app/Http/Middleware/UserActivity.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\UserActivity->handle() #28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #43 /var/www/html/api/app/Http/Middleware/JWTCheck.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTCheck->handle() #45 /var/www/html/api/app/Http/Middleware/Cors.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Cors->handle() #47 /var/www/html/api/app/Http/Middleware/BeforeMiddleware.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\BeforeMiddleware->handle() #49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle() #52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #55 /var/www/html/api/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #56 {main} [previous exception] [object] (PDOException(code: 22018): SQLSTATE[22018]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'null' to data type int. at /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:419) [stacktrace] #0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(419): PDOStatement->execute() #1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run() #4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select() #5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect() #6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns() #8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\\Database\\Query\\Builder->get() #9 /var/www/html/api/app/models/Repositories/systemObject/systemObjectRepository.php(1157): Illuminate\\Database\\Query\\Builder->first() #10 /var/www/html/api/app/models/Repositories/Element/ElementRepository.php(200): App\\Models\\Repositories\\SystemObject\\SystemObjectRepository->checkObjectTypeByRefMapDynamicID() #11 /var/www/html/api/app/Http/Controllers/FormsController.php(112): App\\Models\\Repositories\\Element\\ElementRepository->updateElementCache() #12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\FormsController->updateElementCache() #13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #18 /var/www/html/api/app/Http/Middleware/JWTCheck.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTCheck->handle() #20 /var/www/html/api/app/Http/Middleware/JWTResponse.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTResponse->handle() #22 /var/www/html/api/app/Http/Middleware/AfterResponseMiddleware.php(11): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AfterResponseMiddleware->handle() #24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #26 /var/www/html/api/app/Http/Middleware/AfterMiddleware.php(17): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AfterMiddleware->handle() #28 /var/www/html/api/app/Http/Middleware/UserActivity.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\UserActivity->handle() #30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #45 /var/www/html/api/app/Http/Middleware/JWTCheck.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTCheck->handle() #47 /var/www/html/api/app/Http/Middleware/Cors.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Cors->handle() #49 /var/www/html/api/app/Http/Middleware/BeforeMiddleware.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\BeforeMiddleware->handle() #51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle() #54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #55 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #56 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #57 /var/www/html/api/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #58 {main} "} [2025-05-15 19:46:52] production.ERROR: Exceptions: SQLSTATE[22018]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'null' to data type int. (SQL: select distinct top 1 [so].[label], [oref].[objectable_id], [oref].[sys_systemObjects_id] as [sys_systemObjects_id], [e].[name] as [element_name], [t].[name] as [table_name] from [sys_systemObjects] as [so] inner join [sys_objectReference] as [oref] on [so].[id] = [oref].[sys_systemObjects_id] inner join [sys_referenceMap_dynamic] as [rmd] on [rmd].[sys_form_id] = [oref].[sys_form_id] inner join [sys_element] as [e] on [rmd].[sys_element_id] = [e].[id] inner join [sys_table] as [t] on [rmd].[sys_table_id] = [t].[id] where [rmd].[id] = null) [2025-05-15 19:46:52] production.ERROR: Exceptions Class: Illuminate\Database\QueryException [2025-05-15 19:46:52] production.ERROR: File: /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php [2025-05-15 19:46:52] production.ERROR: Line: 760 [2025-05-15 19:47:23] production.ERROR: BaseRepository getAppVersion() [2025-05-15 19:47:23] production.ERROR: Unable to retrieve the last_modified for file at location: .git/refs/heads/master. [2025-05-15 19:47:27] production.ERROR: CalendarRepository, get() [2025-05-15 19:47:27] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:47:38] production.ERROR: CalendarRepository, get() [2025-05-15 19:47:38] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:47:45] production.ERROR: CalendarRepository, get() [2025-05-15 19:47:45] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:48:06] production.ERROR: CalendarRepository, get() [2025-05-15 19:48:06] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:48:25] production.ERROR: file_key Задължително трябва да бъде избран отговорен дилър преди да се направи импорта на потенциалния клиент!!! does not have a _ and cannot be translated! [2025-05-15 19:48:25] production.ERROR: BaseDocumentRepository, checkSqlError(): errorMsgValidation Error! [2025-05-15 19:48:25] production.ERROR: Document type:56Internal number: 1362 [2025-05-15 19:49:41] production.ERROR: Error in result for executeDependencySql: SELECT p.WorkKind as result FROM state_form_262 s JOIN nmcl_potential_clients p ON p.id = s.id_nmcl_potential_clients WHERE s.internal_number = '1362' AND s.id_user = '87' [2025-05-15 19:49:41] production.ERROR: Error in result for executeDependencySql: SELECT p.ActivityType2_n242 as result FROM state_form_262 s JOIN nmcl_potential_clients p ON p.id = s.id_nmcl_potential_clients WHERE s.internal_number = '1362' AND s.id_user = '87' [2025-05-15 19:49:42] production.ERROR: stripos(): Argument #1 ($haystack) must be of type string, array given {"userId":87,"exception":"[object] (TypeError(code: 0): stripos(): Argument #1 ($haystack) must be of type string, array given at /var/www/html/api/app/models/Repositories/Element/ElementRepository.php:1123) [stacktrace] #0 /var/www/html/api/app/models/Repositories/Element/ElementRepository.php(1123): stripos() #1 /var/www/html/api/app/Http/Controllers/FormsController.php(133): App\\Models\\Repositories\\Element\\ElementRepository->getElementDependencies() #2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\FormsController->updateElementCache() #3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #8 /var/www/html/api/app/Http/Middleware/JWTCheck.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTCheck->handle() #10 /var/www/html/api/app/Http/Middleware/JWTResponse.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTResponse->handle() #12 /var/www/html/api/app/Http/Middleware/AfterResponseMiddleware.php(11): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AfterResponseMiddleware->handle() #14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #16 /var/www/html/api/app/Http/Middleware/AfterMiddleware.php(17): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AfterMiddleware->handle() #18 /var/www/html/api/app/Http/Middleware/UserActivity.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\UserActivity->handle() #20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #35 /var/www/html/api/app/Http/Middleware/JWTCheck.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\JWTCheck->handle() #37 /var/www/html/api/app/Http/Middleware/Cors.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Cors->handle() #39 /var/www/html/api/app/Http/Middleware/BeforeMiddleware.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\BeforeMiddleware->handle() #41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle() #44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #47 /var/www/html/api/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #48 {main} "} [2025-05-15 19:49:42] production.ERROR: Exceptions: stripos(): Argument #1 ($haystack) must be of type string, array given [2025-05-15 19:49:42] production.ERROR: Exceptions Class: TypeError [2025-05-15 19:49:42] production.ERROR: File: /var/www/html/api/app/models/Repositories/Element/ElementRepository.php [2025-05-15 19:49:42] production.ERROR: Line: 1123 [2025-05-15 19:49:48] production.ERROR: file_key В номенклатура Фирмени данни в ЕРП съществува Фирма с този данъчен номер!!! does not have a _ and cannot be translated! [2025-05-15 19:49:48] production.ERROR: BaseDocumentRepository, checkSqlError(): errorMsgValidation Error! [2025-05-15 19:49:48] production.ERROR: Document type:56Internal number: 1362 [2025-05-15 19:49:52] production.ERROR: BaseRepository getAppVersion() [2025-05-15 19:49:52] production.ERROR: Unable to retrieve the last_modified for file at location: .git/refs/heads/master. [2025-05-15 19:49:56] production.ERROR: CalendarRepository, get() [2025-05-15 19:49:56] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:52:23] production.ERROR: BaseRepository getAppVersion() [2025-05-15 19:52:23] production.ERROR: Unable to retrieve the last_modified for file at location: .git/refs/heads/master. [2025-05-15 19:52:36] production.ERROR: CalendarRepository, get() [2025-05-15 19:52:36] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 19:52:40] production.ERROR: BaseRepository getAppVersion() [2025-05-15 19:52:40] production.ERROR: Unable to retrieve the last_modified for file at location: .git/refs/heads/master. [2025-05-15 19:52:45] production.ERROR: CalendarRepository, get() [2025-05-15 19:52:45] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:10:44] production.ERROR: CalendarRepository, get() [2025-05-15 22:10:44] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:12:04] production.ERROR: CalendarRepository, get() [2025-05-15 22:12:04] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:13:05] production.ERROR: CalendarRepository, get() [2025-05-15 22:13:05] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:16:45] production.ERROR: CalendarRepository, get() [2025-05-15 22:16:45] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:17:44] production.ERROR: CalendarRepository, get() [2025-05-15 22:17:44] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:18:44] production.ERROR: CalendarRepository, get() [2025-05-15 22:18:44] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:19:45] production.ERROR: CalendarRepository, get() [2025-05-15 22:19:45] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:20:44] production.ERROR: CalendarRepository, get() [2025-05-15 22:20:44] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:22:36] production.ERROR: CalendarRepository, get() [2025-05-15 22:22:36] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:23:37] production.ERROR: CalendarRepository, get() [2025-05-15 22:23:37] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 22:29:25] production.ERROR: CalendarRepository, get() [2025-05-15 22:29:25] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000) [2025-05-15 23:27:49] production.ERROR: CalendarRepository, get() [2025-05-15 23:27:49] production.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'calendar_start_date'. (SQL: select * from [sys_stitle] as [t] inner join [sys_stitle_54] as [tu] on [t].[id] = [tu].[id_sys_stitle] where [t].[id_doctype] = 54 and [t].[active] = 1 and [t].[is_deleted] = 0 and isnull(t.is_annul, 0) = 0 and [calendar_start_date] >= 2025-04-28 00:00:00.000 and [calendar_end_date] <= 2025-06-09 00:00:00.000)