CashServer error every 2 min

[viktor145]

Unhandled Exception:

System.InvalidCastException: Cannot cast from source type to destination type.

  at System.DBNull.System.IConvertible.ToInt32 (IFormatProvider provider) [0x00000] in <filename unknown>:0 

  at System.Convert.ToInt32 (System.Object value, IFormatProvider provider) [0x00000] in <filename unknown>:0 

  at System.Convert.ToInt32 (System.Object value) [0x00000] in <filename unknown>:0 

  at Cash_Server.Users.GetCashBalance (System.String username, Int32 userid) [0x00000] in <filename unknown>:0 

  at Cash_Server.Users.ProcessCashBalanceRequest (System.Byte[] packet, Int32 ClientID) [0x00000] in <filename unknown>:0 

  at Cash_Server.NetIO.Incomming (System.Byte[] packet, Int32 ClientID) [0x00000] in <filename unknown>:0 

  at Cash_Server.NetIO.OnDataReceived (IAsyncResult asyn) [0x00000] in <filename unknown>:0 

 

[viktor145]

2013/10/05 23:56:36 :: Call to Gothic > ET to call Home.....Connect

2013/10/05 23:56:36 :: SYSTEM > Testing mySQL connection

2013/10/05 23:56:37 :: SYSTEM > Loaded 293 packages from the database

2013/10/05 23:56:37 :: SYSTEM > Changing to Auth DB

2013/10/05 23:56:37 :: SYSTEM > Found 123 game accounts

2013/10/05 23:56:37 :: SYSTEM > Lottery system starting

2013/10/05 23:56:37 :: SYSTEM > Cash Server listening on MY IP:9100

2013/10/05 23:56:37 :: LOTTERY > Participants of week 40 : 0

2013/10/05 23:56:37 :: SYSTEM > Connection accepted from MY IP:56257

 

Unhandled Exception:

System.InvalidCastException: Cannot cast from source type to destination type.

  at System.DBNull.System.IConvertible.ToInt32 (IFormatProvider provider) [0x00000] in <filename unknown>:0 

  at System.Convert.ToInt32 (System.Object value, IFormatProvider provider) [0x00000] in <filename unknown>:0 

  at System.Convert.ToInt32 (System.Object value) [0x00000] in <filename unknown>:0 

  at Cash_Server.Users.GetCashBalance (System.String username, Int32 userid) [0x00000] in <filename unknown>:0 

  at Cash_Server.Users.ProcessCashBalanceRequest (System.Byte[] packet, Int32 ClientID) [0x00000] in <filename unknown>:0 

  at Cash_Server.NetIO.Incomming (System.Byte[] packet, Int32 ClientID) [0x00000] in <filename unknown>:0 

  at Cash_Server.NetIO.OnDataReceived (IAsyncResult asyn) [0x00000] in <filename unknown>:0 

[root@www cash]# 

[luoo]

set default value for the coloum cash in bg_user

[viktor145]

Thank you

[SibaN]

Closed