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 | ||||
| Git branch / Pull Request URL | |||||
|
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 |