Running ‘testthat.R’ [8s/223s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > #Tests for BIEN package
  > 
  > library(testthat)
  > library(BIEN)
  Loading required package: RPostgreSQL
  Loading required package: DBI
  Type vignette("BIEN") or vignette("BIEN_tutorial") to get started
  > test_check("BIEN")
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "is_cultivated" does not exist
  LINE 1: ...) AND scrubbed_species_binomial IS NOT NULL  AND (is_cultiva...
                                                               ^
  )
  ── 1. Failure: List functions return a dataframe (@test-BIEN.r#10)  ────────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "is_cultivated" does not exist
  LINE 1: ...te_province, county,  scrubbed_species_binomial  ,is_cultiva...
                                                               ^
  )
  ── 2. Failure: List functions return a dataframe (@test-BIEN.r#11)  ────────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "is_cultivated" does not exist
  LINE 3: ...  AND scrubbed_species_binomial IS NOT NULL  AND (is_cultiva...
                                                               ^
  )
  ── 3. Failure: List functions return a dataframe (@test-BIEN.r#12)  ────────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "taxonomic_status" does not exist
  LINE 1: ...me_matched,name_matched_author,higher_plant_group,taxonomic_...
                                                               ^
  )
  ── 4. Failure: Occurrence functions return a dataframe (@test-BIEN.r#27)  ──────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "is_cultivated" does not exist
  LINE 2: ...ce_individual WHERE country in ( 'Bahamas' ) AND (is_cultiva...
                                                               ^
  )
  ── 5. Failure: Occurrence functions return a dataframe (@test-BIEN.r#28)  ──────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "is_cultivated" does not exist
  LINE 6: ...   AND scrubbed_species_binomial IS NOT NULL AND (is_cultiva...
                                                               ^
  )
  ── 6. Failure: Occurrence functions return a dataframe (@test-BIEN.r#29)  ──────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "is_cultivated" does not exist
  LINE 3: ...    WHERE scrubbed_family in ( 'Cactaceae' ) AND (is_cultiva...
                                                               ^
  )
  ── 7. Failure: Occurrence functions return a dataframe (@test-BIEN.r#30)  ──────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "is_cultivated" does not exist
  LINE 3: ...      WHERE scrubbed_genus in ( 'Xanthium' ) AND (is_cultiva...
                                                               ^
  )
  ── 8. Failure: Occurrence functions return a dataframe (@test-BIEN.r#31)  ──────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "taxonomic_status" does not exist
  LINE 1: ...me_matched,name_matched_author,higher_plant_group,taxonomic_...
                                                               ^
  )
  ── 9. Failure: Occurrence functions return a dataframe (@test-BIEN.r#32)  ──────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "is_cultivated" does not exist
  LINE 5: ...   AND scrubbed_species_binomial IS NOT NULL AND (is_cultiva...
                                                               ^
  )
  ── 10. Failure: Occurrence functions return a dataframe (@test-BIEN.r#33)  ─────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column view_full_occurrence_individual.taxonomic_status does not exist
  LINE 3: ...iew_full_occurrence_individual.higher_plant_group,view_full_...
                                                               ^
  )
  ── 11. Failure: Plot functions return a dataframe (@test-BIEN.r#48)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column view_full_occurrence_individual.is_cultivated does not exist
  LINE 7: ...currence_individual.dataset in ( 'SALVIAS' ) AND (view_full_...
                                                               ^
  )
  ── 12. Failure: Plot functions return a dataframe (@test-BIEN.r#49)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column view_full_occurrence_individual.is_cultivated does not exist
  LINE 10: ...currence_individual.datasource in ( 'test' ) AND (view_full_...
                                                                ^
  )
  ── 13. Failure: Plot functions return a dataframe (@test-BIEN.r#50)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column view_full_occurrence_individual.is_cultivated does not exist
  LINE 8: ...ccurrence_individual.plot_name in ( 'test' ) AND (view_full_...
                                                               ^
  )
  ── 14. Failure: Plot functions return a dataframe (@test-BIEN.r#54)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column view_full_occurrence_individual.is_cultivated does not exist
  LINE 7: ...e_individual.sampling_protocol in ( 'test' ) AND (view_full_...
                                                               ^
  )
  ── 15. Failure: Plot functions return a dataframe (@test-BIEN.r#55)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column view_full_occurrence_individual.is_cultivated does not exist
  LINE 8: ...   AND scrubbed_species_binomial IS NOT NULL AND (view_full_...
                                                               ^
  )
  ── 16. Failure: Plot functions return a dataframe (@test-BIEN.r#56)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column reference "native_status" is ambiguous
  LINE 1: ...ELECT analytical_stem.scrubbed_species_binomial  ,native_sta...
                                                               ^
  )
  ── 17. Failure: Stem functions return a dataframe (@test-BIEN.r#66)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column reference "native_status" is ambiguous
  LINE 1: ...genus,analytical_stem.scrubbed_species_binomial  ,native_sta...
                                                               ^
  )
  ── 18. Failure: Stem functions return a dataframe (@test-BIEN.r#67)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column reference "native_status" is ambiguous
  LINE 1: ...genus,analytical_stem.scrubbed_species_binomial  ,native_sta...
                                                               ^
  )
  ── 19. Failure: Stem functions return a dataframe (@test-BIEN.r#68)  ───────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "elevation" does not exist
  LINE 2: ..., trait_value, unit, method, latitude, longitude, elevation,...
                                                               ^
  )
  ── 20. Failure: Trait functions return a dataframe (@test-BIEN.r#81)  ──────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "elevation" does not exist
  LINE 2: ..., trait_value, unit, method, latitude, longitude, elevation,...
                                                               ^
  )
  ── 21. Failure: Trait functions return a dataframe (@test-BIEN.r#82)  ──────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "elevation" does not exist
  LINE 2: ..., trait_value, unit, method, latitude, longitude, elevation,...
                                                               ^
  )
  ── 22. Failure: Trait functions return a dataframe (@test-BIEN.r#85)  ──────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "elevation" does not exist
  LINE 2: ..., trait_value, unit, method, latitude, longitude, elevation,...
                                                               ^
  )
  ── 23. Failure: Trait functions return a dataframe (@test-BIEN.r#86)  ──────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "elevation" does not exist
  LINE 2: ..., trait_value, unit, method, latitude, longitude, elevation,...
                                                               ^
  )
  ── 24. Failure: Trait functions return a dataframe (@test-BIEN.r#87)  ──────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "elevation" does not exist
  LINE 2: ..., trait_value, unit, method, latitude, longitude, elevation,...
                                                               ^
  )
  ── 25. Failure: Trait functions return a dataframe (@test-BIEN.r#88)  ──────────
  `x` inherits from `NULL` not `data.frame`.
  
  Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column "elevation" does not exist
  LINE 2: ..., trait_value, unit, method, latitude, longitude, elevation,...
                                                               ^
  )
  ── 26. Failure: Trait functions return a dataframe (@test-BIEN.r#89)  ──────────
  `x` inherits from `NULL` not `data.frame`.
  
  ══ testthat results  ═══════════════════════════════════════════════════════════
  OK: 41 SKIPPED: 0 FAILED: 26
  1. Failure: List functions return a dataframe (@test-BIEN.r#10) 
  2. Failure: List functions return a dataframe (@test-BIEN.r#11) 
  3. Failure: List functions return a dataframe (@test-BIEN.r#12) 
  4. Failure: Occurrence functions return a dataframe (@test-BIEN.r#27) 
  5. Failure: Occurrence functions return a dataframe (@test-BIEN.r#28) 
  6. Failure: Occurrence functions return a dataframe (@test-BIEN.r#29) 
  7. Failure: Occurrence functions return a dataframe (@test-BIEN.r#30) 
  8. Failure: Occurrence functions return a dataframe (@test-BIEN.r#31) 
  9. Failure: Occurrence functions return a dataframe (@test-BIEN.r#32) 
  1. ...
  
  Error: testthat unit tests failed
  Execution halted