Did you set nibble_increment variable? e.g.

<variable name="nibble_increment" value="30" />

Here is its details,

http://wiki.freeswitch.org/wiki/Mod_nibblebill#Nibble_Method_.28Default.29

Thank you.


On Wed, Feb 20, 2013 at 2:10 PM, David Villasmil <david.villasmil.work@gmail.com> wrote:
Anyone about this?

Thanks


On Mon, Feb 18, 2013 at 2:07 PM, David Villasmil <david.villasmil.work@gmail.com> wrote:
Hello guys,

I have the following config for nibbebill:

                <param name="custom_sql_lookup" value="SELECT ${card_db_column_cash} AS nibble_balance FROM ${card_db_table} WHERE ${card_db_column_account}=${nibble_account};" />
                <param name="custom_sql_save" value="UPDATE ${card_db_table} SET ${card_db_column_cash}=${card_db_column_cash}-${nibble_increment} WHERE ${card_db_column_account}=${nibble_account};" />

I see this on the log, which is obviously failing:


 [UPDATE cards_table SET balance=balance- WHERE pin=12345;]

is ${nibble_increment} not the correct variable to use? It looks like it is empty!

Thanks!

David


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org




--
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)
Cell: +49 176 99 83 10 85
MSN: shari_786pk@hotmail.com
Email: shaheryarkh@googlemail.com