mysql issues

17 views
Skip to first unread message

Will Stocker

unread,
Mar 24, 2017, 7:37:02 AM3/24/17
to CDR-Stats
Hi All,

I've managed to get almost everything up and running, however I'm stumped with the connector.


INFO[0000] StartTime: Fri Mar 24 2017 11:34:28
INFO[0000] RunFetcher waiting on chanSync before fetching
ERRO[0000] Failed to run query:Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(start_stamp), datetime(answer_stamp), datetime(end_stamp) FROM cdr WHERE flag_i' at line 1
ERRO[0000] Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(start_stamp), datetime(answer_stamp), datetime(end_stamp) FROM cdr WHERE flag_i' at line 1


mysql -V

mysql  Ver 14.14 Distrib 5.7.15, for Linux (x86_64) using  EditLine wrapper


Any suggestions here?

Will Stocker

unread,
Mar 24, 2017, 7:45:53 AM3/24/17
to CDR-Stats
mysql> show columns from cdr
    -> ;
+-------------+------------------+------+-----+---------------------+----------------+
| Field       | Type             | Null | Key | Default             | Extra          |
+-------------+------------------+------+-----+---------------------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL                | auto_increment |
| calldate    | datetime         | NO   |     | 0000-00-00 00:00:00 |                |
| clid        | varchar(80)      | NO   |     |                     |                |
| src         | varchar(80)      | NO   |     |                     |                |
| dst         | varchar(80)      | NO   |     |                     |                |
| dcontext    | varchar(80)      | NO   |     |                     |                |
| channel     | varchar(80)      | NO   |     |                     |                |
| dstchannel  | varchar(80)      | NO   |     |                     |                |
| lastapp     | varchar(80)      | NO   |     |                     |                |
| lastdata    | varchar(80)      | NO   |     |                     |                |
| duration    | int(11)          | NO   |     | 0                   |                |
| billsec     | int(11)          | NO   |     | 0                   |                |
| disposition | varchar(45)      | NO   |     |                     |                |
| amaflags    | int(11)          | NO   |     | 0                   |                |
| accountcode | varchar(20)      | NO   |     |                     |                |
| uniqueid    | varchar(32)      | NO   |     |                     |                |
| userfield   | varchar(255)     | NO   |     |                     |                |
+-------------+------------------+------+-----+---------------------+----------------+

Will Stocker

unread,
Mar 24, 2017, 7:51:25 AM3/24/17
to CDR-Stats
INFO[0000] StartTime: Fri Mar 24 2017 11:50:16
INFO[0000] RunFetcher waiting on chanSync before fetching
ERRO[0000] Failed to run query:Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<>1  LIMIT 100' at line 1
ERRO[0000] Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<>1  LIMIT 100' at line 1
INFO[0000] RunFetcher sleeps for 1 seconds!
INFO[0001] RunFetcher waiting on chanSync before fetching


On Friday, 24 March 2017 11:37:02 UTC, Will Stocker wrote:
Reply all
Reply to author
Forward
0 new messages