Версия asterisk 11.12.0, версия панели телефонии 1.2.22.3 при запросе истории звонков из панели в логах пишется следующее:
-- Launched AGI Script /var/lib/asterisk/agi-bin/1C_CDR.php
> 1C_CDR.php: Running SQL Command describe asteriskcdrdb.cdr
> 1C_CDR.php: Connected to MySQL database OK.
> 1C_CDR.php: Sel ected database OK.
1C_CDR.php: SEVERE PROGRAMMING ERROR: For portability, COLUMNS must be surrounded by BACK TICKS (`), yet none were found. Continuing.
1C_CDR.php: SEVERE PROGRAMMING ERROR: For portability, FIELDS must be surrounded by SINGLE QUOTES ('), yet none were found. Continuing.
> 1C_CDR.php: Running SQL Command SELECT
> 1C_CDR.php: `a`.`calldate`,
> 1C_CDR.php: `a`.`src`,
> 1C_CDR.php: `a`.`dst`,
> 1C_CDR.php: `a`.`channel`,
> 1C_CDR.php: `a`.`dstchannel`,
> 1C_CDR.php: `a`.`billsec`,
> 1C_CDR.php: `a`.`disposition`,
> 1C_CDR.php: `a`.`uniqueid`,
> 1C_CDR.php: `a`.`recordingfile`,
> 1C_CDR.php: `a`.`peer`,
> 1C_CDR.php: `a`.`lastapp`,
> 1C_CDR.php: `a`.`linkedid`
> 1C_CDR.php: FR OM
> 1C_CDR.php: (SEL ECT * fr om `asteriskcdrdb`.`PT1C_cdr`
> 1C_CDR.php:
> 1C_CDR.php: LEFT JOIN
> 1C_CDR.php:
> 1C_CDR.php: (SELECT `peer` AS `peer`, `linkedid` AS `link`, `uniqueid` AS `uid`
> 1C_CDR.php: FR OM `asteriskcdrdb`.`cel`
> 1C_CDR.php: WHERE `eventtype`='BRIDGE_START'
> 1C_CDR.php: ) AS `tmp_cel`
> 1C_CDR.php:
> 1C_CDR.php: ON
> 1C_CDR.php:
> 1C_CDR.php: (`asteriskcdrdb`.`PT1C_cdr`.`uniqueid` = `tmp_cel`.`link` OR `asteriskcdrdb`.`PT1C_cdr`.`uniqueid` = `tmp_cel`.`uid`)
> 1C_CDR.php:
> 1C_CDR.php: WHERE `calldate` BETWEEN '2014-12-29' AND '2014-12-30' )
> 1C_CDR.php:
> 1C_CDR.php: AS `a`
> 1C_CDR.php:
> 1C_CDR.php: WH ERE (( `a`.`lastapp`='Transferred Call' AND `a`.`lastdata` like '%/191@%')
> 1C_CDR.php: OR ((`a`.`lastapp`='Dial' OR `a`.`lastapp`='Queue')
> 1C_CDR.php: AND (`a`.`channel` like '%/191-%'
> 1C_CDR.php: OR `a`.`dstchannel` like '%/191-%'
> 1C_CDR.php: OR `a`.`dstchannel` like '%/191@%'
> 1C_CDR.php: OR `a`.`src`='191'
> 1C_CDR.php: OR `a`.`dst`='191'))
> 1C_CDR.php: OR (`a`.`peer` LIKE '%/191-%')
> 1C_CDR.php: OR (`a`.`peer` LIKE '%/191@%')
> 1C_CDR.php: ) OR (( `a`.`lastapp`='Transferred Call' AND `a`.`lastdata` like '%/89123456789@%')
> 1C_CDR.php: OR ((`a`.`lastapp`='Dial' OR `a`.`lastapp`='Queue')
> 1C_CDR.php: AND (`a`.`channel` like '%/89124563233-%'
> 1C_CDR.php: OR `a`.`dstchannel` like '%/89123456789-%'
> 1C_CDR.php: OR `a`.`dstchannel` like '%/89123456789@%'
> 1C_CDR.php: OR `a`.`src`='89123456789'
> 1C_CDR.php: OR `a`.`dst`='89123456789'))
> 1C_CDR.php: OR (`a`.`peer` LIKE '%/89123456789-%')
> 1C_CDR.php: OR (`a`.`peer` LIKE '%/89123456789@%')
истории в панели нет. больше ничего не происходит!
-- Launched AGI Script /var/lib/asterisk/agi-bin/1C_CDR.php
> 1C_CDR.php: Running SQL Command describe asteriskcdrdb.cdr
> 1C_CDR.php: Connected to MySQL database OK.
> 1C_CDR.php: Sel ected database OK.
1C_CDR.php: SEVERE PROGRAMMING ERROR: For portability, COLUMNS must be surrounded by BACK TICKS (`), yet none were found. Continuing.
1C_CDR.php: SEVERE PROGRAMMING ERROR: For portability, FIELDS must be surrounded by SINGLE QUOTES ('), yet none were found. Continuing.
> 1C_CDR.php: Running SQL Command SELECT
> 1C_CDR.php: `a`.`calldate`,
> 1C_CDR.php: `a`.`src`,
> 1C_CDR.php: `a`.`dst`,
> 1C_CDR.php: `a`.`channel`,
> 1C_CDR.php: `a`.`dstchannel`,
> 1C_CDR.php: `a`.`billsec`,
> 1C_CDR.php: `a`.`disposition`,
> 1C_CDR.php: `a`.`uniqueid`,
> 1C_CDR.php: `a`.`recordingfile`,
> 1C_CDR.php: `a`.`peer`,
> 1C_CDR.php: `a`.`lastapp`,
> 1C_CDR.php: `a`.`linkedid`
> 1C_CDR.php: FR OM
> 1C_CDR.php: (SEL ECT * fr om `asteriskcdrdb`.`PT1C_cdr`
> 1C_CDR.php:
> 1C_CDR.php: LEFT JOIN
> 1C_CDR.php:
> 1C_CDR.php: (SELECT `peer` AS `peer`, `linkedid` AS `link`, `uniqueid` AS `uid`
> 1C_CDR.php: FR OM `asteriskcdrdb`.`cel`
> 1C_CDR.php: WHERE `eventtype`='BRIDGE_START'
> 1C_CDR.php: ) AS `tmp_cel`
> 1C_CDR.php:
> 1C_CDR.php: ON
> 1C_CDR.php:
> 1C_CDR.php: (`asteriskcdrdb`.`PT1C_cdr`.`uniqueid` = `tmp_cel`.`link` OR `asteriskcdrdb`.`PT1C_cdr`.`uniqueid` = `tmp_cel`.`uid`)
> 1C_CDR.php:
> 1C_CDR.php: WHERE `calldate` BETWEEN '2014-12-29' AND '2014-12-30' )
> 1C_CDR.php:
> 1C_CDR.php: AS `a`
> 1C_CDR.php:
> 1C_CDR.php: WH ERE (( `a`.`lastapp`='Transferred Call' AND `a`.`lastdata` like '%/191@%')
> 1C_CDR.php: OR ((`a`.`lastapp`='Dial' OR `a`.`lastapp`='Queue')
> 1C_CDR.php: AND (`a`.`channel` like '%/191-%'
> 1C_CDR.php: OR `a`.`dstchannel` like '%/191-%'
> 1C_CDR.php: OR `a`.`dstchannel` like '%/191@%'
> 1C_CDR.php: OR `a`.`src`='191'
> 1C_CDR.php: OR `a`.`dst`='191'))
> 1C_CDR.php: OR (`a`.`peer` LIKE '%/191-%')
> 1C_CDR.php: OR (`a`.`peer` LIKE '%/191@%')
> 1C_CDR.php: ) OR (( `a`.`lastapp`='Transferred Call' AND `a`.`lastdata` like '%/89123456789@%')
> 1C_CDR.php: OR ((`a`.`lastapp`='Dial' OR `a`.`lastapp`='Queue')
> 1C_CDR.php: AND (`a`.`channel` like '%/89124563233-%'
> 1C_CDR.php: OR `a`.`dstchannel` like '%/89123456789-%'
> 1C_CDR.php: OR `a`.`dstchannel` like '%/89123456789@%'
> 1C_CDR.php: OR `a`.`src`='89123456789'
> 1C_CDR.php: OR `a`.`dst`='89123456789'))
> 1C_CDR.php: OR (`a`.`peer` LIKE '%/89123456789-%')
> 1C_CDR.php: OR (`a`.`peer` LIKE '%/89123456789@%')
истории в панели нет. больше ничего не происходит!
Изменено: - 29.12.2014 13:46:42