upgrade to 1.2 and agenda not working

Discussion in 'General' started by telecomtechnician, Sep 16, 2008.

  1. telecomtechnician

    Joined:
    Jan 8, 2008
    Messages:
    422
    Likes Received:
    0
    Hi there, I upgrade elastix to 1.2 and the agenda is not working, it gives the following error:Validation Error
    Error processing event
    Query Error: INSERT INTO events (uid, startdate, enddate, starttime, subject, description, eventtype, asterisk_call, recording, call_to) VALUES ('1', strftime('%Y-%m-%d', '2008-09-15 23:00:00'), strftime('%Y-%m-%d', '2008-09-15'),strftime('%Y-%m-%d %H:%M:%S', '2008-09-15 23:00:00'), 'prueba ','prueba de agenda', '1', 'off', 'calendarEvent', '300')


    This appears in the upper part where you configure the event

    Waiting for your comments

    David Medina
     
  2. danardf

    Joined:
    Dec 3, 2007
    Messages:
    8,069
    Likes Received:
    12
    Hi.

    I the same problem.

    I look this problem.
     
  3. bmacias

    Joined:
    Sep 27, 2007
    Messages:
    205
    Likes Received:
    0
    Hello everybody:

    This is accepted as a bug, I add this track in our manager task (gforge).
    Thank for you post.
     
  4. danardf

    Joined:
    Dec 3, 2007
    Messages:
    8,069
    Likes Received:
    12
    ok, i see.

    There isn't call_to column
    Add the column like this:

    • sqlite3 /var/www/db/calendar.db "ALTER TABLE events ADD call_to varchar(20);"


    I don't know if is the good format "varchar(20)" but it's work fine. :p

    Yessssss. I love me :woohoo:
     
  5. telecomtechnician

    Joined:
    Jan 8, 2008
    Messages:
    422
    Likes Received:
    0
    Hi Danardf

    Can you explain in which file should I put the line, and does it really solve the problem?,

    David Medina
     
  6. danardf

    Joined:
    Dec 3, 2007
    Messages:
    8,069
    Likes Received:
    12
    It's the command line
    at prompt write:
    >sqlite3 /var/www/db/calendar.db "ALTER TABLE events ADD call_to varchar(20);"
    >


    Otherwrise, you can do like that:

    >sqlite /var/www/db/calendar.db
    >ALTER TABLE events ADD call_to varchar(20);
    >.exit

    Yes, i make a test. It's good.
     
  7. DaveD

    Joined:
    Nov 12, 2007
    Messages:
    597
    Likes Received:
    0
    Thankyou for this fix it works great
     
  8. rafael

    Joined:
    May 14, 2007
    Messages:
    1,454
    Likes Received:
    1
    Thanks franck, I increase your karma in one again ;).

    Saludos,

    Rafael
     
  9. danardf

    Joined:
    Dec 3, 2007
    Messages:
    8,069
    Likes Received:
    12
    Thanks a lot Rafael. :)
     
  10. diogo

    Joined:
    Sep 3, 2008
    Messages:
    6
    Likes Received:
    0
    Hi... I have a similar problem ... when I try to save a campaign in the call center module, an error happens: "Query Error: INSERT INTO calls (id_campaign, phone, status, dnc) VALUES (69, '02134327915', NULL, '0')INSERT INTO calls (id_campaign, phone, status, dnc) VALUES (69, '02134327915', NULL, '0')... can you help me too ?

    Thanks....

    Diogo Santos
     
  11. danardf

    Joined:
    Dec 3, 2007
    Messages:
    8,069
    Likes Received:
    12
    ok.

    We try it. :S

    Connect on your Elastix server with SSH tool: (putty for exemple)

    on prompt, connect into the database:
    Code:
    >mysql -u root -peLaStIx.2oo7
    
    mysql>connect call_center;
    mysql>show tables;
    
    
    +-----------------------+
    | Tables_in_call_center |
    +-----------------------+
    | agent                 |
    | audit                 |
    | break                 |
    | call_attribute        |
    | call_entry            |
    | calls                 |
    | campaign              |
    | campaign_form         |
    | contact               |
    | current_call_entry    |
    | current_calls         |
    | dont_call             |
    | form                  |
    | form_data_recolected  |
    | form_field            |
    | queue_call_entry      |
    | valor_config          |
    +-----------------------+
    
    mysql>show columns from calls;
    
    +----------------------+------------------+------+-----+---------+----------------+
    | Field                | Type             | Null | Key | Default | Extra          |
    +----------------------+------------------+------+-----+---------+----------------+
    | id                   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
    | id_campaign          | int(10) unsigned | NO   | MUL | NULL    |                |
    | phone                | varchar(32)      | NO   |     | NULL    |                |
    | status               | varchar(32)      | YES  |     | NULL    |                |
    | uniqueid             | varchar(32)      | YES  |     | NULL    |                |
    | fecha_llamada        | datetime         | YES  |     | NULL    |                |
    | start_time           | datetime         | YES  |     | NULL    |                |
    | end_time             | datetime         | YES  |     | NULL    |                |
    | retries              | int(10) unsigned | NO   |     | 0       |                |
    | duration             | int(10) unsigned | YES  |     | NULL    |                |
    | id_agent             | int(10) unsigned | YES  | MUL | NULL    |                |
    | transfer             | varchar(6)       | YES  |     | NULL    |                |
    | datetime_entry_queue | datetime         | YES  |     | NULL    |                |
    | duration_wait        | int(11)          | YES  |     | NULL    |                |
    | dnc                  | int(1)           | NO   |     | 0       |                |
    +----------------------+------------------+------+-----+---------+----------------+
    15 rows in set (0.00 sec)
    
    mysql>exit
    
    >
    You must have this.

    Else i don't why you have this problem. :blush:
     
  12. diogo

    Joined:
    Sep 3, 2008
    Messages:
    6
    Likes Received:
    0
    Thanks, It is working now... when I upgraded call center, I don't know why, It did not add the field "dnc"...

    thanks...

    Diogo Santos
     
  13. danardf

    Joined:
    Dec 3, 2007
    Messages:
    8,069
    Likes Received:
    12
    ha... ok :)

    Cool B)
     

Share This Page