Changes using database query but it wont apply in UI

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Changes using database query but it wont apply in UI

Postby richmac2018 » Wed Jan 02, 2019 6:31 am

Hi All,

Anybody know what Am I lacking on this? I tried to update the DID value using directly to database but after the query it wont applied in UI and I cant see the changes.

mysql query: update vicidial_inbound_dids SET did_route = 'VOICEMAIL' where did_pattern like '613911100%';

After the command I updated the Generate conf files and Rebuild conf files to Y but it still wont apply in UI

Image

Result in UI that still not in VOICEMAIL value

Image
richmac2018
 
Posts: 36
Joined: Wed Jan 17, 2018 10:47 am

Re: Changes using database query but it wont apply in UI

Postby williamconley » Tue Jan 08, 2019 3:40 pm

1) Welcome to the Party! 8-)

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method (7.X.X?) and vicidial version with build (VERSION: 2.X-XXXx ... BUILD: #####-####).

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "manual/from scratch" you must post your operating system with version (and the .iso version from which you installed your original operating system) plus a link to the installation instructions you used. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) This feature has zero realation to generated conf file/rebuilt conf files.

4) Verify that the values were actually changed in mysql before verifying in the GUI.

5) Often already open pages with dropdown values do not update when you refresh the page for various reasons.

6) AFTER verifying that the value did update in the DB to the desired value: If the value in the GUI does not update upon refresh: Close the page or surf to another page and then surf to it again (without the back button).
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 25 guests