View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
04805Bug reportsSurvey takingpublic2010-12-10 12:162010-12-15 13:43
Reporterspeedtuga Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Fixed in Version1.90+ 
Summary04805: LimeSurvey v1.90+ Build 9169 - MSSQL - Unable to insert record into saved_control table
Description

Using MS SQL database with "mssqlnative" connection when I try to save my survey I have this Error:

"Unable to insert record into saved_control table.

No errors found"

This problem also happens when I try to create a New Token or a new LimeSurvey User.

Thx,
NB

Steps To Reproduce

Steps

  • Install limeSurvey with mssqlnative connection.
  • Create a simple survey and put it online
  • Create a Token user for this survey (If you have a error here...do a csv import)
  • Answer one question and try to save the Survey. You will see the error.
TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)9169
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version

Users monitoring this issue

c_schmitz

Activities

speedtuga

speedtuga

2010-12-14 16:22

reporter   ~13781

I am willing to make a small donation :-)
speedtuga

speedtuga

2010-12-15 12:47

reporter   ~13788

Reminder sent to: c_schmitz

It would be really helpfull if you could help about this issue today. MSSQL express is a DB that many costumers are willing to use and it could be very positive for LimeSurvey if it could work with well in this system.

I believe the problem is in function _adodb_getinsertsql in file adodb-lib.inc.php because in line 807, the instruction "$upperfname = strtoupper($field->name);" never returns a uppercased field name, because the $field->name never returns a name.

Thank you
c_schmitz

c_schmitz

2010-12-15 13:19

administrator   ~13789

We just released an updated version with this issue fixed - please update.

I am looking forward to your donation!
c_schmitz

c_schmitz

2010-12-15 13:43

administrator   ~13791

Released in 1.90+ version.

Issue History

Date Modified Username Field Change
2010-12-10 12:16 speedtuga New Issue
2010-12-14 12:55 c_schmitz Project @9@ => Bug reports
2010-12-14 16:22 speedtuga Note Added: 13781
2010-12-15 12:47 speedtuga Issue Monitored: c_schmitz
2010-12-15 12:47 speedtuga Note Added: 13788
2010-12-15 13:10 c_schmitz Assigned To => c_schmitz
2010-12-15 13:10 c_schmitz Status new => assigned
2010-12-15 13:16 c_schmitz Category Runtime => Survey taking
2010-12-15 13:19 c_schmitz Note Added: 13789
2010-12-15 13:19 c_schmitz Status assigned => resolved
2010-12-15 13:19 c_schmitz Fixed in Version => 1.90+
2010-12-15 13:19 c_schmitz Resolution open => fixed
2010-12-15 13:43 c_schmitz Note Added: 13791
2010-12-15 13:43 c_schmitz Status resolved => closed