|
Not had time to properly diagnose what's going on yet but this fix doesn't work for me. When implemented in build 121115 (note my fix posted works fine), I get:
<h1>CDbException</h1>
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]The data types text and varchar are incompatible in the not equal to operator.. The SQL statement executed was: SELECT * FROM [dbo].[survey_997138] [t] WHERE [997138X21X395] != '' (C:\limesurvey\framework\db\CDbCommand.php:528) #0 C:\limesurvey\framework\db\CDbCommand.php(390): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 C:\limesurvey\framework\db\ar\CActiveRecord.php(1287): CDbCommand->queryAll()
#2 C:\limesurvey\application\models\LSActiveRecord.php(34): CActiveRecord->query(Object(CDbCriteria), true)
#3 C:\limesurvey\framework\db\ar\CActiveRecord.php(1406): LSActiveRecord->query(Object(CDbCriteria), true)
#4 C:\limesurvey\application\controllers\admin\statistics.php(502): CActiveRecord->findAll(Array)
#5 [internal function]: statistics->listcolumn('997138', '997138X21X395', '', '', '')
#6 C:\limesurvey\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(Object(statistics), Array)
#7 C:\limesurvey\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(Object(statistics), Object(ReflectionMethod), Array)
#8 C:\limesurvey\framework\web\CController.php(309): Survey_Common_Action->runWithParams(Array)
#9 C:\limesurvey\framework\web\CController.php(287): CController->runAction(Object(statistics))
#10 C:\limesurvey\framework\web\CController.php(266): CController->runActionWithFilters(Object(statistics), Array)
#11 C:\limesurvey\application\controllers\AdminController.php(159): CController->run('statistics')
#12 C:\limesurvey\framework\web\CWebApplication.php(276): AdminController->run('statistics')
#13 C:\limesurvey\framework\web\CWebApplication.php(135): CWebApplication->runController('admin/statistic...')
#14 C:\limesurvey\framework\base\CApplication.php(162): CWebApplication->processRequest()
#15 C:\limesurvey\index.php(178): CApplication->run()
#16 {main}
When implemented in build 121121, I get (this seems to relate to the new lines of code at 498 - 501:
<h1>PHP Error [2]</h1>
Invalid argument supplied for foreach() (C:\limesurvey_test\application\controllers\admin\statistics.php:499)
#0 C:\limesurvey_test\application\controllers\admin\statistics.php(499): LSYii_Application->handleError()
#1 unknown(0): statistics->listcolumn()
#2 C:\limesurvey_test\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs()
#3 C:\limesurvey_test\application\core\Survey_Common_Action.php(82): statistics->runWithParamsInternal()
#4 C:\limesurvey_test\framework\web\CController.php(309): statistics->runWithParams()
#5 C:\limesurvey_test\framework\web\CController.php(287): AdminController->runAction()
#6 C:\limesurvey_test\framework\web\CController.php(266): AdminController->runActionWithFilters()
#7 C:\limesurvey_test\application\controllers\AdminController.php(159): AdminController->run()
#8 C:\limesurvey_test\framework\web\CWebApplication.php(276): AdminController->run()
#9 C:\limesurvey_test\framework\web\CWebApplication.php(135): LSYii_Application->runController()
#10 C:\limesurvey_test\framework\base\CApplication.php(162): LSYii_Application->processRequest()
#11 C:\limesurvey_test\index.php(178): LSYii_Application->run()
|
