mysql issues

[Will Stocker]

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]

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]

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: