View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
09306Bug reportsOtherpublic2014-11-16 18:30
ReporterAlunisiira Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionduplicate 
Product Version2.05+ 
Summary09306: Table "_tid_seq" didn't exist
Description

I got an sql error when i was deactivating my survey.
It's a fresh installation and i didn't create any surveys but just imported one. So at deactivationg following page is shown:

"Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "_tid_seq" does not exist

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you."

Here is the sql log file entry:
"2014-10-16 11:39:42 CEST ERROR: relation "_tid_seq" does not exist
2014-10-16 11:39:42 CEST STATEMENT: ALTER TABLE "_tid_seq" RENAME TO "_tid_seq""

i guess it's produced by the following line 331: application/controllers/admin/surveyadmin.php line 326:
"
//See if there is a tokens table for this survey
if (tableExists("{{tokens_{$iSurveyID}}}"))
{
if (Yii::app()->db->getDriverName() == 'pgsql')
{
$deactivateresult = Yii::app()->db->createCommand()->renameTable($toldtable . '_tid_seq', $tnewtable . '_tid_seq');
$setsequence = "ALTER TABLE ".Yii::app()->db->quoteTableName($tnewtable)." ALTER COLUMN tid SET DEFAULT nextval('{{{$tnewtable}}}_tid_seq'::regclass);";
$deactivateresult = Yii::app()->db->createCommand($setsequence)->query();
$setidx = "ALTER INDEX {{{$toldtable}}}_idx RENAME TO {{{$tnewtable}}}_idx;";
$deactivateresult = Yii::app()->db->createCommand($setidx)->query();
}
"

Finally this relation definitly doesn't exist. The only table with "t" is templates. I looked through the rest of my log file but the installation didn't show any errors.

Steps To Reproduce

Fresh installation of Limesurvey
Import survey
Start survey
(Add a user with Token and invite him ...)
Deactivate survey

Additional Information

Postgre SQL 9.3, php 5.5.9, ubuntu apache 2 20120211

i tried to attach the survey but it is 2.3 mb and i can't upload it. And i can't choose to not load anything up anymore. So just one unimportant python development script. I'm sorry for that.

TagsNo tags attached.
Attached Files
tests.py (134 bytes)   
import os

liste = []

for root, dir, files in os.walk("/home/raid1/jzelmer/programmierkrams/input"):
  liste = files
  
print (liste)
tests.py (134 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)141003
I will donate to the project if issue is resolvedNo
BrowserFirefox Ubuntu
Database type & versionPostgre SQL 9.3
Server OS (if known)Ubuntu 14.04
Webserver software & version (if known)apache 2 20120211
PHP Version5.5.9

Relationships

duplicate of 09282 closedc_schmitz Deactivating survey with tokens fails with postgres 

Users monitoring this issue

There are no users monitoring this issue.

Activities

kettner

kettner

2014-10-22 09:29

reporter   ~30847

Hello, we have exactly the same problem with similar configuration - (Ubuntu, Postgres, Apache) - fresh instalation of 2.05+ latest release, however recently updated from 1.92+.

May I possibly ask when this issue could be solved? Just in case we would need to terminate some surveys soon...

Many thanks.

Issue History

Date Modified Username Field Change
2014-10-16 13:15 Alunisiira New Issue
2014-10-16 13:15 Alunisiira File Added: tests.py
2014-10-22 09:29 kettner Note Added: 30847
2014-11-16 18:30 c_schmitz Relationship added duplicate of 09282
2014-11-16 18:30 c_schmitz Status new => closed
2014-11-16 18:30 c_schmitz Assigned To => c_schmitz
2014-11-16 18:30 c_schmitz Resolution open => duplicate