Dear Open foris team, We have problem with system error on open foris collect when we connected via website, that happen when we updated on version 4.0.36 and 4.037 also. Could you please let me know how to fix this. Many thanks The error showed: System Error Please report this error to the Open Foris team: SQL [null]; batch entry 1: [SQLITE_TOOBIG] String or BLOB exceeds size limit (statement too long)

alt text

asked 30 Dec '21, 17:02

HaiPham's gravatar image

accept rate: 0%

Dear user,
When does this error occur? Does it occur when you try to import data in Collect format (.collect-data) from Data Management?
Probably the size of the record you are trying to restore is too big... We will try to solve this issue with version 4.0.38 of Collect, meanwhile we will contact you to your private email so you can share with us your survey and the data your are trying to restore.
Many thanks,
Open Foris Team

permanent link

answered 31 Dec '21, 00:23

OF%20Collect's gravatar image

OF Collect ♦♦
accept rate: 23%

Dear OF team, The problem occured when our colleagues imported Collect format (.collect-data) to our data mangement website, and would liked added more record in the tree table, we have already updated to 4.0.38. That happend when we updated to 4.0.36. Please help us to resolve problem Many thanks

permanent link

answered 04 Jan, 03:55

HaiPham's gravatar image

accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 30 Dec '21, 17:02

question was seen: 57 times

last updated: 04 Jan, 03:55