LS -CDbCommand failed- to Change Password (LS 3.7.2)

Mehr
6 Monate 3 Wochen her - 6 Monate 3 Wochen her #168853 von John_K
John_K erstellte das Thema LS -CDbCommand failed- to Change Password (LS 3.7.2)
Hi LS community.
I was attempting to change a LS generated password for a user- But keep getting this failure error. "CDbCommand failed to execute-Implicit conversion from data type char to binary is not allowed" C full error msg below.

Tried using diff browsers. Is this a possible bug?
Need ur help in troubleshooting.
Thanks
JK


Full LS Error Msg:
Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]
Implicit conversion from data type char to binary is not allowed.
Use the CONVERT function to run this query.
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Thank you.
2018-05-17 10:06:16PST
---
ODBC Error Codes: 42000 = Syntax error or access violation
=============
My Environment:
LimeSurvey 3.7.2
Windows Server 2012 r2(64bit)
Apache 2.4.33(64bit)
PHP 7.2.5(64bit)
MS SQL Server Drivers 5.2_ForPHP(64bit)
Microsoft ODBC Driver 11 for SQL Server-Windows(64bit)
--New password format is like 'LSPa$$Word37'
Letzte Änderung: 6 Monate 3 Wochen her von John_K. Begründung: Updated info

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
6 Monate 3 Wochen her #168927 von John_K
John_K antwortete auf das Thema: LS -CDbCommand failed- to Change Password (LS 3.7.2)
Hi LS eXperts,
I hope to hear from you about any corrective actions I can do at my side or are you able to re-produce this at your end?
Looking fwd to ur Feedback-comments.
Regards
JK

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
6 Monate 3 Wochen her #168973 von holch
holch antwortete auf das Thema: LS -CDbCommand failed- to Change Password (LS 3.7.2)
I would create a bug report. This way you will get the attention of the developers quicker. I assume that it is a MSSQL problem. As LS is developed mostly in LAMP environments, problems with MSQL and ISS are often not detected as quickly.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
6 Monate 3 Wochen her #168999 von John_K
John_K antwortete auf das Thema: LS -CDbCommand failed- to Change Password (LS 3.7.2)
Hi Holch.
Thanks for ur reply-I'm not using ISS but Apache 2.4.33(64bit).
Have created a bug for this-https://bugs.limesurvey.org/view.php?id=13700
Regards;

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
6 Monate 3 Wochen her #169000 von holch
holch antwortete auf das Thema: LS -CDbCommand failed- to Change Password (LS 3.7.2)
yeah, I saw that. I just had mentioned ISS as well, just because I think most LS developers don't use it or have it available. But I often see problems here in the forum that are solely due to MSSQL.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha