SQLSTATE[HY000]

More
2 years 9 months ago #110180 by jalpesh
Hi All,

Can someone help me..... i am facing following error while i am using any API function of RemoteControl 2.

Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 102 General SQL Server error: Check messages from the SQL Server [102] (severity 15) [(null)]

Can someone please help me.

Thanks in Advanced.

Thanks,
Jalpesh Raj

Please Log in to join the conversation.

More
2 years 9 months ago #110183 by jalpesh

jalpesh wrote: Hi All,

Can someone help me..... i am facing following error while i am using any API function of RemoteControl 2.

Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 102 General SQL Server error: Check messages from the SQL Server [102] (severity 15) [(null)]

Can someone please help me.

Thanks in Advanced.

Thanks,
Jalpesh Raj


Some more detais...

I have set 'debug'=>2 and found following SQL error...

The SQL statement executed was: SELECT TOP 1 * FROM [dbo].[lime_users] [t] WHERE [t].[users_name]=:yp0

Please Log in to join the conversation.

More
1 year 10 months ago #120487 by jalpesh
The fix was in this commit bugs.limesurvey.org/view.php?id=9132

Please Log in to join the conversation.