Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

PHP Error - Undefined index

  • michaelve
  • michaelve's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 1 week ago - 9 years 1 week ago #118967 by michaelve
PHP Error - Undefined index was created by michaelve
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.

Code:
/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!
Attachments:
Last edit: 9 years 1 week ago by michaelve. Reason: More elaborate description
The topic has been locked.
  • michaelve
  • michaelve's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 1 week ago #118969 by michaelve
Replied by michaelve on topic 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.
The topic has been locked.
More
5 years 6 months ago #175587 by rizkiheryandi
Replied by rizkiheryandi on topic PHP Error - Undefined index

michaelve wrote: 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" ?
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source