# Error when trying to download experiment data form database

**URL:** <https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394>\
**Category:** Online experiments\
**Created:** [October 14, 2019, 3:26pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394 "2019-10-14T15:26:44Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![lrier](https://avatars.discourse-cdn.com/v4/letter/l/ea5d25/32.png) [@lrier](https://discourse.psychopy.org/u/lrier)\
**Post date:** [October 14, 2019, 3:26pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/1 "2019-10-14T15:26:44Z")

</div>

I am trying to download data from a completed run of my experiment from the database via my dashboard on pavlovia ([https://pavlovia.org/lr/megabit\_n\_back](https://pavlovia.org/lr/megabit_n_back)).

All I get is the following error

Is there anything I need to change in the experiment settings?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/psychopy/original/3X/c/c/ccd4ff9103c72f7a0d35b28fe73cb4f08c345a4a.png)

---

<div class="post-metadata">

**Author:** ![apitiot](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@apitiot](https://discourse.psychopy.org/u/apitiot)\
**Post date:** [October 18, 2019, 9:41am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/2 "2019-10-18T09:41:06Z")

</div>

Hello @lrier,

Some of the special characters in your experiment results were not dealt with adequately, which created that particular error.  
I am now dealing with them in a much more robust manner, and your results are correctly collated into a .csv file.  
Many apologies for the mishap!  
Best wishes,

Alain

---

<div class="post-metadata">

**Author:** ![cami94](https://avatars.discourse-cdn.com/v4/letter/c/51bf81/32.png) [@cami94](https://discourse.psychopy.org/u/cami94)\
**Post date:** [March 29, 2020, 9:05pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/3 "2020-03-29T21:05:26Z")

</div>

Hi, I am getting the same message - how did you fix it ?

 ![Skärmavbild 2020-03-29 kl. 17.50.46](https://us1.discourse-cdn.com/flex002/uploads/psychopy/original/3X/d/f/df10594c9023f48ad0782d6f4504cac0e0aa3628.png)

---

<div class="post-metadata">

**Author:** ![apitiot](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@apitiot](https://discourse.psychopy.org/u/apitiot)\
**Post date:** [March 29, 2020, 9:42pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/4 "2020-03-29T21:42:20Z")

</div>

Hello @cami94,

You just encountered a small regression in the code. I’ve just fixed it.  
You’re good to go 🙂

Alain

---

<div class="post-metadata">

**Author:** ![cami94](https://avatars.discourse-cdn.com/v4/letter/c/51bf81/32.png) [@cami94](https://discourse.psychopy.org/u/cami94)\
**Post date:** [March 29, 2020, 9:50pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/5 "2020-03-29T21:50:16Z")

</div>

thank you!!

---

<div class="post-metadata">

**Author:** ![Wendyli159](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.psychopy.org/wendyli159/32/7253_2.png) [@Wendyli159](https://discourse.psychopy.org/u/Wendyli159)\
**Post date:** [April 2, 2020, 4:12pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/6 "2020-04-02T16:12:10Z")

</div>

I encountered the same problem here @apitiot  
Experiment link:  
[https://pavlovia.org/run/Wendyli159/semantic-category-judgment-task/html/](https://pavlovia.org/run/Wendyli159/semantic-category-judgment-task/html/)

Error message  
when downloading the experiment results:

_{“origin”:“[http://pavlovia.org/api/v2/experiments/Wendyli159/semantic-category-judgment-task/results",“context”:"when](http://pavlovia.org/api/v2/experiments/Wendyli159/semantic-category-judgment-task/results%22,%22context%22:%22when) getting the results of an experiment”,“pathWithNamespace”:“Wendyli159/semantic-category-judgment-task”,“experiment”:{“gitlabId”:21619,“avatarUrl”:"",“creationDate”:“2020-03-31 01:46:29.808”,“creatorId”:4080,“description”:"",“gitlabUrl”:“[https://gitlab.pavlovia.org/Wendyli159/semantic-category-judgment-task.git",“name”:"semantic](https://gitlab.pavlovia.org/Wendyli159/semantic-category-judgment-task.git%22,%22name%22:%22semantic) category judgment task”,“nbForks”:0,“nbStars”:0,“pathWithNamespace”:“Wendyli159/semantic-category-judgment-task”,“pavloviaScore”:0,“platform”:“PSYCHOJS”,“recruitment”:{“policy”:{“type”:“URL”,“url”:“[https://run.pavlovia.org/Wendyli159/semantic-category-judgment-task/html",“singleRun”:false}},“runMode”:“CREDIT”,“saveFormat”:“CSV”,“status”:“INACTIVE”,“status2”:“RUNNING”,“updateDate”:"2020-04-02](https://run.pavlovia.org/Wendyli159/semantic-category-judgment-task/html%22,%22singleRun%22:false%7D%7D,%22runMode%22:%22CREDIT%22,%22saveFormat%22:%22CSV%22,%22status%22:%22INACTIVE%22,%22status2%22:%22RUNNING%22,%22updateDate%22:%222020-04-02) 16:11:49”,“userIds”:[4080],“visibility”:“private”,“lastActivationDate”:“2020-04-01 02:25:01”,“nbSessions”:1,“pavloviaUrl”:“[https://run.pavlovia.org/Wendyli159/semantic-category-judgment-task/html",“htmlPath”:"/html/",“version”:“2020.1”},“isOwnedByUser”:true,“error”:"error](https://run.pavlovia.org/Wendyli159/semantic-category-judgment-task/html%22,%22htmlPath%22:%22/html/%22,%22version%22:%222020.1%22%7D,%22isOwnedByUser%22:true,%22error%22:%22error) when preparing the result archive, exitStatus: 3072”,“errorCode”:null,“httpStatusCode”:500}_

If the error persists, contact Pavlovia’s administrator.

Is there a way to fix it?

---

<div class="post-metadata">

**Author:** ![apitiot](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@apitiot](https://discourse.psychopy.org/u/apitiot)\
**Post date:** [April 3, 2020, 7:57am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/7 "2020-04-03T07:57:41Z")

</div>

Hello @Wendyli159,

The issue had to do with your not having any data to download. So the server complained, correctly, but [pavlovia.org](http://pavlovia.org) did not handle that complaint correctly. I will fix that this morning.  
That being said, you now have two results, it appears. I have just tried to download them and it worked perfectly. Would you like to give it a try yourself?  
Cheers,

Alain

---

<div class="post-metadata">

**Author:** ![GioP](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.psychopy.org/giop/32/5851_2.png) [@GioP](https://discourse.psychopy.org/u/GioP)\
**Post date:** [April 3, 2020, 8:58am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/8 "2020-04-03T08:58:33Z")

</div>

Sorry to bother you, but I am also having the same (or at least a similar) problem:

_{“origin”:“[http://pavlovia.org/api/v2/experiments/kobebest/mrep/results",“context”:"when](http://pavlovia.org/api/v2/experiments/kobebest/mrep/results%22,%22context%22:%22when) getting the results of an experiment”,“pathWithNamespace”:“kobebest/mrep”,“experiment”:{“gitlabId”:21901,“avatarUrl”:"",“creationDate”:“2020-04-01 08:02:58.621”,“creatorId”:2598,“description”:"",“gitlabUrl”:“[https://gitlab.pavlovia.org/kobebest/mrep.git",“name”:“MRep\_Test”,“nbForks”:0,“nbStars”:0,“pathWithNamespace”:“kobebest/mrep”,“pavloviaScore”:0,“platform”:“PSYCHOJS”,“recruitment”:{“policy”:{“type”:“URL”,“url”:“https://run.pavlovia.org/kobebest/mrep/html”,“singleRun”:false}},“runMode”:“CREDIT”,“saveFormat”:“CSV”,“status”:“INACTIVE”,“status2”:“PILOTING”,“updateDate”:"2020-04-03](https://gitlab.pavlovia.org/kobebest/mrep.git%22,%22name%22:%22MRep_Test%22,%22nbForks%22:0,%22nbStars%22:0,%22pathWithNamespace%22:%22kobebest/mrep%22,%22pavloviaScore%22:0,%22platform%22:%22PSYCHOJS%22,%22recruitment%22:%7B%22policy%22:%7B%22type%22:%22URL%22,%22url%22:%22https://run.pavlovia.org/kobebest/mrep/html%22,%22singleRun%22:false%7D%7D,%22runMode%22:%22CREDIT%22,%22saveFormat%22:%22CSV%22,%22status%22:%22INACTIVE%22,%22status2%22:%22PILOTING%22,%22updateDate%22:%222020-04-03) 08:52:48”,“userIds”:[2598,4973],“visibility”:“public”,“lastActivationDate”:“2020-04-01 17:03:03”,“nbSessions”:1,“pavloviaUrl”:“[https://run.pavlovia.org/kobebest/mrep/html",“htmlPath”:"/html/",“version”:“2020.1”,“keywords”:[“mental\_representation”,“test”,“pilot”]},“isOwnedByUser”:true,“error”:"error](https://run.pavlovia.org/kobebest/mrep/html%22,%22htmlPath%22:%22/html/%22,%22version%22:%222020.1%22,%22keywords%22:%5B%22mental_representation%22,%22test%22,%22pilot%22%5D%7D,%22isOwnedByUser%22:true,%22error%22:%22error) when preparing the result archive, exitStatus: 3072”,“errorCode”:null,“httpStatusCode”:500}_

---

<div class="post-metadata">

**Author:** ![apitiot](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@apitiot](https://discourse.psychopy.org/u/apitiot)\
**Post date:** [April 3, 2020, 10:08am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/9 "2020-04-03T10:08:52Z")

</div>

I have just fixed the issue I mentioned above.

Incidentally, your experiment is currently in PILOTING mode and was either never in RUNNING mode or no session was run when it was in RUNNING mode. Consequently, no experiment results are stored on the server.  
When you change the experiment status to RUNNING, you will be able to download your results using the [Download Results] button.  
Cheers,

Alain

---

<div class="post-metadata">

**Author:** ![Wendyli159](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.psychopy.org/wendyli159/32/7253_2.png) [@Wendyli159](https://discourse.psychopy.org/u/Wendyli159)\
**Post date:** [April 3, 2020, 3:14pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/10 "2020-04-03T15:14:48Z")

</div>

Thanks Alain! it works now.

---

<div class="post-metadata">

**Author:** ![Wendyli159](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.psychopy.org/wendyli159/32/7253_2.png) [@Wendyli159](https://discourse.psychopy.org/u/Wendyli159)\
**Post date:** [April 3, 2020, 3:18pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/11 "2020-04-03T15:18:01Z")

</div>

However, only the results collected in the running model were downloaded. The pilot result does not. I don’t really need the pilot result, so I am not worried about that. Just let you know how it works now.

Thank you a lot for your quick reply!

Wendy

---

<div class="post-metadata">

**Author:** ![apitiot](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@apitiot](https://discourse.psychopy.org/u/apitiot)\
**Post date:** [April 3, 2020, 3:20pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/12 "2020-04-03T15:20:25Z")

</div>

The PILOTING results are indeed not stored on the server: they are immediately downloaded at the end of your PILOTING session.

I am glad that all is well!  
Happy experimenting 🙂

Alain

---

<div class="post-metadata">

**Author:** ![Wendyli159](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.psychopy.org/wendyli159/32/7253_2.png) [@Wendyli159](https://discourse.psychopy.org/u/Wendyli159)\
**Post date:** [April 3, 2020, 3:22pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/13 "2020-04-03T15:22:20Z")

</div>

Oh I see! Thank you!!!

---

<div class="post-metadata">

**Author:** ![Frank\_Fang](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.psychopy.org/frank_fang/32/10412_2.png) [@Frank\_Fang](https://discourse.psychopy.org/u/Frank_Fang)\
**Post date:** [September 2, 2020, 6:07am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/14 "2020-09-02T06:07:57Z")

</div>

Hi, Sorry to bother, I encountered the same problem today, here the link of my project:  
“[https://pavlovia.org/xuanyufang/fangthesisgroup1](https://pavlovia.org/xuanyufang/fangthesisgroup1)”  
It shows me 15 data in the database, but I couldn’t download it.

---

<div class="post-metadata">

**Author:** ![apitiot](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@apitiot](https://discourse.psychopy.org/u/apitiot)\
**Post date:** [September 4, 2020, 10:40am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/15 "2020-09-04T10:40:20Z")

</div>

Hello @Frank_Fang,

Your experiment is in piloting mode. Consequently, as explained above, results are not saved in the database. And so there is nothing for you to download.  
For those results to be saved in the database, you would need to change your experiment to running mode, and assign credits to it.  
You will find more information about the matter on our experiment documentation page: [https://pavlovia.org/docs/experiments/piloting-running](https://pavlovia.org/docs/experiments/piloting-running)

Alain

---

<div class="post-metadata">

**Author:** ![JKugel](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.psychopy.org/jkugel/32/8229_2.png) [@JKugel](https://discourse.psychopy.org/u/JKugel)\
**Post date:** [October 9, 2020, 7:49pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/16 "2020-10-09T19:49:53Z")

</div>

Hi,

Also getting an error. The error says:

"Error when downloading the experiment results:

_"\r\n504 Gateway Time-out\r\n\r\n_

# _504 Gateway Time-out_

_\r\nnginx\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n"_

If the error persists, contact Pavlovia’s administrator."

I’ve previously downloaded experiments from the task without any problems.

Edit: There is a lot of data (\>400 participants) - perhaps this is contributing to the problem.

---

<div class="post-metadata">

**Author:** ![carah12](https://avatars.discourse-cdn.com/v4/letter/c/ba9def/32.png) [@carah12](https://discourse.psychopy.org/u/carah12)\
**Post date:** [December 2, 2020, 4:15pm UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/17 "2020-12-02T16:15:07Z")

</div>

I have the same error code appearing. I have previously been able to download my data but have not done so since getting a large influx of participants.

Is it just the size of the data causing a problem?

> **[SART Trial 1 \[PsychoPy\]](https://run.pavlovia.org/morvenhogg/sart/html/)**

---

<div class="post-metadata">

**Author:** ![JKugel](https://sea2.discourse-cdn.com/flex002/user_avatar/discourse.psychopy.org/jkugel/32/8229_2.png) [@JKugel](https://discourse.psychopy.org/u/JKugel)\
**Post date:** [December 3, 2020, 2:09am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/18 "2020-12-03T02:09:30Z")

</div>

Probably. That’s what the issue was for me. The PsychoPy team were able to assist and send me a different link to get the data.

---

<div class="post-metadata">

**Author:** ![carah12](https://avatars.discourse-cdn.com/v4/letter/c/ba9def/32.png) [@carah12](https://discourse.psychopy.org/u/carah12)\
**Post date:** [December 3, 2020, 9:36am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/19 "2020-12-03T09:36:15Z")

</div>

@apitiot would you be able to lend me some assistance with getting my data? Thank you!

---

<div class="post-metadata">

**Author:** ![apitiot](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@apitiot](https://discourse.psychopy.org/u/apitiot)\
**Post date:** [December 3, 2020, 9:44am UTC](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394/20 "2020-12-03T09:44:52Z")

</div>

Hello @carah12,

The issue had indeed to do with an excessive amount of logs, and so your result file was huge.  
I have just dealt with it. You should be able to download it now, from your dashboard.  
Cheers,

Alain

[Next page](https://discourse.psychopy.org/t/error-when-trying-to-download-experiment-data-form-database/9394.md?page=2)