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