Running ‘testthat.R’ [3s/7s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > 
  > testthat::test_check("preregr");
  Loading required package: preregr
  
  Attaching package: 'preregr'
  
  The following object is masked from 'package:base':
  
      source
  
  The value you passed as `x` (https://docs.google.com/spreadsheets/d/1l3N0bWnKlRvXuHO-JFg3XHdWzgJWLNli90bnUUa5op4) matched the regular expression for extracting a Google Sheet identifier (^https://docs\.google\.com/spreadsheets/d/([a-zA-Z0-9_-]*)(/.*)?$), so proceeding to extract that.
  You set `exportGoogleSheet=TRUE`, so I will export the spreadsheet as an xlsx file which I will store as a temporary file and then import.
  trying URL 'https://docs.google.com/spreadsheets/d/1l3N0bWnKlRvXuHO-JFg3XHdWzgJWLNli90bnUUa5op4/export?format=xlsx'
  downloaded 207 KB
  
  Succesfully downloaded the file.
  The extension of the file is `xlsx`, and you specified {readxl and writexl} as the package to use to read Excel files, so starting to read the data with those parameters.
  Succesfully imported spreadsheet.
  Returning result.
  The value you passed as `x` (https://docs.google.com/spreadsheets/d/1bHDzpCu4CwEa5_3_q_9vH2691XPhCS3e4Aj_HLhw_U8) matched the regular expression for extracting a Google Sheet identifier (^https://docs\.google\.com/spreadsheets/d/([a-zA-Z0-9_-]*)(/.*)?$), so proceeding to extract that.
  You set `exportGoogleSheet=TRUE`, so I will export the spreadsheet as an xlsx file which I will store as a temporary file and then import.
  trying URL 'https://docs.google.com/spreadsheets/d/1bHDzpCu4CwEa5_3_q_9vH2691XPhCS3e4Aj_HLhw_U8/export?format=xlsx'
  The value you passed as `x` (/home/hornik/tmp/R.check/r-devel-gcc/Work/build/Packages/preregr/extdata/preregr-form_inclSysRev_v0_92.xlsx) refers to a file that exists on your hard drive. Proceeding to import the data from that file.
  The extension of the file is `xlsx`, and you specified {readxl and writexl} as the package to use to read Excel files, so starting to read the data with those parameters.
  Succesfully imported spreadsheet.
  Returning result.
  The value you passed as `x` (/home/hornik/tmp/R.check/r-devel-gcc/Work/build/Packages/preregr/extdata/preregr-form_inclSysRev_v0_92.xlsx) refers to a file that exists on your hard drive. Proceeding to import the data from that file.
  The extension of the file is `xlsx`, and you specified {readxl and writexl} as the package to use to read Excel files, so starting to read the data with those parameters.
  Succesfully imported spreadsheet.
  Returning result.
  
  -- Specifying content for (pre)registration items ------------------------------
  ! You specified content for item 'nonExistent_item', but this item does not exist in the prereg form specification that you initialized (Inclusive Systematic Review Registration Form). Ignoring these items.
  v Content specified for item Title passed validation!
  v Specified content for Title [title]
  v Content specified for item Author(s) / contributor(s) passed validation!
  v Specified content for Author(s) / contributor(s) [authors]
  
  -- Specifying content for (pre)registration items ------------------------------
  ! You specified content for item 'nonExistent_item', but this item does not exist in the prereg form specification that you initialized (Inclusive Systematic Review Registration Form). Ignoring these items.
  v Content specified for item Title passed validation!
  v Specified content for Title [title]
  v Content specified for item Author(s) / contributor(s) passed validation!
  v Specified content for Author(s) / contributor(s) [authors]
  
  -- Specifying content for (pre)registration items ------------------------------
  ! You specified content for item 'nonExistent_item', but this item does not exist in the prereg form specification that you initialized (Inclusive Systematic Review Registration Form). Ignoring these items.
  v Content specified for item Title passed validation!
  v Specified content for Title [title]
  v Content specified for item Author(s) / contributor(s) passed validation!
  v Specified content for Author(s) / contributor(s) [authors]
  
  -- Specifying content for (pre)registration items ------------------------------
  ! You specified content for item 'nonExistent_item', but this item does not exist in the prereg form specification that you initialized (Inclusive Systematic Review Registration Form). Ignoring these items.
  v Content specified for item Title passed validation!
  v Specified content for Title [title]
  v Content specified for item Author(s) / contributor(s) passed validation!
  v Specified content for Author(s) / contributor(s) [authors]
  
  -- (Pre)registration form ------------------------------------------------------
  
  i Title: Minimal form with only a few fields
  i Author: Stibbons, P.
  i Date: 2024-03-01
  
  -- Instructions ----------------------------------------------------------------
  
  -- Instructions --
  
  This form is simple, so it doesn't require much instruction. Still, it's
  advisable to always RTFM, and in the case of (pre)registration forms, the
  instructions are the manual. So better read closely!
  
  -- Sections and items ----------------------------------------------------------
  
  -- Section: Only Section --
  
  i Study Title [study_title]: Think of a catchy title, preferably with a colon in the middle. Bonus points for pop culture references.
  
  i Registration type [registration_type]: Describe briefly why you are (pre)registering this study. For example, this might be a preregistration to allow others to know you're doing this study; or to make it clear you value transparency in science; or to remember your original plans later on. Or this might be a registration to update your plans after the data came in; or to document pragmatic changes in plans.
  
  Stored the (pre)registration form template in '/home/hornik/tmp/scratch/Rtmp4LBTGH/file7485e4c40d7c3.Rmd'.
  Stored the (pre)registration form template in '/home/hornik/tmp/scratch/Rtmp4LBTGH/file7485e724353d3.Rmd'.
  [ FAIL 1 | WARN 1 | SKIP 0 | PASS 11 ]
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error ('test-preregr.R:51:5'): writing a local backup for an exported google sheet works ──
  Error in `utils::download.file(url = gSheet_exportLink, destfile = fileToRead, 
      quiet = silent, mode = "wb")`: cannot open URL 'https://docs.google.com/spreadsheets/d/1bHDzpCu4CwEa5_3_q_9vH2691XPhCS3e4Aj_HLhw_U8/export?format=xlsx'
  Backtrace:
      ▆
   1. ├─testthat::expect_true(...) at test-preregr.R:31:3
   2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
   3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
   4. └─preregr::read_spreadsheet(...) at test-preregr.R:51:5
   5.   └─utils::download.file(...)
  
  [ FAIL 1 | WARN 1 | SKIP 0 | PASS 11 ]
  Error: Test failures
  Execution halted