Ticket #5486 (closed Bugs: fixed)

Opened 5 months ago

Last modified 4 months ago

$extDisplay not set in Endpoint Manager 2.10 with FreePBX 2.10 in users/devices mode

Reported by: andreas.modulis Assigned to: tm1000
Priority: crash Milestone: Undetermined
Component: Endpoint Manager Version: 2.10-branch
Keywords: Cc:
Confirmation: Confirmed SVN Revision (if applicable):
Backend Engine: All Backend Engine Version:

Description (Last modified by tm1000)

Mode is set to users/devices. When we try to add a device, we get an error because $extDisplay is not set at the relevant place (it's empty, thus resulting in a broken query). Uninstalling the endpoint manager module solves the problem. Perhaps, you will just simply have to make it an "else if(!empty($extDisplay))" instead of an "else".

This is the relevant line of the error message:

SELECT mac_id,luid FROM endpointman_line_list WHERE ext =  [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]SQL -

Error occurs here (admin/modules/endpointman/functions.inc.php, line 154):

} else {
                    //Mac not set so delete
                    $sql = "SELECT mac_id,luid FROM endpointman_line_list WHERE ext = ". $extdisplay;
                    $macid = $endpoint->eda->sql($sql,'getRow',DB_FETCHMODE_ASSOC);
                    if($macid) {
                        //$endpoint->delete_line($macid['luid'], TRUE);
                    }
                }

Change History

01/06/12 02:47:11 changed by tm1000

  • status changed from new to assigned.
  • confirmation changed from Unreviewed to Need Feedback.

01/18/12 23:22:40 changed by mike-329500

I'm running 2.10.2.3 and I am having the same problem.

Mike

01/20/12 05:03:50 changed by tm1000

  • priority changed from minor to crash.
  • confirmation changed from Need Feedback to Confirmed.

Thanks Mike.

01/20/12 05:04:57 changed by tm1000

  • description changed.

01/30/12 12:55:32 changed by tm1000

  • status changed from assigned to closed.
  • resolution set to fixed.

(In [13276]) Bring Endpoint Manager version up to 2.10.2.4. Fixes #5486