После обновления платформы 18.11 ошибка при заходе в CRM: Query Error 1054: Unknown column 'c.status_bg_color' in 'field list' Исправлено

1

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(&#039;SELECT e.*, c.n...&#039;) #1 wa-system/webasyst/lib/models/waContactEvents.model.php(68): waModel->query(&#039;SELECT e.*, c.n...&#039;) #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(&#039;sidebar&#039;, 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, &#039;message&#039;, &#039;&#039;) #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(&#039;webasyst/crm/me...&#039;) #19 wa-system/waSystem.class.php(610): waDispatch->dispatch() #20 index.php(7): waSystem->dispatch() #21 {main}
GET
[]
Params
[  &#039;app&#039; => &#039;crm&#039;,  &#039;module&#039; => &#039;message&#039;,  &#039;action&#039; => &#039;&#039;,  &#039;is_backend_route&#039; => true, ]

4 комментария

  • +1
    Сергей Правдин Сергей Правдин 18 ноября 2021 17:16 #

    В логах:

    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}

  • +1
    Сергей Правдин Сергей Правдин 18 ноября 2021 17:20 #

    Такая же ошибка при заходе в приложение КОМАНДА и Частично в приложении СТАТУС

  • +2

    Спасибо, подождем исправления.

  • +1
    Сергей Правдин Сергей Правдин 18 ноября 2021 18:40 #

    оперативно исправили ещё одним обновлением, спасибо

    Добавить комментарий

    Чтобы добавить комментарий, зарегистрируйтесь или войдите