Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

get_session_key with SQL server DB

  • lakfel
  • lakfel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 month ago #181858 by lakfel
get_session_key with SQL server DB was created by lakfel
There is a problem when I try to use the API.
I tracked and this is it.
When I try to call the get_session_code, stored in remotecontrol_handle.php the program tries to store this information in the Sessions table. The Column data, where it is supposed to store the username is varbinary type, when PHP try to save the register, the DB returns an exception
"Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query."
It does not allow implicit conversion so you can not register the new session and get the session key. I've solved hacking the code directly to accept my session but it should convert the information and store it properly. I am not sure if this is a problem of SQL Server.
Versión 3.14.11
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose