View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 14
IDProjectCategoryView StatusDate SubmittedLast Update
06263Bug reportsStatisticspublic2012-06-22 22:312012-07-18 13:48
ReporterTMSWhite Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionduplicate 
Product Version2.00RC4 
Summary06263: unable to browse responses
Description

Clicking "responses and statistics" button yields this error:

( ! ) PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ls2.lime_tokens_722461' doesn't exist in C:\xampp\htdocs\ls2\framework\db\CDbCommand.php on line 497 Call Stack #TimeMemoryFunctionLocation 10.0008352096{main}( )..\index.php:0 20.02432018752CApplication->run( )..\index.php:171 30.02432018752CWebApplication->processRequest( )..\CApplication.php:162 40.02472019176CWebApplication->runController( )..\CWebApplication.php:135 50.192615202472AdminController->run( )..\CWebApplication.php:276 60.219415291528CController->run( )..\AdminController.php:158 70.232116320904CController->runActionWithFilters( )..\CController.php:266 80.232116320904CController->runAction( )..\CController.php:287 90.232116320904Survey_Common_Action->runWithParams( )..\CController.php:309 100.232316326200CAction->runWithParamsInternal( )..\Survey_Common_Action.php:82 110.232316326864ReflectionMethod->invokeArgs( )..\CAction.php:107 120.232316326880browse->index( )..\CAction.php:107 130.432317666152CDbSchema->getTable( )..\browse.php:428 140.432317666264CMysqlSchema->loadTable( )..\CDbSchema.php:104 150.432417667080CMysqlSchema->findColumns( )..\CMysqlSchema.php:120 160.432417668096CDbCommand->queryAll( )..\CMysqlSchema.php:160 170.432517668472CDbCommand->queryInternal( )..\CDbCommand.php:390 180.432517669952PDOStatement->execute( )..\CDbCommand.php:497 ( ! ) CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ls2.lime_tokens_722461' doesn't exist. The SQL statement executed was: SHOW COLUMNS FROM lime_tokens_722461 in C:\xampp\htdocs\ls2\framework\db\CDbCommand.php on line 528 Call Stack #TimeMemoryFunctionLocation 10.0008352096{main}( )..\index.php:0 20.02432018752CApplication->run( )..\index.php:171 30.02432018752CWebApplication->processRequest( )..\CApplication.php:162 40.02472019176CWebApplication->runController( )..\CWebApplication.php:135 50.192615202472AdminController->run( )..\CWebApplication.php:276 60.219415291528CController->run( )..\AdminController.php:158 70.232116320904CController->runActionWithFilters( )..\CController.php:266 80.232116320904CController->runAction( )..\CController.php:287 90.232116320904Survey_Common_Action->runWithParams( )..\CController.php:309 100.232316326200CAction->runWithParamsInternal( )..\Survey_Common_Action.php:82 110.232316326864ReflectionMethod->invokeArgs( )..\CAction.php:107 120.232316326880browse->index( )..\CAction.php:107 130.432317666152CDbSchema->getTable( )..\browse.php:428 140.432317666264CMysqlSchema->loadTable( )..\CDbSchema.php:104 150.432417667080CMysqlSchema->findColumns( )..\CMysqlSchema.php:120 160.432417668096CDbCommand->queryAll( )..\CMysqlSchema.php:160 170.432517668472CDbCommand->queryInternal( )..\CDbCommand.php:390
PHP warning
Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\ls2\framework\db\CDbCommand.php:497)

C:\xampp\htdocs\ls2\application\core\Survey_Common_Action.php(199)

187 $aData['sImageURL'] = Yii::app()->getConfig('adminimageurl');
188
189 $aData = $this->_addPseudoParams($aData);
190 $aViewUrls = (array) $aViewUrls;
191 $sViewPath = '/admin/';
192
193 if (!empty($sAction))
194 {
195 $sViewPath .= $sAction . '/';
196 }
197
198 // Send HTTP header
199 header("Content-type: text/html; charset=UTF-8"); // needed for correct UTF-8 encoding
200
201
202 // Header
203 if(!isset($aData['display']['header']) || $aData['display']['header'] !== false)
204 {
205 Yii::app()->getController()->_getAdminHeader();
206 }
207
208
209 // Menu bars
210 if (!isset($aData['display']['menu_bars']) || ($aData['display']['menu_bars'] !== false && (!is_array($aData['display']['menu_bars']) || !in_array('browse', array_keys($aData['display']['menu_bars'])))))
211 {
Stack Trace
#0
– C:\xampp\htdocs\ls2\application\core\Survey_Common_Action.php(199): header("Content-type: text/html; charset=UTF-8")
194 {
195 $sViewPath .= $sAction . '/';
196 }
197
198 // Send HTTP header
199 header("Content-type: text/html; charset=UTF-8"); // needed for correct UTF-8 encoding
200
201
202 // Header
203 if(!isset($aData['display']['header']) || $aData['display']['header'] !== false)
204 {
#1
– C:\xampp\htdocs\ls2\application\controllers\admin\browse.php(937): Survey_Common_Action->_renderWrappedTemplate("browse", array("browseindex_view"), array("iSurveyId" => 722461, "surveyid" => 722461, "clang" => Limesurvey_lang, "imageurl" => "/ls2/images", ...))
932 $this->getController()->_js_admin_includes(Yii::app()->getConfig('adminscripts') . 'browse.js');
933
934 $aData['display']['menu_bars'] = false;
935 $aData['display']['menu_bars']['browse'] = Yii::app()->lang->gT('Browse responses'); // browse is independent of the above
936
937 parent::_renderWrappedTemplate('browse', $aViewUrls, $aData);
938 }
939
940 }
#2
– C:\xampp\htdocs\ls2\application\controllers\admin\browse.php(435): browse->_renderWrappedTemplate("", array("browseindex_view"), array("iSurveyId" => 722461, "surveyid" => 722461, "clang" => Limesurvey_lang, "imageurl" => "/ls2/images", ...))
430 {
431 $aData['tokeninfo'] = Tokens_dynamic::model($iSurveyId)->summary();
432 }
433
434 $aViewUrls[] = 'browseindex_view';
435 $this->_renderWrappedTemplate('',$aViewUrls, $aData);
436 }
437 function browse($iSurveyId)
438 {
439 $aData = $this->_getData($iSurveyId);
440 extract($aData);
#3
unknown(0): browse->index("722461")
#4

  • C:\xampp\htdocs\ls2\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(browse, array("722461"))
    #5
  • C:\xampp\htdocs\ls2\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(browse, ReflectionMethod, array("surveyid" => "722461", "sa" => "index", "iSurveyId" => "722461", "iSurveyID" => "722461"))
    #6
  • C:\xampp\htdocs\ls2\framework\web\CController.php(309): Survey_Common_Action->runWithParams(array("surveyid" => "722461", "sa" => "index"))
    #7
  • C:\xampp\htdocs\ls2\framework\web\CController.php(287): CController->runAction(browse)
    #8
  • C:\xampp\htdocs\ls2\framework\web\CController.php(266): CController->runActionWithFilters(browse, array())
    #9
  • C:\xampp\htdocs\ls2\application\controllers\AdminController.php(158): CController->run("browse")
    #10
  • C:\xampp\htdocs\ls2\framework\web\CWebApplication.php(276): AdminController->run("browse")
    #11
  • C:\xampp\htdocs\ls2\framework\web\CWebApplication.php(135): CWebApplication->runController("admin/browse/sa/index")
    #12
  • C:\xampp\htdocs\ls2\framework\base\CApplication.php(162): CWebApplication->processRequest()
    #13
  • C:\xampp\htdocs\ls2\index.php(171): CApplication->run()
    2012-06-22 22:30:41 Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 Yii Framework/1.1.10
TagsNo tags attached.
Bug heat14
Complete LimeSurvey version number (& build)120624
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMysql 5.3
Server OS (if known)Windows XP
Webserver software & version (if known)XAMPP
PHP Version5.3

Relationships

Relationship GraphDependency Graph
related to 06259 closedc_schmitz PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ls2.lime_surveys' doesn't exist 
has duplicate 06162 closedc_schmitz unable to list surveys 

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-06-22 23:31

administrator   ~19496

Works just fine here. Can you please attach the survey as archive (.zip)
TMSWhite

TMSWhite

2012-06-22 23:49

reporter   ~19501

Weird, works fine on Linux (with a very different configuration).

However, odd that I'm not seeing the PDO exception on Windows, or the

Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\ls2\framework\db\CDbCommand.php:497)

message.
c_schmitz

c_schmitz

2012-06-23 18:01

administrator   ~19524

The main error is that the table ls2.lime_tokens_722461 is missing. Why?
DenisChenu

DenisChenu

2012-06-23 18:20

developer   ~19527

Last edited: 2012-06-23 18:20

We don't test if survey exist and is active, try
index.php/admin/browse/index/surveyid/111111111 (a false id)
or
index.php/admin/browse/index/surveyid/none (a bad id)

Errro gestion -> no error_view
TMSWhite

TMSWhite

2012-06-24 02:26

reporter   ~19532

@c_schmitz - The tokens table was missing because the survey was active but not using tokens.
c_schmitz

c_schmitz

2012-07-06 10:01

administrator   ~19635

TMSWhite: Yeah, same here but I still don't get the error here. Can you attach your database please?
TMSWhite

TMSWhite

2012-07-07 23:29

reporter   ~19679

@c_schmitz - the core problem may be the Yii logging function - see http://bugs.limesurvey.org/view.php?id=6259#c19676 [^]

Issue History

Date Modified Username Field Change
2012-06-22 22:31 TMSWhite New Issue
2012-06-22 23:31 c_schmitz Note Added: 19496
2012-06-22 23:31 c_schmitz Assigned To => c_schmitz
2012-06-22 23:31 c_schmitz Status new => feedback
2012-06-22 23:49 TMSWhite Note Added: 19501
2012-06-22 23:49 TMSWhite Status feedback => assigned
2012-06-23 18:01 c_schmitz Note Added: 19524
2012-06-23 18:07 c_schmitz Status assigned => feedback
2012-06-23 18:20 DenisChenu Note Added: 19527
2012-06-23 18:20 DenisChenu Note Edited: 19527
2012-06-24 02:26 TMSWhite Note Added: 19532
2012-06-24 02:26 TMSWhite Status feedback => assigned
2012-07-06 10:01 c_schmitz Note Added: 19635
2012-07-06 10:01 c_schmitz Status assigned => feedback
2012-07-06 10:03 c_schmitz Relationship added has duplicate 06162
2012-07-07 23:13 TMSWhite Relationship added related to 06259
2012-07-07 23:29 TMSWhite Note Added: 19679
2012-07-07 23:29 TMSWhite Status feedback => assigned
2012-07-18 13:48 c_schmitz Status assigned => closed
2012-07-18 13:48 c_schmitz Resolution open => duplicate