View Issue Details

This issue affects 1 person(s).
 16
IDProjectCategoryView StatusLast Update
05305Bug reportsTheme editorpublic2011-09-28 06:37
Reporteruser14645Assigned Toc_schmitz  
PriorityurgentSeveritycrash 
Status closedResolutionunable to reproduce 
Product Version1.91+ 
Summary05305: 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 lime_tokens_1295 WHERE token='1234567'

I can no longer access the template editor.

TagsNo tags attached.
Bug heat16
Complete LimeSurvey version number (& build)10315
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL
Server OS (if known)Ubuntu 8.04
Webserver software & version (if known)Apache 2
PHP Version5.2.4
Git branch / Pull Request URL

Relationships

has duplicate 05322 closedmdekker 05305: SQL Error when copying template 

Users monitoring this issue

cougarsyankeesfan

Activities

c_schmitz

c_schmitz

2011-06-28 18:27

administrator   ~15585

I cannot reproduce:

  • Is this an updated installation. If yes, did you use the COmfortUpdater to do that? If, yes, try to do a manual update to the latest version an report if the issue was resolved.
  • Check out the upload/templates dir if the directory for the copied template was created and if all files were copied from the /templates/<original_template> dir.

Please report back.
Thank you!

c_schmitz

c_schmitz

2011-07-02 22:33

administrator   ~15618

?

mdekker

mdekker

2011-07-06 12:32

reporter   ~15656

Last edited: 2011-07-06 12:59

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.

mot

mot

2011-07-06 20:17

reporter   ~15661

Does the token table "*_tokens_1295" exists for template preview?

c_schmitz

c_schmitz

2011-07-06 22:16

administrator   ~15662

No, and it does not need to.

c_schmitz

c_schmitz

2011-07-06 22:28

administrator   ~15663

@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.

cougarsyankeesfan

cougarsyankeesfan

2011-07-07 02:10

reporter   ~15665

Is there a way to remove the "fake" data from the code? Would that prevent the code from searching for this table?

mdekker

mdekker

2011-07-07 09:54

reporter   ~15667

@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.

c_schmitz

c_schmitz

2011-07-12 15:59

administrator   ~15744

Seems not. Anway - the bug tracker always allows for anyone to reopen a issue. If you can give feedback, just do it.

Issue History

Date Modified Username Field Change
2011-06-26 19:40 user14645 New Issue
2011-06-26 20:46 user14645 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