Query Error 1054: Unknown column 'c.status_bg_color' in 'field list'
Query: SELECT e.*, c.name calendar_name, c.status_bg_color, c.status_font_color, c.bg_color, c.font_color, c.icon
FROM wa_contact_events e
INNER JOIN wa_contact_calendars c ON c.id=e.calendar_id
WHERE e.contact_id IN('171','3383','7081','7629','7636','7637','7644','7667','7741','7742') AND is_status=1 AND
((is_allday = 0 AND e.start <= '2021-11-18 19:11:55' AND e.end >= '2021-11-18 19:11:55')
OR (is_allday = 1 AND DATE(e.start) <= DATE('2021-11-18 19:11:55') AND DATE(e.end) >= DATE('2021-11-18 19:11:55')))
ORDER BY is_allday DESC, start ASC code 1054
## wa-system/database/waModel.class.php(266) #0 wa-system/database/waModel.class.php(367): waModel->run('SELECT e.*, c.n...') #1 wa-system/webasyst/lib/models/waContactEvents.model.php(68): waModel->query('SELECT e.*, c.n...') #2 wa-system/contact/waContactsCollection.class.php(368): waContactEventsModel->getEventByContact(Array) #3 wa-apps/crm/lib/actions/crmSidebar.action.php(104): waContactsCollection->getContacts(Array) #4 wa-apps/crm/lib/actions/crmSidebar.action.php(49): crmSidebarAction->getRecent() #5 wa-apps/crm/lib/actions/crmSidebar.action.php(7): crmSidebarAction->sidebar() #6 wa-system/controller/waViewAction.class.php(188): crmSidebarAction->execute() #7 wa-system/layout/waLayout.class.php(79): waViewAction->display() #8 wa-apps/crm/lib/layouts/crmDefault.layout.php(6): waLayout->executeAction('sidebar', Object(crmSidebarAction)) #9 wa-system/layout/waLayout.class.php(148): crmDefaultLayout->execute() #10 wa-system/controller/waViewController.class.php(104): waLayout->display() #11 wa-system/controller/waViewController.class.php(47): waViewController->display() #12 wa-system/controller/waFrontController.class.php(263): waViewController->run(NULL) #13 wa-apps/crm/lib/classes/crmFrontController.class.php(49): waFrontController->runController(Object(crmMessageController), NULL) #14 wa-system/controller/waFrontController.class.php(190): crmFrontController->runController(Object(crmMessageController), NULL) #15 wa-system/controller/waFrontController.class.php(84): waFrontController->execute(NULL, 'message', '') #16 wa-apps/crm/lib/classes/crmFrontController.class.php(29): waFrontController->dispatch() #17 wa-system/controller/waDispatch.class.php(162): crmFrontController->dispatch() #18 wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/crm/me...') #19 wa-system/waSystem.class.php(610): waDispatch->dispatch() #20 index.php(7): waSystem->dispatch() #21 {main}
Params
[ 'app' => 'crm', 'module' => 'message', 'action' => '', 'is_backend_route' => true, ]
4 комментария
В логах:
2021-11-18 14:10:37 176.59.211.37 webasyst/crm/message/ Uncaught exception waDbException: Database error. See log for details. (1054) ## wa-system/database/waModel.class.php(266) #0 wa-system/database/waModel.class.php(367): waModel->run('SELECT e.*, c.n...') #1 wa-system/webasyst/lib/models/waContactEvents.model.php(68): waModel->query('SELECT e.*, c.n...') #2 wa-system/contact/waContactsCollection.class.php(368): waContactEventsModel->getEventByContact(Array) #3 wa-apps/crm/lib/actions/crmSidebar.action.php(104): waContactsCollection->getContacts(Array) #4 wa-apps/crm/lib/actions/crmSidebar.action.php(49): crmSidebarAction->getRecent() #5 wa-apps/crm/lib/actions/crmSidebar.action.php(7): crmSidebarAction->sidebar() #6 wa-system/controller/waViewAction.class.php(188): crmSidebarAction->execute() #7 wa-system/layout/waLayout.class.php(79): waViewAction->display() #8 wa-apps/crm/lib/layouts/crmDefault.layout.php(6): waLayout->executeAction('sidebar', Object(crmSidebarAction)) #9 wa-system/layout/waLayout.class.php(148): crmDefaultLayout->execute() #10 wa-system/controller/waViewController.class.php(104): waLayout->display() #11 wa-system/controller/waViewController.class.php(47): waViewController->display() #12 wa-system/controller/waFrontController.class.php(263): waViewController->run(NULL) #13 wa-apps/crm/lib/classes/crmFrontController.class.php(49): waFrontController->runController(Object(crmMessageController), NULL) #14 wa-system/controller/waFrontController.class.php(190): crmFrontController->runController(Object(crmMessageController), NULL) #15 wa-system/controller/waFrontController.class.php(84): waFrontController->execute(NULL, 'message', '') #16 wa-apps/crm/lib/classes/crmFrontController.class.php(29): waFrontController->dispatch() #17 wa-system/controller/waDispatch.class.php(162): crmFrontController->dispatch() #18 wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/crm/me...') #19 wa-system/waSystem.class.php(610): waDispatch->dispatch() #20 index.php(7): waSystem->dispatch() #21 {main}Такая же ошибка при заходе в приложение КОМАНДА и Частично в приложении СТАТУС
Спасибо, подождем исправления.
оперативно исправили ещё одним обновлением, спасибо