View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
08388Bug reportsAccessibilitypublic2013-11-19 15:392013-11-22 16:12
ReportermarcosCosta Assigned Toc_schmitz  
PriorityurgentSeverityblock 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary08388: String or binary data truncated when CDbCommand try to execute a SQL statement
Description

CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: [Microsoft][SQL Server Native Client 11.0][SQL Server]

I've getting the error above. I'm just trying to open the Control Panel, but the browser still block me. Since one week, I'm trying to solve this problem. I'm using SQL Server 2008 and any data of the base was changed by me.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)Inaccessible
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database type & versionSQL Server 2008
Server OS (if known)Windows 7 Professional
Webserver software & version (if known)ISS7 with PHP Manager
PHP Version5.2
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-11-21 11:28

administrator   ~27283

Please activate debug mode in /application/config/config.php and you should get a more detailed error. Please attach the result as HTML file.
Thank you.
marcosCosta

marcosCosta

2013-11-22 16:09

reporter   ~27327

Before you'd reply my question I tried to solve the problem searching for the query that was causing the problem. I found the code at framework/db/CDbcommand.php and I've commented a try catch between the lines 327 and 356 replacing all this by return 1. So the problem was solved. Today I uncommented to see what would happen and nevertheless the crash don't happened again. What about this?

Issue History

Date Modified Username Field Change
2013-11-19 15:39 marcosCosta New Issue
2013-11-19 15:40 marcosCosta Issue Monitored: marcosCosta
2013-11-20 13:10 marcosCosta Issue End Monitor: marcosCosta
2013-11-21 11:28 c_schmitz Note Added: 27283
2013-11-21 11:28 c_schmitz Assigned To => c_schmitz
2013-11-21 11:28 c_schmitz Status new => feedback
2013-11-22 16:09 marcosCosta Note Added: 27327
2013-11-22 16:09 marcosCosta Status feedback => assigned
2013-11-22 16:12 c_schmitz Status assigned => closed
2013-11-22 16:12 c_schmitz Resolution open => unable to reproduce