[Freeswitch-users] Nibblebill database update

[William Alianto]

Hi,

I was trying to use nibblebill as billing control of my FS. I have 
configured the odbc and the nibblebill configuration. When I tried to 
call, the query looks ok. But when I hanged up the call, it seems like 
there is something wrong with the database connection, since it's not 
updating the database at all. I got error message on CLI

2012-11-01 10:51:00.559472 [ERR] switch_odbc.c:494 ERR: [UPDATE accounts 
SET usage=usage-0.476000 WHERE user='1001']
[STATE: 42000 CODE 1064 ERROR: [unixODBC][MySQL][ODBC 5.1 
Driver][mysqld-5.5.24-0ubuntu0.12.04.1]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 'usage=usage-0.476000 WHERE 
user='1001'' at line 1
]
2012-11-01 10:51:00.559472 [ERR] mod_nibblebill.c:343 ERR: [UPDATE 
accounts SET usage=usage-0.476000 WHERE user='1001']
[]
2012-11-01 10:51:00.559472 [CRIT] mod_nibblebill.c:542 Failed to log to 
database!
2012-11-01 10:51:00.559472 [DEBUG] mod_nibblebill.c:383 Doing lookup query
[SELECT usage AS nibble_balance FROM accounts WHERE user='1001']
2012-11-01 10:51:00.559472 [ERR] mod_nibblebill.c:385 ERR: [SELECT usage 
AS nibble_balance FROM accounts WHERE user='1001']
[STATE: 42000 CODE 1064 ERROR: [unixODBC][MySQL][ODBC 5.1 
Driver][mysqld-5.5.24-0ubuntu0.12.04.1]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 'usage AS nibble_balance FROM accounts 
WHERE user='1001'' at line 1
]
2012-11-01 10:51:00.559472 [ERR] mod_nibblebill.c:386 Error running this 
query: [SELECT usage AS nibble_balance FROM accounts WHERE user='1001']

Could anybody help me solve this issue?

Regards