View Issue Details

This issue affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
03679Bug reportsSurvey takingpublic2009-09-21 12:57
Reporterthozi Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionduplicate 
Product Version1.85+ 
Summary03679: Reloading Survey after saving it crahes.
Description

I get the following SQL error if I try to reload a previously saved survey based on the following link:

Reload your survey by clicking on the following link (or pasting it into your browser)::
http://s-corpap003.corp.voicecash.com/limesurvey/index.php?sid=43557&loadall=reload&scid=1&loadname=thozi&loadpass=kyobashi&token=d5xzd9qywveqhys

Error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]The data types text and varchar are incompatible in the equal to operator.:SELECT * FROM [lime_saved_control] INNER JOIN lime_survey_43557 ON [lime_saved_control].srid = lime_survey_43557.id WHERE [lime_saved_control].sid=43557 AND [lime_saved_control].scid=1 AND [lime_saved_control].identifier = 'thozi' AND [lime_saved_control].access_code = '6322ffb66658cb0d528eef8c31f5f08c'

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
BrowserIE and Mozilla Firefox
Database type & versionMSSQL10 (Microsoft SQL server 10)
Server OS (if known)Windows NT 6.0 build 6001
Webserver software & version (if known)IIS
PHP Version5.2.10
Git branch / Pull Request URL

Relationships

related to 03728 closeduser372 Cannot reload survey 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2009-09-14 13:50

updater   ~09544

c_schmitz, I think you are the only poor guy running a MS SQL database. Can you test?

c_schmitz

c_schmitz

2009-09-14 19:45

administrator   ~09553

Which build are you using?

thozi

thozi

2009-09-15 15:34

reporter   ~09558

No problem, if you tell me how I can find this out (I'm not the sysadmin or db admin person but can ask him). I hope that I'm not the only poor guy running limesurvey on MS SQL rather than mySQL ;-) I'd prefer mySQL but we have almost all tools on MS SQL and IIS (company policy)..

Mazi

Mazi

2009-09-15 15:59

updater   ~09559

When being logged in at the admin panel version and build are shown at the bottom like 1.85+ (7121).

c_schmitz

c_schmitz

2009-09-16 01:59

administrator   ~09571

After a check I found that this is already resolved in the latest version.
Please update.

thozi

thozi

2009-09-16 12:54

reporter   ~09573

oh, I thought you were asking for the build of the MS SQL database.

For LimeSurvey I'm using Version 1.85+ (7561), but apparently this has the problem. Do I need to upgrade to a later build?

Mazi

Mazi

2009-09-17 21:03

updater   ~09592

Please update to the latest 1.85+ build released a few days ago.

Issue History

Date Modified Username Field Change
2009-09-13 15:46 thozi New Issue
2009-09-13 15:46 thozi Status new => assigned
2009-09-13 15:46 thozi Assigned To => user372
2009-09-13 15:46 thozi Browser => IE and Mozilla Firefox
2009-09-13 15:46 thozi Database & DB-Version => MSSQL10 (Microsoft SQL server 10)
2009-09-13 15:46 thozi Operating System (Server) => Windows NT 6.0 build 6001
2009-09-13 15:46 thozi Webserver => IIS
2009-09-13 15:46 thozi PHP Version => 5.2.10
2009-09-14 13:50 Mazi Assigned To user372 => c_schmitz
2009-09-14 13:50 Mazi Note Added: 09544
2009-09-14 19:45 c_schmitz Note Added: 09553
2009-09-15 15:34 thozi Note Added: 09558
2009-09-15 15:59 Mazi Note Added: 09559
2009-09-15 15:59 Mazi Status assigned => feedback
2009-09-16 01:59 c_schmitz Note Added: 09571
2009-09-16 01:59 c_schmitz Status feedback => resolved
2009-09-16 01:59 c_schmitz Resolution open => duplicate
2009-09-16 12:54 thozi Note Added: 09573
2009-09-16 12:54 thozi Status resolved => feedback
2009-09-16 12:54 thozi Resolution duplicate => reopened
2009-09-17 21:03 Mazi Note Added: 09592
2009-09-21 12:57 c_schmitz Status feedback => closed
2009-09-21 12:57 c_schmitz Resolution reopened => duplicate
2009-10-07 23:20 user372 Relationship added related to 03728
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking