View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
05095Bug reportsSurvey editingpublic2011-05-04 19:31
Reportermedicnick Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.91RC5 
Fixed in Version1.91 
Summary05095: Survey Timings table does not exist
Description

It appears that the timings table is not created.

Steps To Reproduce

When choosing to get response statistics the following error is returned:
Couldn't get response data
SELECT count(*) FROM [ems_survey_16452_timings] NATURAL JOIN [ems_survey_16452] WHERE submitdate IS NOT NULL
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.

Additional Information

The timings table does not exist in the database. This was selected prior to activating the survey, I do not know why it was not created.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)9995
I will donate to the project if issue is resolvedNo
BrowserFF4
Database type & versionMSSQL R2
Server OS (if known)WIN 2008
Webserver software & version (if known)IIS7
PHP Version5.2.5

Users monitoring this issue

There are no users monitoring this issue.

Activities

medicnick

medicnick

2011-04-07 08:33

reporter   ~14716

I deactivated a different survey and received another error:
Couldn't make backup of the survey timings table. Please try again. The database reported the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]No item by the name of 'ems_survey_84415_timings' could be found in the current database '{DB Name}', given that @itemtype was input as '(null)'.

mdekker

mdekker

2011-04-07 14:35

reporter   ~14720

If you didn't start with a clean installation it could be a let over of some old bug that has already been fixed. I remember one of the beta or RC didn't create the timings table. Could you try activating a survey to see if it creates the timings table?

medicnick

medicnick

2011-04-08 06:24

reporter   ~14735

Do you mean deactivate then reactivate? This is not a new issue for this one survey, none of my surveys have a timings table.

c_schmitz

c_schmitz

2011-04-11 14:05

administrator   ~14779

yeah, but this could have been fixed meanwhile.
That's why Menno asked you to try and deactivate and reactivate one of the survey with that problem to see if the timins table is created.
If the timings table was not created due to some bug in the past it won't magically appear ;).

So, can you please try?

medicnick

medicnick

2011-04-13 06:44

reporter   ~14805

I have created a new survey (now at RC6) and the timings table was not created. Which file has the scripting to generate the table? I can do it manually and make sure that the response data is actually recorded if the table exists.

c_schmitz

c_schmitz

2011-04-16 16:29

administrator   ~14823

Thank you!

Issue History

Date Modified Username Field Change
2011-04-07 05:47 medicnick New Issue
2011-04-07 08:33 medicnick Note Added: 14716
2011-04-07 14:35 mdekker Note Added: 14720
2011-04-08 06:24 medicnick Note Added: 14735
2011-04-09 18:46 c_schmitz Assigned To => c_schmitz
2011-04-09 18:46 c_schmitz Status new => assigned
2011-04-11 14:05 c_schmitz Note Added: 14779
2011-04-11 14:05 c_schmitz Status assigned => feedback
2011-04-13 06:44 medicnick Note Added: 14805
2011-04-13 06:44 medicnick Status feedback => assigned
2011-04-16 16:29 c_schmitz Note Added: 14823
2011-04-16 16:29 c_schmitz Status assigned => resolved
2011-04-16 16:29 c_schmitz Fixed in Version => 1.91
2011-04-16 16:29 c_schmitz Resolution open => fixed
2011-05-04 19:31 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing