View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
08482Bug reportsInstallationpublic2014-01-15 12:19
ReporterMassimoSala Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionduplicate 
Product Version2.05+ 
Summary08482: 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?
I click [Populate database].
NOTE: checking the db, at this step LimeSurvey has created the tables "lime_xxx".

Page "Optional settings" : nothing changed.
I click [Next].
ERROR ! please see the attached file.

The column lime_users.modified is "datetime, not null" but the INSERT statement don't specify the modified value.
If I change modified to "datetime, null" ... the installer fails on another table.column !

Steps To Reproduce

CentOS 6.5 fresh install
Linux 2.6.32-431.el6.i686
PHP 5.3.3
mssql library : FreeTDS
Microsoft SQL Server 2005

Start the installation ...
http://srvbggsurvey/limesurvey/admin/admin.php

Additional Information

see also bug id 07990 ?

TagsNo 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 heat2
Complete LimeSurvey version number (& build)131219
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMicrosoft SQL Server 2005
Server OS (if known)CentOS 6.5
Webserver software & version (if known)Firefox 19
PHP VersionPHP 5.3.3

Relationships

duplicate of 08439 closedc_schmitz Installer optional settings (6) not saved: error 1048 column stg_value cannot be null 

Users monitoring this issue

There are no users monitoring this issue.

Activities

MassimoSala

MassimoSala

2013-12-31 11:06

reporter   ~27706

The same error installing on MySQL :
"Internal Server Error
Could not add optional settings: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'stg_value' cannot be null' in /var/www/limesurvey/framework/db/CDbCommand.php:358"

The server is the same, with these packages : mysql-server-5.1.71 php-mysql-5.3.3.

MassimoSala

MassimoSala

2014-01-08 11:27

reporter   ~27758

Fixed using this LS version :
limesurvey200plus-build131206.tar.gz

Issue History

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