PHP Error - Undefined index

Plus d'informations
il y a 3 ans 7 mois - il y a 3 ans 7 mois #118967 par michaelve
michaelve a créé le sujet : PHP Error - Undefined index
We are currently running a survey and experienced a PHP error after sending out reminders to complete the survey. We run the latest stable version of limesurvey together with a postgres database.

This image shows the error we receive.


It is possible to access the survey and enter the token. Subsequently, the welcome screen is shown. When actually entering the survey with debugging turned on, I receive the following error:

Undefined index: 889163X102X653 -> The first 6 digits contain the survey id.

/var/www/html/limesurvey/application/helpers/frontend_helper.php(821)
  foreach ($_SESSION['survey_'.$surveyid]['insertarray'] as $value)
820         {
821             $email .= "$value: {$_SESSION['survey_'.$surveyid][$value]}\n";
822         }
 
var/www/html/limesurvey/application/helpers/expressions/em_manager_helper.php(5202): submitfailed("")
5201 $message .= $this->gT("Unable to insert record into survey table"); // TODO - add SQL error?
5202                     echo submitfailed('');  // TODO - report SQL error?
/var/www/html/limesurvey/application/helpers/expressions/em_manager_helper.php(5504): LimeExpressionManager->_UpdateValuesInDatabase(array(), false) 
/var/www/html/limesurvey/application/controllers/survey/index.php(579): SurveyRuntimeHelper->ru
/var/www/html/limesurvey/application/helpers/SurveyRuntimeHelper.php(342): LimeExpressionManager::NavigateForwards()

The errors continue for a while; I can send the log by email.

This happened after updating the token table with email addresses and setting invitation sent to 'Y'. However, it is possible to answer uncompleted surveys. Also, I can enter other surveys running on the same instance.

Would anybody have an idea how to resolve this issue?

Thanks!
Pièces jointes :
Dernière édition: il y a 3 ans 7 mois par michaelve. Raison: More elaborate description

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 3 ans 7 mois #118969 par michaelve
michaelve a répondu au sujet : PHP Error - Undefined index
In the meantime I found the solution to the error.

In the process of updating the database the sequences were not updated. The survey and survey timings contained 300 responses; the sequence values were much lower. By restarting the sequences at 301 the survey runs again.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 4 semaines 1 jour #175587 par rizkiheryandi
rizkiheryandi a répondu au sujet : PHP Error - Undefined index

michaelve écrit: In the meantime I found the solution to the error.

In the process of updating the database the sequences were not updated. The survey and survey timings contained 300 responses; the sequence values were much lower. By restarting the sequences at 301 the survey runs again.


How to "restarting the sequences at 301" ?

Connexion ou Créer un compte pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!