View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
08482 | Bug reports | Installation | public | 2013-12-20 18:58 | 2014-01-15 12:19 |
Reporter | MassimoSala | Assigned To | c_schmitz | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | duplicate | ||
Product Version | 2.05+ | ||||
Summary | 08482: installation hangs on Linux using MS SQL database | ||||
Description | Page "Pre-installation check" : passed Page "Database configuration" : type = microsoft SQL server (dblib) Page "Database settings" : A database named "LimeSurvey" already exists. Do you want to populate that database now by creating the necessary tables? Page "Optional settings" : nothing changed. The column lime_users.modified is "datetime, not null" but the INSERT statement don't specify the modified value. | ||||
Steps To Reproduce | CentOS 6.5 fresh install Start the installation ... | ||||
Additional Information | see also bug id 07990 ? | ||||
Tags | No tags attached. | ||||
Attached Files | limesurvey_index.php_r_installer_optional.txt (5,405 bytes)
------------------------------------------------------------------ http://srvbggsurvey/limesurvey/index.php?r=installer/optional ------------------------------------------------------------------ Internal Server Error Could not add optional settings: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 515 General SQL Server error: Check messages from the SQL Server [515] (severity 16) [(null)]' in /var/www/limesurvey/framework/db/CDbCommand.php:358 Stack trace: #0 /var/www/limesurvey/framework/db/ar/CActiveRecord.php(1077): CDbCommand->execute() #1 /var/www/limesurvey/framework/db/ar/CActiveRecord.php(806): CActiveRecord->insert(NULL) #2 /var/www/limesurvey/application/controllers/InstallerController.php(640): CActiveRecord->save() #3 /var/www/limesurvey/application/controllers/InstallerController.php(82): InstallerController->stepOptionalConfiguration() #4 /var/www/limesurvey/framework/web/CWebApplication.php(282): InstallerController->run('optional') #5 /var/www/limesurvey/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/optio...') #6 /var/www/limesurvey/framework/base/CApplication.php(180): CWebApplication->processRequest() #7 /var/www/limesurvey/index.php(190): CApplication->run() #8 {main}. An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem. Thank you. ------------------------------------------------------------------ freetds log ------------------------------------------------------------------ 18:50:20.002178:Sending packet 0000 01 01 01 7d 00 00 00 00-49 4e 53 45 52 54 20 49 |...}.... INSERT I| 0010 4e 54 4f 20 5b 64 62 6f-5d 2e 5b 6c 69 6d 65 5f |NTO [dbo ].[lime_| 0020 75 73 65 72 73 5d 20 28-5b 75 73 65 72 73 5f 6e |users] ( [users_n| 0030 61 6d 65 5d 2c 20 5b 68-74 6d 6c 65 64 69 74 6f |ame], [h tmledito| 0040 72 6d 6f 64 65 5d 2c 20-5b 74 65 6d 70 6c 61 74 |rmode], [templat| 0050 65 65 64 69 74 6f 72 6d-6f 64 65 5d 2c 20 5b 71 |eeditorm ode], [q| 0060 75 65 73 74 69 6f 6e 73-65 6c 65 63 74 6f 72 6d |uestions electorm| 0070 6f 64 65 5d 2c 20 5b 64-61 74 65 66 6f 72 6d 61 |ode], [d ateforma| 0080 74 5d 2c 20 5b 70 61 73-73 77 6f 72 64 5d 2c 20 |t], [pas sword], | 0090 5b 66 75 6c 6c 5f 6e 61-6d 65 5d 2c 20 5b 70 61 |[full_na me], [pa| 00a0 72 65 6e 74 5f 69 64 5d-2c 20 5b 65 6d 61 69 6c |rent_id] , [email| 00b0 5d 2c 20 5b 63 72 65 61-74 65 64 5d 2c 20 5b 6c |], [crea ted], [l| 00c0 61 6e 67 5d 29 20 56 41-4c 55 45 53 20 28 27 61 |ang]) VA LUES ('a| 00d0 64 6d 69 6e 27 2c 20 27-64 65 66 61 75 6c 74 27 |dmin', ' default'| 00e0 2c 20 27 64 65 66 61 75-6c 74 27 2c 20 27 64 65 |, 'defau lt', 'de| 00f0 66 61 75 6c 74 27 2c 20-31 2c 20 27 35 65 38 38 |fault', 1, '5e88| 0100 34 38 39 38 64 61 32 38-30 34 37 31 35 31 64 30 |4898da28 047151d0| 0110 65 35 36 66 38 64 63 36-32 39 32 37 37 33 36 30 |e56f8dc6 29277360| 0120 33 64 30 64 36 61 61 62-62 64 64 36 32 61 31 31 |3d0d6aab bdd62a11| 0130 65 66 37 32 31 64 31 35-34 32 64 38 27 2c 20 27 |ef721d15 42d8', '| 0140 41 64 6d 69 6e 69 73 74-72 61 74 6f 72 27 2c 20 |Administ rator', | 0150 30 2c 20 27 79 6f 75 72-2d 65 6d 61 69 6c 40 65 |0, 'your -email@e| 0160 78 61 6d 70 6c 65 2e 6e-65 74 27 2c 20 47 45 54 |xample.n et', GET| 0170 44 41 54 45 28 29 2c 20-27 65 6e 27 29 |DATE(), 'en')| 18:50:20.002301:Changed query state from PENDING to READING 18:50:20.007776:Received packet 0000 04 01 00 eb 00 6c 01 00-aa 9a 00 03 02 00 00 02 |.....l.. ........| 0010 10 82 00 43 61 6e 6e 6f-74 20 69 6e 73 65 72 74 |...Canno t insert| 0020 20 74 68 65 20 76 61 6c-75 65 20 4e 55 4c 4c 20 | the val ue NULL | 0030 69 6e 74 6f 20 63 6f 6c-75 6d 6e 20 27 6d 6f 64 |into col umn 'mod| 0040 69 66 69 65 64 27 2c 20-74 61 62 6c 65 20 27 4c |ified', table 'L| 0050 69 6d 65 53 75 72 76 65-79 2e 64 62 6f 2e 6c 69 |imeSurve y.dbo.li| 0060 6d 65 5f 75 73 65 72 73-27 3b 20 63 6f 6c 75 6d |me_users '; colum| 0070 6e 20 64 6f 65 73 20 6e-6f 74 20 61 6c 6c 6f 77 |n does n ot allow| 0080 20 6e 75 6c 6c 73 2e 20-49 4e 53 45 52 54 20 66 | nulls. INSERT f| 0090 61 69 6c 73 2e 0c 53 52-56 42 47 47 53 51 4c 30 |ails..SR VBGGSQL0| 00a0 30 31 00 01 00 ab 3a 00-25 0e 00 00 00 00 22 00 |01....:. %.....".| 00b0 54 68 65 20 73 74 61 74-65 6d 65 6e 74 20 68 61 |The stat ement ha| 00c0 73 20 62 65 65 6e 20 74-65 72 6d 69 6e 61 74 65 |s been t erminate| 00d0 64 2e 0c 53 52 56 42 47-47 53 51 4c 30 30 31 00 |d..SRVBG GSQL001.| 00e0 01 00 fd 02 00 c3 00 00-00 00 00 |........ ...| ------------------------------------------------------------------ cat /etc/freetds.conf ------------------------------------------------------------------ [global] # TDS protocol version ; tds version = 4.2 # Whether to write a TDSDUMP file for diagnostic purposes # (setting this to /tmp is insecure on a multi-user system) dump file = /tmp/freetds.log debug flags = 0x203e # Command and connection timeouts ; timeout = 10 ; connect timeout = 10 # If you get out-of-memory errors, it may mean that your client # is trying to allocate a huge buffer for a TEXT field. # Try setting 'text size' to a more reasonable limit text size = 64512 | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 131219 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | Microsoft SQL Server 2005 | ||||
Server OS (if known) | CentOS 6.5 | ||||
Webserver software & version (if known) | Firefox 19 | ||||
PHP Version | PHP 5.3.3 | ||||
The same error installing on MySQL : The server is the same, with these packages : mysql-server-5.1.71 php-mysql-5.3.3. |
|
Fixed using this LS version : |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2013-12-20 18:58 | MassimoSala | New Issue | |
2013-12-20 18:58 | MassimoSala | File Added: limesurvey_index.php_r_installer_optional.txt | |
2013-12-31 11:06 | MassimoSala | Note Added: 27706 | |
2014-01-08 11:24 | mdekker | Relationship added | related to 08439 |
2014-01-08 11:27 | MassimoSala | Note Added: 27758 | |
2014-01-15 12:19 | c_schmitz | Status | new => closed |
2014-01-15 12:19 | c_schmitz | Assigned To | => c_schmitz |
2014-01-15 12:19 | c_schmitz | Resolution | open => duplicate |
2014-01-15 12:19 | c_schmitz | Relationship replaced | duplicate of 08439 |