View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04112 | Bug reports | Other | public | 2010-02-08 22:47 | 2010-02-18 18:19 |
Reporter | akehler | Assigned To | rakete | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.87+ | ||||
Fixed in Version | 1.87+ | ||||
Summary | 04112: 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: 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? | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 8338 | ||||
I will donate to the project if issue is resolved | |||||
Browser | N/A | ||||
Database type & version | mySQL 5.1.37 | ||||
Server OS (if known) | Ubuntu Server 9.10 | ||||
Webserver software & version (if known) | apache2 | ||||
PHP Version | 5.2.10 | ||||
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 |