Ticket #5571 (closed Bugs: fixed)

Opened 3 months ago

Last modified 3 months ago

$extDisplay undefined; Can't add any Devices - causes SQL error (EndPoint Manager 2.10.3.2)

Reported by: jock.mckechnie Assigned to: tm1000
Priority: crash Milestone: Undetermined
Component: Endpoint Manager Version: 2.9-branch
Keywords: endpointmanager sql endpointman_line_list extDisplay Cc:
Confirmation: Unreviewed SVN Revision (if applicable):
Backend Engine: All Backend Engine Version:

Description (Last modified by tm1000)

This appears to be a continuation of ticket #5486, http://www.freepbx.org/trac/ticket/5486.

When trying to add a device I get a lovely PHP error dump with the following in bold at the top: 

FATAL SQL ERROR! ::::: SELECT * FROM endpointman_line_list WHERE ext = AND mac_id = 1 [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 'AND mac_id = 1' at line 1]SQL -

Following the instructions in 5438 I updated to 2.10.2.4, in which the issue remained. I then pulled the latest bleeding edge available, 2.10.3.4, which also appears to have it. I'm marking this as major, if you'll forgive the impertinence, since it's a complete show-stopper on our system - we have no way to add new devices right now.

I've attached the full spew dump of the output, just in case there's something important in there to add to this case.

Thank you muchly;

  • Jock

Attachments

dump.txt (151.1 kB) - added by jock.mckechnie on 02/10/12 11:33:57.
Complete error dump

Change History

02/10/12 11:33:57 changed by jock.mckechnie

  • attachment dump.txt added.

Complete error dump

02/10/12 11:35:31 changed by tm1000

  • status changed from new to closed.
  • resolution set to invalid.

The fix is actually here: http://www.the159.com/endpointman/endpointman-2.10.3.2.tgz

02/10/12 11:36:44 changed by tm1000

Furthermore there is no '2.10.3.4'. Not sure where you tried to get that from?

02/10/12 11:44:37 changed by jock.mckechnie

My apologies, typo - although I did get it right in the subject line.

I /am/ running 2.10.3.2. I pulled it this morning from the159.com.

This is _not_ fixed. What can I do to help?

  • JP

02/10/12 11:45:28 changed by tm1000

  • status changed from closed to reopened.
  • confirmation changed from Unreviewed to Pending.
  • resolution deleted.

Uninstall and reinstall endpoint manager and re-check please.

02/10/12 11:50:40 changed by jock.mckechnie

Well I'll be buggered. That seems to have done it. I wasn't expecting that.

I'll make sure to remember, should I see a similar thing in the future.

Thank you very much for your extremely timely responses;

  • Jock

02/10/12 11:53:43 changed by tm1000

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

It appears to sometimes be a transient issue from the previous error where half the data is in the database, which then ends up causing the same error.

Feel free to open another bug request if you have more issues with this or anything else (but of course re-open this one if it relates to this, you should be able to do that)

Duplicate of #5438

02/10/12 11:54:28 changed by tm1000

  • description changed.

Opps. #5486

02/14/12 14:21:46 changed by jock.mckechnie

Greetings;

Unfortunately this bug is still present, however now it only appears when you are attempting to configure an additional line on an existing Device. So I'll create the first Device entry, for Line 1 (default), submit and reload. I will subsequently create a second Device entry for the same MAC address for Line 2, and will get: 

FATAL SQL ERROR! ::::: SELECT * FROM endpointman_line_list WHERE ext = AND mac_id = 3 [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 'AND mac_id = 3' at line 1]SQL

I have also noticed another oddity, but this may be related to FreePBX rather than the EPM. When creating a Device I put in the MAC address/phone type/line # settings and submit. These settings are not saved, and so when it refreshes they're blank. If I EDIT the Device and put these in and Submit they finally "stick". I'm running FreePBX 2.9.0.4 and the aforementioned EPM 2.10.3.2.

On the off chance it would help I uninstalled and reinstalled EPM, but this does not allow me to create further lines (grasping at straws, but hey, it worked last time).

Thank you very much for your help, do let me know if I can supply any information to help debugging.

  • Jock

02/14/12 14:39:25 changed by tm1000

  • priority changed from major to crash.
  • status changed from closed to reopened.
  • confirmation changed from Pending to Unreviewed.
  • resolution deleted.

ok

02/16/12 00:10:36 changed by tm1000

I'm sorry jock. I'm unable to reproduce this error at all. I don't know what else to do for you.

02/16/12 12:41:11 changed by jock.mckechnie

I've been fiddling about and it's 100% repeatable for me, so far. Any phone, any line from 2-6. Given this is still a dev system for us (although we're supposed to be migrating to it in the very near future) I could allow you access to the system to see it first-hand. Would this be of use, or would you prefer not to be delving into people's equipment?

If you were amenable, how would I securely provide you address and credential details?

  • Jock

02/16/12 12:42:34 changed by tm1000

email me andrew.nagy (at) the159.com

02/22/12 23:43:29 changed by tm1000

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

Fixed http://www.the159.com/endpointman/endpointman-2.10.3.3.tgz