View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05094 | Bug reports | Other | public | 2011-04-07 05:37 | 2011-04-16 16:46 |
| Reporter | medicnick | Assigned To | c_schmitz | ||
| Priority | high | Severity | partial_block | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 1.91RC5 | ||||
| Summary | 05094: Creating Labelsets error in MSSQL | ||||
| Description | When saving a test label set in Label Sets Administration, clicking on save results in this error: Saving a second test label set in Label Sets Administration results in Both label sets were actually created but the test label title is blank. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 9995 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | FF4 | ||||
| Database type & version | MSSQL R2 | ||||
| Server OS (if known) | WIN 2008 | ||||
| Webserver software & version (if known) | IIS7 | ||||
| PHP Version | 5.2.5 | ||||
| Git branch / Pull Request URL | |||||
|
@c_schmitz: he is referring to the dev branch, but i also noticed that backticks ` exist in the stable branch. As that seems to be a problem for MSSQL (and I only have MySQL) could you review if that really is a problem? Then we need to fix some stuff on the stable branch too |
|
|
I previously had 1.92dev so now that I have RC5 correctly installed, I reran this test. It resulted in the following error: Inserting the label set failed: Looking into labels.php it appears to be this particular section
} This function fails to generate a new LID and also fails to return the error message. I confirmed that a new LID was not generated by checking the labelsets table. I hope this is helpful. Thanks. |
|
|
The code is alright. It looks liekyour labelsets table is missing the autoincrement value on the LID field. I also tested it here on MSSQL and was not able to reproduce. |
|
|
Ah, I did create a fresh db and a fresh site on my IIS7.5 machine with SQL R2 (2008) and found that none of the tables had the identities or default values set. I manually set the identities and defaults for each column specified in the MSSQL.sql file using SSMS. I think there are one or two tables that had primary key constraints that could not be set this way without dropping the constraints, which concerned me more. I'm not sure where to start with your scripting process and ADODB to troubleshoot this. Do you have any ideas? Anyways, once these were properly set now this particular issue is not reoccurring. |
|
|
Well, make sure your DB user has permission to set identities or default values. \admin\install\create-mssql.sql Closing issue. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-04-07 05:37 | medicnick | New Issue | |
| 2011-04-07 14:45 | mdekker | Assigned To | => c_schmitz |
| 2011-04-07 14:45 | mdekker | Status | new => assigned |
| 2011-04-07 14:46 | mdekker | Note Added: 14725 | |
| 2011-04-07 14:47 | mdekker | Note Edited: 14725 | |
| 2011-04-11 06:38 | medicnick | Note Added: 14740 | |
| 2011-04-11 11:15 | c_schmitz | Note Added: 14741 | |
| 2011-04-11 11:15 | c_schmitz | Status | assigned => feedback |
| 2011-04-13 06:48 | medicnick | Note Added: 14806 | |
| 2011-04-13 06:48 | medicnick | Status | feedback => assigned |
| 2011-04-16 16:46 | c_schmitz | Note Added: 14825 | |
| 2011-04-16 16:46 | c_schmitz | Status | assigned => closed |
| 2011-04-16 16:46 | c_schmitz | Resolution | open => unable to reproduce |