upgrade to 1.2 and agenda not working

Joined
Jan 8, 2008
Messages
422
Points
16
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
 
Joined
Sep 27, 2007
Messages
205
Points
0
Hello everybody:

This is accepted as a bug, I add this track in our manager task (gforge).
Thank for you post.
 
Joined
Dec 3, 2007
Messages
8,069
Points
88
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:
 
Joined
Jan 8, 2008
Messages
422
Points
16
Hi Danardf

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

David Medina
 
Joined
Dec 3, 2007
Messages
8,069
Points
88
telecomtechnician said:
Hi Danardf

Can you explain in which file should I put the line?

David Medina
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

telecomtechnician said:
Hi Danardf

and does it really solve the problem?,

David Medina
Yes, i make a test. It's good.
 
Joined
May 14, 2007
Messages
1,454
Points
0
Thanks franck, I increase your karma in one again ;).

Saludos,

Rafael
 
Joined
Sep 3, 2008
Messages
6
Points
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
 
Joined
Dec 3, 2007
Messages
8,069
Points
88
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:
 
Joined
Sep 3, 2008
Messages
6
Points
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
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,987
Messages
131,100
Members
17,716
Latest member
Orbit114
Top