[Freeswitch-users] mod_nibblebill question: DB Error while updating cash!

[Diego Viola]

Hello,

I'm trying to give mod_nibblebill a try, I compiled it and created the
DB, set up ODBC, etc. I'm using MySQL.

This is how I created the db:

 CREATE TABLE accounts
 (
   id int NOT NULL PRIMARY KEY,
   name VARCHAR(255),
   cash double precision NOT NULL
 );

However when I try to make a call I get this:

2009-03-08 00:37:02 [CRIT] mod_nibblebill.c:286 bill_event() DB Error
while updating cash!

I have this also on my user directory:

      <variable name="nibble_rate" value="0.03"/>
      <variable name="nibble_account" value="18238"/>


Any ideas?

Thanks.