View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05305 | Bug reports | Theme editor | public | 2011-06-26 19:40 | 2011-09-28 06:37 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | urgent | Severity | crash | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 1.91+ | ||||
| Summary | 05305: SQL Error when copying template | ||||
| Description | Upon copying the limespired template using the template editor, I came across the following error: Table 'limesurvey.lime_tokens_1295' doesn't exist:SELECT * FROM I can no longer access the template editor. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 16 | ||||
| Complete LimeSurvey version number (& build) | 10315 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | MySQL | ||||
| Server OS (if known) | Ubuntu 8.04 | ||||
| Webserver software & version (if known) | Apache 2 | ||||
| PHP Version | 5.2.4 | ||||
| Git branch / Pull Request URL | |||||
|
I cannot reproduce:
Please report back. |
|
|
? |
|
|
Problem seems to exist for more people. A quick code scan reviews the 'fake' data used for the template preview uses a survey with the specified id 1295 Tried some stuff with admin and no-admin accounts but was unable to reproduce. Please provide buildnumber and detailed steps to reproduce the problem. |
|
|
Does the token table "*_tokens_1295" exists for template preview? |
|
|
No, and it does not need to. |
|
|
@Menno: Yes, there have been a couple reports about this but unless there is new feedback about this issue imho it does not make sense to re-open it. |
|
|
Is there a way to remove the "fake" data from the code? Would that prevent the code from searching for this table? |
|
|
@Carsten: as people report it there clearly is a problem, probably for a very small minority of the people but if we put the reports together it might help sorting things out. @Anyone who has the problem: please report here if you use the very latest 1.91+ version and if the problem still exists. If you don't use the latest version, please upgrade and check to see if it persists. If you can provide steps to reproduce the problem that would be very helpful. Think about browser name+version, what type of account do you use (super admin or not), order of steps taken, more than one window open at the time etc. etc. Can you reproduce on a different system or browser? The fake data is needed to generate the preview, so it will not be removed. It should not be a problem as the survey 1295 should not exist. If possible, please check your database to see if you have any table ending with survey_1295. Normally you have no table ending in 1295 that is perfectly normal. |
|
|
Seems not. Anway - the bug tracker always allows for anyone to reopen a issue. If you can give feedback, just do it. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-06-26 19:40 |
|
New Issue | |
| 2011-06-26 20:46 |
|
Issue Monitored: user14645 | |
| 2011-06-28 18:10 | c_schmitz | Assigned To | => c_schmitz |
| 2011-06-28 18:10 | c_schmitz | Status | new => assigned |
| 2011-06-28 18:27 | c_schmitz | Note Added: 15585 | |
| 2011-06-28 18:27 | c_schmitz | Status | assigned => feedback |
| 2011-07-02 22:33 | c_schmitz | Note Added: 15618 | |
| 2011-07-05 17:50 | c_schmitz | Status | feedback => closed |
| 2011-07-05 17:50 | c_schmitz | Resolution | open => unable to reproduce |
| 2011-07-06 06:15 | cougarsyankeesfan | Issue Monitored: cougarsyankeesfan | |
| 2011-07-06 06:15 | cougarsyankeesfan | Issue End Monitor: cougarsyankeesfan | |
| 2011-07-06 06:15 | cougarsyankeesfan | Issue Monitored: cougarsyankeesfan | |
| 2011-07-06 12:31 | mdekker | Relationship added | has duplicate 05322 |
| 2011-07-06 12:32 | mdekker | Note Added: 15656 | |
| 2011-07-06 12:32 | mdekker | Status | closed => feedback |
| 2011-07-06 12:32 | mdekker | Resolution | unable to reproduce => reopened |
| 2011-07-06 12:59 | mdekker | Note Edited: 15656 | |
| 2011-07-06 20:17 | mot | Note Added: 15661 | |
| 2011-07-06 22:16 | c_schmitz | Note Added: 15662 | |
| 2011-07-06 22:28 | c_schmitz | Note Added: 15663 | |
| 2011-07-06 22:29 | c_schmitz | Issue End Monitor: user14645 | |
| 2011-07-07 02:10 | cougarsyankeesfan | Note Added: 15665 | |
| 2011-07-07 09:54 | mdekker | Note Added: 15667 | |
| 2011-07-12 15:59 | c_schmitz | Note Added: 15744 | |
| 2011-07-12 15:59 | c_schmitz | Status | feedback => closed |
| 2011-07-12 15:59 | c_schmitz | Resolution | reopened => unable to reproduce |
| 2011-09-28 06:36 | lazycai | Issue Monitored: lazycai | |
| 2011-09-28 06:37 | lazycai | Issue End Monitor: lazycai | |
| 2015-12-11 14:40 | c_schmitz | Category | Templates => Theme editor |