View Issue Details

This issue affects 1 person(s).
 254
IDProjectCategoryView StatusLast Update
06394Bug reportsSecuritypublic2012-07-27 13:07
Reporteruser21040Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version2.00RC7 
Summary06394: 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 lime_settings_global SET stg_name=:yp0, stg_value=:yp1 WHERE lime_settings_global.stg_name='emailsmtpssl'

C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\limesurvey\framework\db\CDbCommand.php(354)

Steps To Reproduce

Security > Force HTTPS On > get error

TagsNo tags attached.
Bug heat254
Complete LimeSurvey version number (& build)2.0
I will donate to the project if issue is resolvedNo
BrowserFirefox 14
Database type & versionMySQL5.1.63
Server OS (if known)Vista
Webserver software & version (if known)Apache2.2.22
PHP VersionPHP5.3.14
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-07-27 08:27

administrator   ~20009

I am sorry but I cannot reproduce it at all. Does the error always happen or only right after a fresh install?

user21040

2012-07-27 10:42

  ~20017

It still does it this morning. I have uploaded the error page (globalsettings.htm)

c_schmitz

c_schmitz

2012-07-27 11:30

administrator   ~20020

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?

user21040

2012-07-27 11:50

  ~20022

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.

c_schmitz

c_schmitz

2012-07-27 13:07

administrator   ~20025

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.

Issue History

Date Modified Username Field Change
2012-07-26 18:38 user21040 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 user21040 File Added: globalsettings.htm
2012-07-27 10:42 user21040 Note Added: 20017
2012-07-27 10:42 user21040 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 user21040 File Added: globalsettings2.htm
2012-07-27 11:50 user21040 Note Added: 20022
2012-07-27 11:50 user21040 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