View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06394 | Bug reports | Security | public | 2012-07-26 18:38 | 2012-07-27 13:07 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 2.00RC7 | ||||
| Summary | 06394: New install with MySQL, went to force SSL on, got error | ||||
| Description | CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'stg_value' cannot be null. The SQL statement executed was: UPDATE C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\limesurvey\framework\db\CDbCommand.php(354) | ||||
| Steps To Reproduce | Security > Force HTTPS On > get error | ||||
| Tags | No tags attached. | ||||
| Bug heat | 254 | ||||
| Complete LimeSurvey version number (& build) | 2.0 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox 14 | ||||
| Database type & version | MySQL5.1.63 | ||||
| Server OS (if known) | Vista | ||||
| Webserver software & version (if known) | Apache2.2.22 | ||||
| PHP Version | PHP5.3.14 | ||||
| Git branch / Pull Request URL | |||||
|
I am sorry but I cannot reproduce it at all. Does the error always happen or only right after a fresh install? |
|
|
It still does it this morning. I have uploaded the error page (globalsettings.htm) |
|
|
Open \limesurvey\application\controllers\admin\globalsettings.php, edit line 141 setGlobalSetting('emailsmtpssl', sanitize_paranoid_string(returnGlobal('emailsmtpssl'))); to // setGlobalSetting('emailsmtpssl', sanitize_paranoid_string(returnGlobal('emailsmtpssl'))); Try again. Do you still get an error? |
|
|
Still an error, even if I don't edit any setting on Security page. Have uploaded another file. It does let me create a survey, question group and questions. |
|
|
In that case it is a problem with your server configuration which seems to limit the number of variables that can be posted on on page (seems to pretty low in your configuration). Either 'max_input_vars' or you have the Suhosin module installed. Anyway, I am sorry but this is not a LimeSurvey bug. For more help please use the forums. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-07-26 18:38 |
|
New Issue | |
| 2012-07-27 08:17 | c_schmitz | Assigned To | => c_schmitz |
| 2012-07-27 08:17 | c_schmitz | Status | new => assigned |
| 2012-07-27 08:27 | c_schmitz | Note Added: 20009 | |
| 2012-07-27 08:27 | c_schmitz | Status | assigned => feedback |
| 2012-07-27 10:42 |
|
File Added: globalsettings.htm | |
| 2012-07-27 10:42 |
|
Note Added: 20017 | |
| 2012-07-27 10:42 |
|
Status | feedback => assigned |
| 2012-07-27 11:30 | c_schmitz | Note Added: 20020 | |
| 2012-07-27 11:30 | c_schmitz | Status | assigned => feedback |
| 2012-07-27 11:48 |
|
File Added: globalsettings2.htm | |
| 2012-07-27 11:50 |
|
Note Added: 20022 | |
| 2012-07-27 11:50 |
|
Status | feedback => assigned |
| 2012-07-27 13:06 | c_schmitz | File Deleted: globalsettings2.htm | |
| 2012-07-27 13:06 | c_schmitz | File Deleted: globalsettings.htm | |
| 2012-07-27 13:07 | c_schmitz | Note Added: 20025 | |
| 2012-07-27 13:07 | c_schmitz | Status | assigned => closed |
| 2012-07-27 13:07 | c_schmitz | Resolution | open => fixed |
| 2012-07-27 13:07 | c_schmitz | Resolution | fixed => unable to reproduce |