[Freeswitch-users] Nibblebill database question

[Rupa Schomaker]

On Tue, Feb 12, 2013 at 5:26 PM, David Villasmil <
david.villasmil.work at gmail.com> wrote:

> call goes out fine... no billing though:
>
>
> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:504 22 seconds passed
> since last bill time of 2013-02-12 19:21:27
> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:521 Billing $0.018983
> to 1 (Call: d442dc6b-a3a7-423a-8450-598d17ca43b3 / 0.000000 so far)
> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:351 Doing update query
> [UPDATE sip_users SET balance=balance-0.018983 WHERE ='1']
> 2013-02-12 19:21:49.844277 [CRIT] mod_nibblebill.c:535 Failed to log to
> database!
> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:378 Doing lookup query
> [SELECT balance AS nibble_balance FROM sip_users WHERE ='1']
> 2013-02-12 19:21:49.844277 [ERR] mod_nibblebill.c:380 Error running this
> query: [SELECT balance AS nibble_balance FROM sip_users WHERE ='1']
>
>
> the select go fine if executed "by hand"
>

None of those SQL statements are valid.  (hint: WHERE = '1' is no good).
 Been a while since I hacked/worked with nibblebill, but I'm pretty sure
the 'id' field isn't not being filled in the sql for some reason.


-- 
-Rupa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130212/ec492a20/attachment-0001.html