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 |