View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04068 | Bug reports | Data Entry (non public) | public | 2010-01-25 11:37 | 2010-01-27 22:46 |
| Reporter | thozi | Assigned To | c_schmitz | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | no change required | ||
| Product Version | 1.86 | ||||
| Summary | 04068: Strange tablename in DB | ||||
| Description | This is going a bit deeper into the DB table strucutre used by Limesurvey. I'm using LimeSurvey for quiet some time with good success. No problems. I now wanted to backup the database by dumping out SQL. Unfortunately I cannot do this because LimeSurvy somehow and someetime ago created a table with a name in quotes which I now cannot access (e.g. show data) or modified via SQL statements. (Note that I'm not the super expert in SQL. I'm running Limesurvey under MSSQL (not mysql). with Version 1.86 (7697). So I found a table created which name is EXEC sp_rename '[dbo].["[lime_tokens_43557]"]', 'lime_tokens_43557', 'OBJECT' How can I delete or rename the table??? What would be the syntax of the SQL Command? I found other tables called lime_tokens_14213 which work w/o problems. Somehow this problematic tablename was created and now I've trouble to get rid of it. Any ideas ?? | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 7697 | ||||
| I will donate to the project if issue is resolved | |||||
| Browser | Firefox | ||||
| Database type & version | mssql | ||||
| Server OS (if known) | Windows | ||||
| Webserver software & version (if known) | IIS | ||||
| PHP Version | ? | ||||
| Git branch / Pull Request URL | |||||
|
@ c_schmitz: any idea? |
|
|
Did you try to use the MSSQL Enterprise Manager to remove it? |
|
|
Yes, I tried the SQL Manager 2010 for SQL Server, selected the table and tried to rename or remove and I get the same error. IT creates the following SQL command but then cannot compile and execute. See below's transcript: --------------- SQL --------------- EXEC sp_rename '[dbo].["[lime_tokens_43557]"]', 'lime_tokens_43557', 'OBJECT' ---------- ERROR MESSAGE ---------- Syntax error parsing SQL identifier '[dbo].["[lime_tokens_43557]"]'. |
|
|
well, rename may be failing |
|
|
Ok. tried that as well. Here's the log: DROP TABLE [dbo].["[lime_tokens_43557]"] ---------- ERROR MESSAGE ---------- Unclosed quotation mark after the character string '] |
|
|
Only thing you could try is to export the correct tables, |
|
|
That is really bad. The problem is that I cannot export each individual table, only the complete schema (at least in SQL Manager 2010 lite). I'm not a SQL expert how to do this. Trying to export all tables stops when it tries to export the table with the strange name... And then I'm lost.. Anyway, thanks for your suggestions.. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-01-25 11:37 | thozi | New Issue | |
| 2010-01-25 11:37 | thozi | Status | new => assigned |
| 2010-01-25 11:37 | thozi | Assigned To | => user372 |
| 2010-01-25 11:37 | thozi | LimeSurvey build number | => 7697 |
| 2010-01-25 11:37 | thozi | Browser | => Firefox |
| 2010-01-25 11:37 | thozi | Database & DB-Version | => mssql |
| 2010-01-25 11:37 | thozi | Operating System (Server) | => Windows |
| 2010-01-25 11:37 | thozi | Webserver | => IIS |
| 2010-01-25 11:37 | thozi | PHP Version | => ? |
| 2010-01-25 13:00 |
|
Note Added: 10882 | |
| 2010-01-25 13:01 |
|
Assigned To | user372 => c_schmitz |
| 2010-01-25 13:07 | c_schmitz | Note Added: 10884 | |
| 2010-01-25 13:47 | thozi | Note Added: 10886 | |
| 2010-01-26 12:58 | c_schmitz | Note Added: 10897 | |
| 2010-01-26 13:05 | thozi | Note Added: 10898 | |
| 2010-01-26 13:20 | c_schmitz | Note Added: 10899 | |
| 2010-01-26 13:20 | c_schmitz | Status | assigned => resolved |
| 2010-01-26 13:20 | c_schmitz | Resolution | open => no change required |
| 2010-01-26 13:26 | thozi | Note Added: 10900 | |
| 2010-01-27 22:46 | c_schmitz | Status | resolved => closed |