upgrade to 1.2 and agenda not working

telecomtechnician

Joined
Jan 8, 2008
Messages
422
Likes
0
Points
16
#1
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
 

danardf

Joined
Dec 3, 2007
Messages
8,069
Likes
10
Points
88
#2
Hi.

I the same problem.

I look this problem.
 

bmacias

Joined
Sep 27, 2007
Messages
205
Likes
0
Points
0
#3
Hello everybody:

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

danardf

Joined
Dec 3, 2007
Messages
8,069
Likes
10
Points
88
#4
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:
 

telecomtechnician

Joined
Jan 8, 2008
Messages
422
Likes
0
Points
16
#5
Hi Danardf

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

David Medina
 

danardf

Joined
Dec 3, 2007
Messages
8,069
Likes
10
Points
88
#6
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.
 

DaveD

Joined
Nov 12, 2007
Messages
597
Likes
0
Points
16
#7
Thankyou for this fix it works great
 

rafael

Joined
May 14, 2007
Messages
1,454
Likes
1
Points
0
#8
Thanks franck, I increase your karma in one again ;).

Saludos,

Rafael
 

danardf

Joined
Dec 3, 2007
Messages
8,069
Likes
10
Points
88
#9
Thanks a lot Rafael. :)
 

diogo

Joined
Sep 3, 2008
Messages
6
Likes
0
Points
0
#10
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
 

danardf

Joined
Dec 3, 2007
Messages
8,069
Likes
10
Points
88
#11
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:
 

diogo

Joined
Sep 3, 2008
Messages
6
Likes
0
Points
0
#12
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
 

danardf

Joined
Dec 3, 2007
Messages
8,069
Likes
10
Points
88
#13
ha... ok :)

Cool B)
 

Members online

No members online now.

Forum statistics

Threads
30,951
Messages
130,979
Members
17,652
Latest member
joeljag_19
Top