View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
09468Bug reportsSurvey editingpublic2015-01-20 18:162015-01-30 14:12
ReporterDenisChenu Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.06+ 
Fixed in Version2.06+ 
Summary09468: Unable to activate survey
Description

Totally unable to activate survey

Steps To Reproduce

Try to activate a survey :
Fatal error: Call to undefined function createTable() in /htdocs/limesurvey_GIT/206/application/helpers/admin/activate_helper.php on line 379

==== This one fixed but:

system.db.CDbCommand

CDbCommand::execute() failed: SQLSTATE[42000]: Syntax error or access
violation: 1064 You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'string(20) NOT NULL,
startdate datetime NOT NULL,
datestamp datetime NOT N' at line 5. The SQL statement executed was:
CREATE TABLE lime_survey_282267 (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
submitdate datetime,
lastpage int(11),
startlanguage string(20) NOT NULL,
startdate datetime NOT NULL,
datestamp datetime NOT NULL,
282267X6X20 text,
.....

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)150120
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionMysql 5
Server OS (if known)debian/linux
Webserver software & version (if known)apache
PHP VersionPHP Version 5.4.4

Relationships

Relationship GraphDependency Graph
related to 09483 closedc_schmitz Crash when initializating tokens table 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2015-01-23 15:56

developer   ~31482

Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14852
DenisChenu

DenisChenu

2015-01-23 16:56

developer   ~31483

Partial fix, still unactivabel.
See : https://github.com/LimeSurvey/LimeSurvey/commit/20533db7dad4bd45af098ef7e524d0e00220f983#commitcomment-9397177
DenisChenu

DenisChenu

2015-01-25 12:43

developer   ~31486

Maybe using ISO name : CHARACTER VARYING(20) / CHARACTER VARYING(36) if non Unicode CHAR.
aesteban

aesteban

2015-01-29 11:58

developer   ~31534

I'm changing status of this bug. I'm still unable to activate a survey: Database error in 'surveytablecreation'.
c_schmitz

c_schmitz

2015-01-29 14:48

administrator   ~31549

Works fine for me ?
aesteban

aesteban

2015-01-30 02:07

developer   ~31559

It works with mysql for me too, but not with postgresql. Did you tried with postgresql?
DenisChenu

DenisChenu

2015-01-30 08:26

developer   ~31563

Not tested ... (no time)
c_schmitz

c_schmitz

2015-01-30 14:12

administrator   ~31567

Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14897

Related Changesets

LimeSurvey: 2.06 a7e37eda

2015-01-23 14:55:54

DenisChenu

Details Diff 		Dev: remove validateTemplateDir from common, update to models/Template
Dev: fix template in Survey model after find : maybe add templateurl and templatedirectory ?
Dev: filter template by user rigth too.
Dev: partial fix for 09468 use new function, but still broken		 Affected Issues
09468
mod - application/controllers/PrintanswersController.php Diff File
mod - application/controllers/RegisterController.php Diff File
mod - application/controllers/Statistics_userController.php Diff File
mod - application/controllers/admin/globalsettings.php Diff File
mod - application/controllers/admin/printablesurvey.php Diff File
mod - application/controllers/admin/questions.php Diff File
mod - application/controllers/admin/surveyadmin.php Diff File
mod - application/helpers/admin/activate_helper.php Diff File
mod - application/helpers/common_helper.php Diff File
mod - application/helpers/frontend_helper.php Diff File
mod - application/helpers/qanda_helper.php Diff File
mod - application/models/Survey.php Diff File
mod - application/models/Template.php Diff File
mod - application/views/statistics_user_view.php Diff File

LimeSurvey: 2.06 f6c06030

2015-01-26 10:09:41

sammousa

Details Diff 		Dev Fixed database upgrade errors Affected Issues
09468
mod - application/core/db/MssqlSchema.php Diff File
mod - application/core/db/MysqlSchema.php Diff File
mod - application/core/db/PgsqlSchema.php Diff File
mod - application/helpers/update/updatedb_helper.php Diff File

LimeSurvey: 2.06 57fa5c3a

2015-01-30 13:12:00

c_schmitz

Details Diff 		Fixed issue 09468: Unable to activate survey
Fixed issue 09483: Crash when initializating tokens table		 Affected Issues
09468, 09483
mod - application/core/db/DbConnection.php Diff File
mod - application/core/db/SmartColumnTypeTrait.php Diff File

Issue History

Date Modified Username Field Change
2015-01-20 18:16 DenisChenu New Issue
2015-01-20 18:16 DenisChenu Summary Unable to actovate survey => Unable to activate survey
2015-01-23 15:56 DenisChenu Changeset attached => LimeSurvey 2.06 a7e37eda
2015-01-23 15:56 DenisChenu Note Added: 31482
2015-01-23 15:56 DenisChenu Assigned To => DenisChenu
2015-01-23 15:56 DenisChenu Resolution open => fixed
2015-01-23 16:54 DenisChenu Assigned To DenisChenu =>
2015-01-23 16:56 DenisChenu Note Added: 31483
2015-01-23 16:58 DenisChenu Steps to Reproduce Updated
2015-01-23 16:59 DenisChenu Severity minor => block
2015-01-23 16:59 DenisChenu Reproducibility have not tried => always
2015-01-23 16:59 DenisChenu Resolution fixed => open
2015-01-25 12:38 DenisChenu Assigned To => sammousa
2015-01-25 12:38 DenisChenu Status new => assigned
2015-01-25 12:43 DenisChenu Note Added: 31486
2015-01-28 15:09 DenisChenu Status assigned => resolved
2015-01-28 15:09 DenisChenu Fixed in Version => 2.06+
2015-01-28 15:09 DenisChenu Resolution open => fixed
2015-01-28 15:10 DenisChenu Changeset attached => LimeSurvey 2.06 f6c06030
2015-01-29 11:43 aesteban Relationship added related to 09483
2015-01-29 11:58 aesteban Note Added: 31534
2015-01-29 11:58 aesteban Status resolved => assigned
2015-01-29 14:48 c_schmitz Note Added: 31549
2015-01-30 02:07 aesteban Note Added: 31559
2015-01-30 08:26 DenisChenu Note Added: 31563
2015-01-30 14:11 c_schmitz Status assigned => closed
2015-01-30 14:11 c_schmitz Assigned To sammousa => c_schmitz
2015-01-30 14:12 c_schmitz Changeset attached => LimeSurvey 2.06 57fa5c3a
2015-01-30 14:12 c_schmitz Note Added: 31567
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing