I am not aware what I have done wrong, but the result is a query of:
*Database error:* Invalid SQL: SELECT * FROM WHERE
UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2005-07-01') ORDER BY
calldate 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 'WHERE UNIX_TIMESTAMP(calldate) >=
UNIX_TIMESTAMP('2005-07-01') ORDER BY calldat' at line 1)
*Database error:* Invalid SQL: SELECT count(*) FROM WHERE
UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2005-07-01')
*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 'WHERE UNIX_TIMESTAMP(calldate) >=
UNIX_TIMESTAMP('2005-07-01')' 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 'WHERE UNIX_TIMESTAMP(calldate) >=
UNIX_TIMESTAMP('2005-07-01')' at line 1)
It misses the table.
I have set the table name in the /lib/defines.php
(I checked several times for a spelling error, quotemark, ...)
bye
Ronald
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
