Showstopper in 2.210.62-5 unable to create outbound route

General Help
1

I’ve just done a clean install of FreePBX distro 2.210.62-5, I’ve added a couply of Polycom IP321s using the OSS PBX Endpoint Manager, added an IAX trunk, defined a DAHDI DID, then I tried to create an outbound route.

I get the following error:

FATAL ERROR

INSERT INTO pinset_usage (pinsets_id, dispname, foreign_id) VALUES (None, ‘routing’, ‘’) [nativecode=1054 ** Unknown column ‘None’ in ‘field list’]SQL -
INSERT INTO pinset_usage (pinsets_id, dispname, foreign_id) VALUES (None, ‘routing’, ‘’)

Trace Back
/var/www/html/admin/libraries/sql.functions.php:11 die_freepbx()
[0]: INSERT INTO pinset_usage (pinsets_id, dispname, foreign_id) VALUES (None, ‘routing’, ‘’) [nativecode=1054 ** Unknown column ‘None’ in ‘field list’]SQL -
INSERT INTO pinset_usage (pinsets_id, dispname, foreign_id) VALUES (None, ‘routing’, ‘’)

/var/www/html/admin/modules/pinsets/functions.inc.php:199 sql()
[0]: INSERT INTO pinset_usage (pinsets_id, dispname, foreign_id) VALUES (None, ‘routing’, ‘’)

/var/www/html/admin/modules/pinsets/functions.inc.php:278 pinsets_adjustroute()
[0]:
[1]: delayed_insert_route
[2]: None

/var/www/html/admin/libraries/moduleHook.class.php:43 pinsets_hookProcess_core()
[0]:
[1]:

/var/www/html/admin/config.php:307 moduleHook->process_hooks()
[0]:
[1]: core
[2]: routing
[3]:

I’m very concerned to be getting such a major problem so early on in what is supposed to be a stable release, having done almost nothing to the configuration. During install, I selected the ‘No RAID’ option and ‘Asterisk 10’.

Anyone else seeing this? Should I be opening a bug report or does anyone have this release installed and working correctly?

–Tim

2

I’ve just reproduced this issue on a clean install. Here are the steps to reproduce:

  1. Install from DVD, pick option “Install” with Asterisk 10 (4th option on the screen).
  2. Complete installation through end of 1st boot script, to login prompt.
  3. Connect via web interface, set admin username and password.
  4. Log in to admin web interface.
  5. Go to Connectivity/Outbound routes
  6. Create an outbound route (my system has a TDM400 so there is already a Zap/g0 trunk to send the route to).
  7. Click submit - boom. SQL error.

I think I’m going to raise a bug report for this.
–T

3

I can not reproduce this can anyone else. Also this code has not changed in 2.10 for over a year now. Its got to be something else causing it but like I said I can not reproduce it.

4
I've added a couply of Polycom IP321s using the OSS PBX Endpoint Manager,
I tried to do the same thing but got this error Downloading Brand JSON.....Done! Downloading Brand Package... Done! Can't Find Downloaded File! any tips?