iRecord is running extremely slowly this morning. After-effects of yesterday's upgrade?

Submitted by DavidDee on

Not working at all for me. Tried entering a record. Very slow; mapping not working properly, ultimately got a failure message with paragraphs of jargon when I tried to submit it. Next tried to verify some records but cn't even get to that page, the site just gives up completely. 


Submitted by iRecord support 3 on Tue, 20/06/2023 - 13:02


Although the site is back up and running, ongoing work to re-structure and keep up with demand for image storage (currently over 6 million photos) may mean that the site is running slowly for a few days before ultimately improving. Apologies for any inconvenience.

Submitted by Snowdome on Tue, 20/06/2023 - 14:58


I managed to get a few records on this morning but now just getting the below error when trying to navigate to record entry page. 


cUrl POST request failed. Please check cUrl is installed on the server and the $base_url setting is correct.
Server response
{"error":"There was an SQL error: ERROR: could not open file \"base\/14163077\/147600240\": No such file or directory - \n SELECT as \"id\",\ng.title as \"title\",\ng.description as \"description\",\ngt.term as \"group_type\"\n FROM groups g\n JOIN groups_users gu ON AND gu.deleted=false AND gu.user_id=94893\n JOIN group_pages gp ON AND gp.deleted=false AND (gp.administrator=false OR gu.administrator=true)\n AND gp.path = 'enter-casual-record'\n JOIN cache_termlists_terms gt on\n \n\n WHERE g.deleted = false\n AND (g.website_id in (23) or g.website_id is null)\n ORDER BY g.title","code":44,"file":"D:\\websites\\warehouse\\system\\libraries\\drivers\\Database\\Pgsql.php","line":368,"trace":[]}

The website encountered an unexpected error. Please try again later.

Submitted by Snowdome on Tue, 20/06/2023 - 15:26


Got to entry page for a list of records and then received this error when submitting the records. 


  • The data could not be saved.
  • Validation errors occurred when this form was submitted to the server. The form configuration may be incorrect as it appears the controls associated with these messages are missing from the form.<ul><li>There was an SQL error: ERROR: index "fki_sample_attribute_values_created_by_id" contains unexpected zero page at block 0 HINT: Please REINDEX it. - INSERT INTO "sample_attribute_values" ("upper_value", "text_value", "sample_id", "sample_attribute_id", "created_on", "created_by_id", "updated_on", "updated_by_id") VALUES (NULL, 'David', 22461727, 36, '20230620 15:24:22', 94893, '20230620 15:24:22', 94893)<br/>&nbsp;&nbsp; (related to attribute )</li><li>An error occurred: There was an SQL error: ERROR: current transaction is aborted, commands ignored until end of transaction block - SELECT column_name, column_default, is_nullable, data_type, udt_name, character_maximum_length, numeric_precision, numeric_precision_radix, numeric_scale FROM information_schema.columns WHERE table_name = 'occurrences' AND table_schema != 'information_schema' ORDER BY ordinal_position <br/>&nbsp;&nbsp; (related to attribute )</li></ul>