Woah... Call center vanished?

Discussion in 'General' started by BillyParadise, Dec 23, 2010.

  1. BillyParadise

    Joined:
    Dec 23, 2010
    Messages:
    4
    Likes Received:
    0
    I was trying to demo the Call center part of Elastix to a coworker.

    When I went to insert an agent, This error came up:

    Error when trying to insert an agent. Query Error: INSERT INTO agent (number, name, password) VALUES ('2198', 'Rob TEst', '2198') - Array ( [0] => 42S02 [1] => 1146 [2] => Table 'call_center.agent' doesn't exist )

    I thought perhaps this was because the elastixdialer service was not on, but I checked, and resarted elastixdialer, and it still gave the same error.

    I would _REALLY_ prefer not to reinstall elastix on this box as it's on the other side of the world and my onsite technical staff isn't all that technical

    Here's hoping someone can help.

    Cheers
    Billy
     
  2. BillyParadise

    Joined:
    Dec 23, 2010
    Messages:
    4
    Likes Received:
    0
    Also - under addons, it shows call centre version 2.0.0 as installed.

    Thanks
     
  3. BillyParadise

    Joined:
    Dec 23, 2010
    Messages:
    4
    Likes Received:
    0
    I deinstalled and reinstalled the call centre app.

    I noticed this error on the console:
    # PHP Fatal error: require_once(): Failed opening required 'DialerProcess.class.php' (include_path='/opt/elastix/dialer:.:/usr/share/pear:/usr/share/php') in /opt/elastix/dialer/dialerd on line 335

    I get the same error (no table). Call centre 2.0.0 rev 12 shows as installed.

    This sucks :(
     
  4. BillyParadise

    Joined:
    Dec 23, 2010
    Messages:
    4
    Likes Received:
    0
    So, here's how you fix it.

    Delete Call center from within Elastix
    from MySQL, drop database call_center;
    Reinstall Call Center from within Elastix
    Delete all broken agents.

    Sucks, but at least it is working now. Let's hope it doesn't happen again.
     
  5. alejandro2013

    Joined:
    Aug 9, 2011
    Messages:
    16
    Likes Received:
    0
    excellent fix the problem thank you very much for your input.
     

Share This Page