Exception

Error: Failed to insert data in response table<br />

/media/shnoulle/data/webdev/master/application/helpers/admin/import_helper.php(2626)

2614                             } else {
2615                                 if (in_array($sFieldname, $DestinationFields)) {
2616                                     $aInsertData[$sFieldname] = '';
2617                                 }
2618                             }
2619                         }
2620                         try {
2621                             $iNewID = SurveyDynamic::model($iSurveyID)->insertRecords($aInsertData);
2622                             if (!$iNewID) {
2623                                 throw new Exception("Error, no entry id was returned.", 1);
2624                             }
2625                         } catch (Exception $e) {
2626                             throw new Exception(gT("Error") . ": Failed to insert data in response table<br />");
2627                         }
2628                         $results['responses']++;
2629                     }
2630                 }
2631             }
2632         }
2633         $oXMLReader->close();
2634 
2635         switchMSSQLIdentityInsert('survey_' . $iSurveyID, false);
2636         if (Yii::app()->db->getDriverName() == 'pgsql') {
2637             try {
2638                 Yii::app()->db->createCommand("SELECT pg_catalog.setval(pg_get_serial_sequence('" . $survey->responsesTableName . "', 'id'), (SELECT MAX(id) FROM " . $survey->responsesTableName . "))")->execute();

Stack Trace

#0
+
–
 /media/shnoulle/data/webdev/master/application/helpers/admin/import_helper.php(1242): XMLImportResponses()
1237 
1238             // Step 2 - import the responses file
1239             foreach ($aFiles as $aFile) {
1240                 if (pathinfo((string) $aFile['filename'], PATHINFO_EXTENSION) == 'lsr') {
1241                     //Import the LSS file
1242                     $aResponseImportResults = XMLImportResponses(Yii::app()->getConfig('tempdir') . DIRECTORY_SEPARATOR . $aFile['filename'], $aImportResults['newsid'], $aImportResults['FieldReMap']);
1243                     $aImportResults = array_merge($aResponseImportResults, $aImportResults);
1244                     $aImportResults['importwarnings'] = array_merge($aImportResults['importwarnings'], $aImportResults['warnings']);
1245                     unlink(Yii::app()->getConfig('tempdir') . DIRECTORY_SEPARATOR . $aFile['filename']);
1246                     break;
1247                 }
#1
+
–
 /media/shnoulle/data/webdev/master/application/controllers/SurveyAdministrationController.php(2277): importSurveyFile()
2272 
2273             // Now, we have the survey : start importing
2274             Yii::app()->loadHelper('admin/import');
2275 
2276             if ($action == 'importsurvey' && !$aData['bFailed']) {
2277                 $aImportResults = importSurveyFile($sFullFilepath, (Yii::app()->request->getPost('translinksfields') == '1'));
2278                 if (is_null($aImportResults)) {
2279                     $aImportResults = array(
2280                         'error' => gT("Unknown error while reading the file, no survey created.")
2281                     );
2282                 }
#10
+
–
 /media/shnoulle/data/webdev/master/application/controllers/LSBaseController.php(145): CController->run()
140                     $this->redirect(array('/admin/authentication/sa/login'));
141                 }
142             }
143         }
144 
145         parent::run($action);
146     }
147 
148     /**
149      * Load and set session vars
150      *
2024-09-16 10:18:24 nginx/1.22.1 Yii Framework/1.1.29