View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
04112Bug reportsOtherpublic2010-02-18 18:19
Reporterakehler Assigned Torakete  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.87+ 
Fixed in Version1.87+ 
Summary04112: Token table does not have default emailStatus
Description

When I insert records using the sInsertParticipants() function of lsrc, the email addresses show up as "Email Address not Valid". I look in the tokens table in the database and I see that the "emailstatus" field is blank.

Additional Information

In lsrc.server.php I see the following starting on line 455:
if ($databasetype == 'odbc_mssql' || $databasetype == 'odbtp' || $databasetype == 'mssql_n')
{
$createtokentable.= "email C(320) ,\n "
."emailstatus C(300) DEFAULT 'OK',\n ";
}
else
{
$createtokentable.= "email X(320) ,\n "
."emailstatus X(300) DEFAULT 'OK',\n ";
}

This should set the default to 'OK'. I checked my database and the emailstatus field did not have a default value. When I attempted to set it, I got an error message stating that you cannot set a default value for a text/blob field.

I modified the emailStatus field to a varchar(255) and set the default value. Now, when I import tokens, the status is appropriately set to 'OK'.

Is there a reason that this field is text/blob rather than varchar?

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)8338
I will donate to the project if issue is resolved
BrowserN/A
Database type & versionmySQL 5.1.37
Server OS (if known)Ubuntu Server 9.10
Webserver software & version (if known)apache2
PHP Version5.2.10

Relationships

related to 04110 closedrakete Email Status can't be set via RemoteControl 

Users monitoring this issue

akehler

Activities

rakete

rakete

2010-02-13 15:49

reporter   ~11079

Bug is solved with solving issue 04110. Email Status will be validated and set accordingly within sInsertParticipants.

Issue History

Date Modified Username Field Change
2010-02-08 22:47 akehler New Issue
2010-02-08 22:47 akehler Status new => assigned
2010-02-08 22:47 akehler Assigned To => rakete
2010-02-08 22:47 akehler LimeSurvey build number => 8338
2010-02-08 22:47 akehler Browser => N/A
2010-02-08 22:47 akehler Database & DB-Version => mySQL 5.1.37
2010-02-08 22:47 akehler Operating System (Server) => Ubuntu Server 9.10
2010-02-08 22:47 akehler Webserver => apache2
2010-02-08 22:47 akehler PHP Version => 5.2.10
2010-02-09 18:30 akehler Issue Monitored: akehler
2010-02-13 15:48 rakete Relationship added related to 04110
2010-02-13 15:49 rakete Note Added: 11079
2010-02-13 15:49 rakete Status assigned => resolved
2010-02-13 15:49 rakete Fixed in Version => 1.87+
2010-02-13 15:49 rakete Resolution open => fixed
2010-02-18 18:19 c_schmitz Status resolved => closed
2011-10-20 18:29 c_schmitz Category RemoteControl => (No Category)
2021-08-03 15:49 guest Bug heat 2 => 4