Disregard the statement I made about the select statement. This is where you're checking for duplicates. But I do notice the regex is not present here either.
Thanks Jeff Wilkie USIP Communications On Aug 24, 2016 6:22 PM, "Jeff Wilkie" <jwil...@usipcom.com> wrote: > 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 <jwil...@usipcom.com> 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 <bog...@opensips.org >> > 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 < >>> bog...@opensips.org> 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 < >>>> bog...@opensips.org> 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 >>>>> listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>> >>>>> >> >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users