View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
08463Bug reportsCentral participant databasepublic2013-12-17 05:142014-01-08 18:08
Reporterjjxice46 Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.05+ 
Summary08463: Unable to add token to Central Participant Databaase
Description

When attempting to add a contact from a token table to the central participant database you are presented with the following error.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/><title>Internal Server Error</title><style type="text/css">/<![CDATA[/body {font-family:"Verdana";font-weight:normal;color:black;background-color:white;}h1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }h2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }h3 {font-family:"Verdana";font-weight:bold;font-size:11pt}p {font-family:"Verdana";font-weight:normal;color:black;font-size:9pt;margin-top: -5px}.version {color: gray;font-size:8pt;border-top:1px solid #aaaaaa;}/]]>/</style></head><body><h1>Internal Server Error</h1><h2>CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field 'created_by' doesn't have a default value</h2>

An internal error occurred while the Web server was processing your request.Please contact the webmaster to report this problem.

Thank you.

<div class="version">2013-12-17 04:13:15 </div></body></html>

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)Version 2.05+ Build 131209
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMysql 5.6.12
Server OS (if known)Windows Server 2012
Webserver software & version (if known)IIS 8
PHP Version5.4.14
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-12-19 12:56

administrator   ~27644

I cannot reproduce. This sounds like you did not update completely all files?
jjxice46

jjxice46

2013-12-19 13:29

reporter   ~27645

I can go though and try to do a clean update and see if it resolves the issue.
c_schmitz

c_schmitz

2013-12-19 13:47

administrator   ~27646

Please do ;)
c_schmitz

c_schmitz

2014-01-08 16:42

administrator   ~27771

Feedback please?
jjxice46

jjxice46

2014-01-08 16:43

reporter   ~27772

Sorry for the delay ive been out for the holiday.

It seems to be working correctly now so it seems like it was a bad update/install

Thanks for your help
c_schmitz

c_schmitz

2014-01-08 18:08

administrator   ~27780

Okay, thanks.

Issue History

Date Modified Username Field Change
2013-12-17 05:14 jjxice46 New Issue
2013-12-19 12:23 c_schmitz Assigned To => c_schmitz
2013-12-19 12:23 c_schmitz Status new => assigned
2013-12-19 12:56 c_schmitz Note Added: 27644
2013-12-19 12:56 c_schmitz Status assigned => feedback
2013-12-19 13:29 jjxice46 Note Added: 27645
2013-12-19 13:29 jjxice46 Status feedback => assigned
2013-12-19 13:47 c_schmitz Note Added: 27646
2013-12-19 13:47 c_schmitz Status assigned => feedback
2014-01-08 16:42 c_schmitz Note Added: 27771
2014-01-08 16:43 jjxice46 Note Added: 27772
2014-01-08 16:43 jjxice46 Status feedback => assigned
2014-01-08 18:08 c_schmitz Note Added: 27780
2014-01-08 18:08 c_schmitz Status assigned => closed
2014-01-08 18:08 c_schmitz Resolution open => unable to reproduce