View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
03890Bug reportsSurvey participants (Tokens)public2009-12-11 12:16
ReporterMazi Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version1.86 
Fixed in Version1.87RC5 
Summary03890: When restoring a token table MS SQL fails to rename table
Description

I ran into this problem at the server of a swedish user, hopefully you can reproduce:

  1. Create a survey which uses tokens
  2. Setup token table
  3. Activate survey
  4. De-activate survey
  5. Go to token section
  6. You are offered to restore the old token table
  7. Select token table and try to restore it -> error message
Additional Information

Error message (partly swedish):
Failed Rename!
EXEC sp_rename 'lime_old_tokens_82532_20091123165638','"[lime_tokens_82532]"'
[Microsoft][ODBC SQL Server Driver][SQL Server]Fel: Det nya namnet "[lime_tokens_82532]" anv?nds redan som ett object-namn och orsakar en otill?ten dubblett.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)7697
I will donate to the project if issue is resolved
BrowserFF3
Database type & versionMS SQL Server
Server OS (if known)Windows Server 2008
Webserver software & version (if known)Microsoft-IIS/7.0
PHP Version5.2.11

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2009-11-23 17:40

  ~10224

@ Mazi: Can you reproduce the issue on the latest development build?

Mazi

Mazi

2009-11-23 18:24

updater   ~10225

I haven't got the opportunity to update the customers installation and I don't have MS SQL on my PC. Someone having MS SQL available locally has to give this a try.

user372

2009-11-23 18:35

  ~10226

@ c_schmitz: may you please have a look?

Mazi

Mazi

2009-11-28 14:20

updater   ~10297

I can reproduce the problem on my MS SQL 2005 installation BUT you have to restore the token first, then continue with steps 3-7 and when trying to restire the token table again you get the following error:
Failed Rename!
EXEC sp_rename 'lime_old_tokens_82532_20091128141816','"[lime_tokens_82532]"'
[Microsoft][ODBC SQL Server Driver][SQL Server]Fehler: Der neue Name '"[lime_tokens_82532]"' wird bereits als object-Name verwendet und würde ein unzulässiges Duplikat erzeugen.

Issue History

Date Modified Username Field Change
2009-11-23 17:24 Mazi New Issue
2009-11-23 17:24 Mazi Status new => assigned
2009-11-23 17:24 Mazi Assigned To => user372
2009-11-23 17:24 Mazi LimeSurvey build number => 7697
2009-11-23 17:24 Mazi Browser => FF3
2009-11-23 17:24 Mazi Database & DB-Version => MS SQL Server
2009-11-23 17:24 Mazi Operating System (Server) => Windows Server 2008
2009-11-23 17:24 Mazi Webserver => Microsoft-IIS/7.0
2009-11-23 17:24 Mazi PHP Version => 5.2.11
2009-11-23 17:40 user372 Note Added: 10224
2009-11-23 17:41 user372 Status assigned => feedback
2009-11-23 18:24 Mazi Note Added: 10225
2009-11-23 18:24 Mazi Status feedback => assigned
2009-11-23 18:35 user372 Note Added: 10226
2009-11-23 18:36 user372 Assigned To user372 => c_schmitz
2009-11-28 14:20 Mazi Note Added: 10297
2009-11-30 03:08 c_schmitz Status assigned => resolved
2009-11-30 03:08 c_schmitz Fixed in Version => 1.87RC5
2009-11-30 03:08 c_schmitz Resolution open => fixed
2009-12-11 12:16 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)