MysQL error

Discussion in 'General' started by hetii, Jun 12, 2007.

  1. hetii

    Joined:
    Jun 7, 2007
    Messages:
    32
    Likes Received:
    0
    Hi

    When i login into A2billing and go to CALL REPORT->cdr report i see this error:



    Database error: Invalid SQL: SELECT t1.starttime, t1.src, t1.calledstation, t1.destination, t1.sessiontime, t1.username, t1.terminatecause, t1.sipiax, t1.calledrate, t1.sessionbill FROM call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2007-06-12') ORDER BY t1.starttime DESC LIMIT 0,25
    MySQL 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 'call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2007-06-12') ORDE' at line 1)
    Database error: Invalid SQL: SELECT substring(t1.starttime,1,10) AS day, sum(t1.sessiontime) AS calltime, sum(t1.sessionbill) AS cost, count(*) as nbcall FROM call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2007-06-12') GROUP BY substring(t1.starttime,1,10) ORDER BY day
    MySQL 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 'call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2007-06-12') GROU' at line 1)
    Database error: Invalid SQL: SELECT count(*) FROM call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2007-06-12')
    MySQL 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 'call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2007-06-12')' at line 1)
    Database error: next_record called with no query pending.
    MySQL 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 'call t1 WHERE UNIX_TIMESTAMP(t1.starttime) >= UNIX_TIMESTAMP('2007-06-12')' at line 1)

    A2Billing - Version 1.0.7 - Release : Thu 3 Nov 2005

    Regards.
     

Share This Page