View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05546 | Bug reports | Survey editing | public | 2011-10-31 16:41 | 2011-10-31 18:36 |
| Reporter | bnosie | Assigned To | c_schmitz | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | won't fix | ||
| Product Version | 1.91+ | ||||
| Summary | 05546: Unable to create or import surveys on build 11232 | ||||
| Description | Brand new installation, with MSSQL 2008 db, using mssql_n. Installation ran fine, but am not able to create or import surveys. When importing, get the following error: Error: Failed to insert data Trying to create a new one just gives the insert query. Running the insert queries directly on the database, I get the following error: Cannot insert the value NULL into column 'startdate', table 'LimeSurvey.dbo.surveys'; column does not allow nulls. INSERT fails. Looking at the surveys table, there are 52 columns that are set to 'not null', but the insert queries are only inserting 44 values. If I put in a value for STARTDATE, it then fails on EXPIRES. Next if fails on ADDITIONAL_LANGUAGES, which isn't even in the query. | ||||
| Steps To Reproduce | Create or import any query. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 11232 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | MSSQL 2008 SP2 | ||||
| Server OS (if known) | Windows 2003 R2 | ||||
| Webserver software & version (if known) | Apache 2.2.3 | ||||
| PHP Version | 5.2.16 | ||||
| Git branch / Pull Request URL | |||||
|
The table creation script which ran during the installation did not appear to create the tables correctly, as several of the columns which should have been set to 'default NULL' were set to 'default NOT NULL'. I tried recreating it with 2 prior versions and they did the same thing. I manually created the tables with the create_mssql.sql scripts, and it appears to be working fine. I could not determine what script was being called during installation, or why it wouldn't create the tables correctly. I have 2 other installations on MSSQL 2008, on on this same server, and one on another, and I did not have this issue before. |
|
|
I guess it is because you are using the mssql_n driver which is clealy marked as being 'experimental'. Try one of the other drivers, preferabley mssql_odbc or mssqlnative. This won't be fixed anymore because version 2.0 will have a new db driver architecture so fixed on old drivers are obsolete. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-10-31 16:41 | bnosie | New Issue | |
| 2011-10-31 18:17 | bnosie | Note Added: 16574 | |
| 2011-10-31 18:36 | c_schmitz | Note Added: 16575 | |
| 2011-10-31 18:36 | c_schmitz | Status | new => closed |
| 2011-10-31 18:36 | c_schmitz | Assigned To | => c_schmitz |
| 2011-10-31 18:36 | c_schmitz | Resolution | open => won't fix |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |