test data not being stored, causing corruption message

Bugs Reports and Useful Links

test data not being stored, causing corruption message

Postby cornernote » Tue Mar 05, 2013 6:57 am

Hello,

We are getting this error frequently on tests:

We are sorry, but this test is corrupted and thus inaccessible. Please visit the done tests list to delete this test execution.
More info
#0 /home/.../efront/libraries/includes/module_tests.php(278): require_once()
#1 /home/.../efront/www/professor.php(433): require_once('/home/...')
#2 {main}


I checked in module_tests.php(278), which was this line:
Code: Select all
require_once("tests/show_solved_test.php");


I checked in show_solved_test.php, and found this to be the trigger of the error:
Code: Select all
        if (!$completedTest = unserialize($result[0]['test'])) {
            throw new EfrontTestException(_TESTCORRUPTEDORNOTACOMPLETEDTEST, EfrontTestException::CORRUPTED_TEST);
        }


I checked in the database, as follows:
Code: Select all
SELECT test FROM completed_tests_blob WHERE completed_tests_ID = show_solved_test(from the URL)


The test data was null.

Please let me know what I can do to find out why our test data is not being stored.

Thanks for your time reading this.
cornernote
 
Posts: 11
Joined: Wed Feb 20, 2013 11:37 pm

Re: test data not being stored, causing corruption message

Postby periklis » Tue Mar 05, 2013 9:55 am

make sure that php's magic_quotes_gpc is not turned to "on"
Periklis Venakis
eFront- eLearning and Skill Development Solution for Companies and Educational Institutes
Consider our wide range of added-value services to get things running smoothly on your eLearning environment
periklis
 
Posts: 4326
Joined: Thu Oct 04, 2007 10:54 am

Re: test data not being stored, causing corruption message

Postby cornernote » Wed Mar 06, 2013 7:47 am

Hi periklis,

Thanks for your response. magic_quotes_gpc is turned off according to phpinfo().

Do you have any other ideas of things I can check?
cornernote
 
Posts: 11
Joined: Wed Feb 20, 2013 11:37 pm

Re: test data not being stored, causing corruption message

Postby periklis » Wed Mar 06, 2013 8:35 am

which version of efront are you using?
Periklis Venakis
eFront- eLearning and Skill Development Solution for Companies and Educational Institutes
Consider our wide range of added-value services to get things running smoothly on your eLearning environment
periklis
 
Posts: 4326
Joined: Thu Oct 04, 2007 10:54 am

Re: test data not being stored, causing corruption message

Postby connect » Wed Mar 06, 2013 11:22 pm

Educational edition - 3.6.12 Build 17736
connect
 
Posts: 208
Joined: Wed Jul 30, 2008 1:11 am

Re: test data not being stored, causing corruption message

Postby periklis » Thu Mar 07, 2013 7:29 am

can you please have a look at the "completed_tests_blob" database table and see if it has any contents?
Periklis Venakis
eFront- eLearning and Skill Development Solution for Companies and Educational Institutes
Consider our wide range of added-value services to get things running smoothly on your eLearning environment
periklis
 
Posts: 4326
Joined: Thu Oct 04, 2007 10:54 am

Re: test data not being stored, causing corruption message

Postby connect » Sun Mar 10, 2013 11:46 pm

Can you please provide more information as to where I can find 'completed_tests_blob' ? :?
connect
 
Posts: 208
Joined: Wed Jul 30, 2008 1:11 am

Re: test data not being stored, causing corruption message

Postby cornernote » Mon Mar 11, 2013 12:12 am

connect wrote:Can you please provide more information as to where I can find 'completed_tests_blob' ? :?


Hello, This was done in the OP:

I checked in the database, as follows:
SELECT test FROM completed_tests_blob WHERE completed_tests_ID = show_solved_test(from the URL)

The test data was null.

Its not truncated/corrupt. Its NULL (completely empty).
cornernote
 
Posts: 11
Joined: Wed Feb 20, 2013 11:37 pm

Re: test data not being stored, causing corruption message

Postby cornernote » Mon Mar 11, 2013 4:14 am

Hello,

I have an update that helps better explain when the corruption occurs. We can replicate this issue every time with the steps listed below.


1) student login: submit a new test that has not been used before by this student

In the database the completed_tests_blob.test field is saved with data.


2) professor login: submit a zero score to fail the test

In the database the completed_tests_blob.test field still has data.


3) student login: click redo

In the database the completed_tests_blob.test field is saved as NULL.


Interestingly when you repeat steps 2-3, the issue does not reoccur. It only ever erases the first test data.


I hope this helps to isolate the cause of this issue.
cornernote
 
Posts: 11
Joined: Wed Feb 20, 2013 11:37 pm

Re: test data not being stored, causing corruption message

Postby periklis » Wed Mar 13, 2013 10:12 am

Hello,
we have indentified the issue and a fix is underway
Periklis Venakis
eFront- eLearning and Skill Development Solution for Companies and Educational Institutes
Consider our wide range of added-value services to get things running smoothly on your eLearning environment
periklis
 
Posts: 4326
Joined: Thu Oct 04, 2007 10:54 am

Next

Return to Bugs

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron