The following error happens with the correct table format. Please note that the record is created in MSSQL just fine, even though the server throws the following error message:
18:51:51,773 INFO [main] v2.SmartFoxServer - SmartFoxServer 2X (2.7.0) READ
Y!
18:52:31,048 INFO [SocketReader] sessions.DefaultSessionManager - Session c
reated: { Id: 1, Type: DEFAULT, Logged: No, IP: 127.0.0.1:6111 } on Server port:
9933 <---> 6111
18:52:31,087 INFO [pool-1-thread-3] api.SFSApi - User login: { Zone: Osinia
}, ( User Name: Guest#0, Id: 0, Priv: 0, Sess: 127.0.0.1:6111 ) , Type: Unity
18:52:31,119 WARN [com.smartfoxserver.v2.controllers.ExtensionController-1] sig
nup.SignUpAssistant - java.lang.ClassCastException:
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Exception: java.lang.ClassCastException
Message: java.math.BigDecimal cannot be cast to java.lang.Long
Description: Unexpected exception occurred during the SignUp process
User info: ( User Name: Guest#0, Id: 0, Priv: 0, Sess: 127.0.0.1:6111 )
+--- --- ---+
Stack Trace:
+--- --- ---+
com.smartfoxserver.v2.components.signup.SignUpAssistantComponent.writeToDatabase
(SignUpAssistantComponent.java:454)
com.smartfoxserver.v2.components.signup.SignUpAssistantComponent.handleSubmit(Si
gnUpAssistantComponent.java:318)
com.smartfoxserver.v2.components.signup.SignUpAssistantComponent.handleClientReq
uest(SignUpAssistantComponent.java:152)
com.smartfoxserver.v2.extensions.SFSExtension.handleClientRequest(SFSExtension.j
ava:208)
com.smartfoxserver.v2.controllers.ExtensionController.processRequest(ExtensionCo
ntroller.java:143)
com.smartfoxserver.bitswarm.controllers.AbstractController.run(AbstractControlle
r.java:96)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::