Cannot delete some ring groups

VitalPBX Community Support General Discussion Cannot delete some ring groups

  • Post
    pftech-pf
    Participant
    Hello there,

    I want to delete an old not utilized ring group, but when I go to delete it, I got this error message:

    This item is being used as destination by the <b>Time Conditions</b> module

    Obviously under “Time Conditions” module there is no entry! It’s empty!

    How can I delete that ring group manually, maybe from command line?

    Best regards,

    Paolo

    0
Viewing 6 replies - 1 through 6 (of 6 total)
  • Replies
    Up
    0
    Down
    It what version did happen?
    0
    pftech-pf
    Participant
    Up
    0
    Down
    Latest:

    VitalPBX 2.4.2-1

    0
    Up
    0
    Down
    I suppose you created a time condition pointing to that ring group some time ago, right? Maybe there was an issue with that specific version.

    You may try this:

    select d.id  from ombu_destinations as d
    left join ombu_destinations_category odc on d.category_id = odc.id
    where odc.module_id = (select module_id from ombu_modules where name = 'ring_group')
    and d.module_id = (select module_id from ombu_modules where name = 'time_conditions')
    and d.index = (select ring_group_id from ombu_ring_groups where extension = '100');

    The script above will return you the destination IDs associated with the ring group 100, so, now that you have the ID, you only need to delete the item:

    delete from ombu_destinations where id = ?

    The ID will be the value or values returned by the first query.

    1
    pftech-pf
    Participant
    Up
    0
    Down
    Thanks but, what’s the name of the database that I should connect to through mariadb ?

    I guess I should run that script through mariadb console right?

    Best regards

    0
    Up
    0
    Down
    The database name is ombutel. And yes, you need to run this on MySQL console.
    1
    pftech-pf
    Participant
    Up
    0
    Down
    Thanks a lot… after some weeks that I was very busy, I’ve finally tried this and it worked perfectly!

     

    Regards,

    Paolo

    0
Viewing 6 replies - 1 through 6 (of 6 total)

Tagged: ,

  • The topic ‘Cannot delete some ring groups’ is closed to new replies.