When no operators have an extension assigned, questionnaires in test mode fail to create phone numbers for new cases

Bug #1459935 reported by Adam Zammit on 2015-05-29
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
queXS
High
Adam Zammit

Bug Description

When no operators have an extension assigned, questionnaires in test mode fail to create phone numbers for new cases

See: functions/functions.operator.php

function add_case

    $sql = "INSERT INTO contact_phone (case_id,priority,phone,description)
      SELECT $case_id as case_id,@row := @row + 1 AS priority,SUBSTRING_INDEX(e.extension,'/',-1) as phone, CONCAT(o.firstName, ' ', o.lastName)
      FROM operator as o, `extension` as e
      WHERE o.enabled = 1
      AND e.current_operator_id = o.operator_id";

    $db->Execute($sql);

- this should be updated to allow adding dummy extensions where don't exist (left join)

Related branches

Adam Zammit (adamzammit) on 2015-06-02
Changed in quexs:
status: Confirmed → Fix Committed
Adam Zammit (adamzammit) on 2015-06-02
Changed in quexs:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers