Here is what it looks like to my db when I create a DialPlan 20 Query SELECT * FROM dialplan WHERE dpid=36 AND match_exp='877'
20 Query PREPARE MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74 FROM 'INSERT INTO dialplan\n (dpid, pr, match_op, match_exp, match_flags, subst_exp, \n repl_exp, attrs) VALUES \n (36, 0,1, \'877\',0,\'\',\'\',\'.30\')' 20 Prepare INSERT INTO dialplan (dpid, pr, match_op, match_exp, match_flags, subst_exp, repl_exp, attrs) VALUES (36, 0,1, '877',0,'','','.30') 20 Query EXECUTE MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74 20 Execute INSERT INTO dialplan (dpid, pr, match_op, match_exp, match_flags, subst_exp, repl_exp, attrs) VALUES (36, 0,1, '877',0,'','','.30') This is what happens when I edit that same DialPlan 23 Query select * from dialplan where id='9030' 23 Quit 24 Query SELECT * FROM dialplan WHERE dpid=36 AND match_exp='' AND id!=9030 24 Query PREPARE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2 FROM 'UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp =\'\', match_flags=0, subst_exp = \'\', repl_exp=\'\', attrs= \'.30\' WHERE id=9030' 24 Prepare UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp ='', match_flags=0, subst_exp = '', repl_exp='', attrs= '.30' WHERE id=9030 24 Query EXECUTE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2 24 Execute UPDATE dialplan SET dpid=36, pr = 0, match_op= 1, match_exp ='', match_flags=0, subst_exp = '', repl_exp='', attrs= '.30' WHERE id=9030 24 Query DEALLOCATE PREPARE MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2 24 Quit You can see that the container for match_ex is not getting passed to the '24' SELECT statement which ends in a 0 results query apparently. Thanks Jeff On Wed, Aug 24, 2016 at 5:30 PM, Jeff Wilkie <[email protected]> wrote: > Yes. After any edits followed by a save with the attribute field active > as text causes "Matching Regular Expression" to be deleted. > > Thanks > > Jeff > > On Wed, Aug 24, 2016 at 5:15 PM, Bogdan-Andrei Iancu <[email protected]> > wrote: > >> Jeff, >> >> You mean "Matching Regular Expression", right ? upon performing an edit + >> save where you only changed the attrs, the "Matching Regular Expression" >> gets to empty ? >> >> Regards, >> >> Bogdan-Andrei Iancu >> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com >> >> On 24.08.2016 23:25, Jeff Wilkie wrote: >> >> Ok. The value now displays but if you modify the value and hit save, it >> kills the regex value upon saving. Also, you cannot add the regex value >> back into the row. All other values appear to be kept. >> >> Thanks >> >> Jeff >> >> On Wed, Aug 24, 2016 at 11:35 AM, Bogdan-Andrei Iancu < >> [email protected]> wrote: >> >>> Hi Jeff, >>> >>> I spotted the issue and fixed it on GIT repo. Please give it a try and >>> let me know if it works for you too. >>> >>> Thanks and regards, >>> >>> Bogdan-Andrei Iancu >>> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com >>> >>> On 24.08.2016 17:46, Jeff Wilkie wrote: >>> >>> Yes, The text box is there but when you place a value in a preexisting >>> dial plan, the result in the DB is just the value in the text attribute >>> field with no dial plan information. By editing or adding an attribute it >>> kills the rest of the dial plan that you were editing and you cannot add >>> the dial plan information back in via the CP as long as an attribute in >>> text form is added. The same does not happen if using check box. I can >>> provide pics if you'd like. The only var changed is the >>> >>> $dialplan_attributes_mode = 1 >>> >>> Jeff Wilkie >>> Chief Technology Officer >>> US IP Communications 919.297.1057 *"This e-mail communication and any >>> attachments may contain confidential and privileged information and is for >>> use by the designated addressee(s) named above only. Any files transmitted >>> with it are confidential and intended solely for the use of the individual >>> to whom it is addressed. Any views or opinions presented are solely those >>> of the author and do not necessarily represent those of USIPCOM, LLC. If >>> you are not the intended addressee, you are hereby notified that you have >>> received this communication in error and that any use or reproduction of >>> this email or its contents is strictly prohibited and may be unlawful. If >>> you have received this communication in error, please notify us immediately >>> by replying to this message and deleting it from your computer. Thank you". >>> * >>> On Wed, Aug 24, 2016 at 5:20 AM, Bogdan-Andrei Iancu < >>> [email protected]> wrote: >>>> >>>> Hi Jeff, You mean you do not get the Attributes text area at all in the >>>> Edit section ? Regards, >>>> >>>> Bogdan-Andrei Iancu >>>> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com >>>> >>>> On 23.08.2016 00:56, Jeff Wilkie wrote: >>>> >>>> New small issue with DIALPLAN in the CP. Running OSIPS 1.10 with CP 5.0 >>>> It appears that when modifying the CP for Dialplan attributes as text, >>>> they do not appear in the edit section once applied. The attributes do >>>> show up in the view list of dial plans but if you go back to edit the attrs >>>> again, they are not there. I dot not have the same problem when using >>>> attrs as checkboxes. Is there more code in the local files that require >>>> editing to display these values? Also, if an entry in the Dialplan was >>>> once a checkbox value but I've not converted the mode to text, the value >>>> does not show up in the text box to be edited. >>>> >>>> # Attention : advanced options !! >>>> >>>> //database tables >>>> >>>> $config->table_dialplan = "dialplan"; >>>> >>>> $config->results_per_page = 20; >>>> >>>> $config->results_page_range = 5; >>>> >>>> $config->attrs_cb=array( >>>> >>>> // name , description >>>> >>>> array("a","Descr a"), >>>> >>>> array("b","Descr b"), >>>> >>>> array("c","Descr c"), >>>> >>>> array("d","Descr d"), >>>> >>>> array("e","Descr e"), >>>> >>>> array("f","Descr f"), >>>> >>>> ); >>>> >>>> $config->cb_per_row = 3; >>>> >>>> $talk_to_this_assoc_id = 1 ; >>>> >>>> // Dialplan - Add/Edit new Translation Rule - Attributes input type >>>> >>>> // 0 - checkboxes >>>> >>>> // 1 - text >>>> >>>> $dialplan_attributes_mode = 1 ; >>>> >>>> ?> >>>> Jeff >>>> >>>> _______________________________________________ >>>> Users mailing >>>> [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>>> >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
