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
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
queXS
Fix Released
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)
Changed in quexs:
status: Confirmed → Fix Committed
Adam Zammit (adamzammit)
Changed in quexs:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.