Signup Assistance - MSSQL Support
Posted: 07 Nov 2013, 04:25
Currently, I do not believe the Signup Assistance is compatible with MSSQL.
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:
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)
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::