[Asterisk-Users] Asteriski misses the table

[Ronald_Wiplinger]

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