[Workspace loaded from ~/Projects/MOTUS/General_Motus/Motus_R/project337/.RData]

> # Set up
> # install motus R package (easiest way to install is from Birds Canada's R-universe)
> install.packages("motus", 
+                  repos = c(birdscanada = 'https://birdscanada.r-universe.dev',
+                            CRAN = 'https://cloud.r-project.org'))
trying URL 'https://birdscanada.r-universe.dev/bin/macosx/contrib/4.1/motus_5.0.0.tgz'
Content type 'application/x-gzip' length 30211192 bytes (28.8 MB)
==================================================
downloaded 28.8 MB


The downloaded binary packages are in
	/var/folders/lm/tcjysbcx24z1dhngsd5z58qw0000gn/T//RtmppmnYqr/downloaded_packages
> # install other necessary packages if you don't already have them
> install.packages(c("tidyverse", "ggmap", "rnaturalearth"))
trying URL 'https://cran.rstudio.com/bin/macosx/contrib/4.1/tidyverse_1.3.1.tgz'
Content type 'application/x-gzip' length 421072 bytes (411 KB)
==================================================
downloaded 411 KB

trying URL 'https://cran.rstudio.com/bin/macosx/contrib/4.1/ggmap_3.0.0.tgz'
Content type 'application/x-gzip' length 4698059 bytes (4.5 MB)
==================================================
downloaded 4.5 MB

trying URL 'https://cran.rstudio.com/bin/macosx/contrib/4.1/rnaturalearth_0.1.0.tgz'
Content type 'application/x-gzip' length 220758 bytes (215 KB)
==================================================
downloaded 215 KB


The downloaded binary packages are in
	/var/folders/lm/tcjysbcx24z1dhngsd5z58qw0000gn/T//RtmppmnYqr/downloaded_packages
> install.packages(c("rnaturalearthhires", "rnaturalearthdata"),
+                  repos = c(ropensci = 'https://ropensci.r-universe.dev',  
+                            CRAN = 'https://cloud.r-project.org'))
trying URL 'https://ropensci.r-universe.dev/bin/macosx/contrib/4.1/rnaturalearthhires_0.2.0.tgz'
Content type 'application/x-gzip' length 22501175 bytes (21.5 MB)
==================================================
downloaded 21.5 MB

trying URL 'https://ropensci.r-universe.dev/bin/macosx/contrib/4.1/rnaturalearthdata_0.2.0.tgz'
Content type 'application/x-gzip' length 3074940 bytes (2.9 MB)
==================================================
downloaded 2.9 MB


The downloaded binary packages are in
	/var/folders/lm/tcjysbcx24z1dhngsd5z58qw0000gn/T//RtmppmnYqr/downloaded_packages
> # load packages
> library(motus)
> library(motusData)
> # Set system time zone to GMT (or UTC)
> Sys.setenv(TZ='GMT')
> library(tidyverse)  # includes ggplot2, dplyr
── Attaching packages ─────────────────────────────────────────────────────────── tidyverse 1.3.1 ──
✓ ggplot2 3.3.5     ✓ purrr   0.3.4
✓ tibble  3.1.6     ✓ dplyr   1.0.8
✓ tidyr   1.2.0     ✓ stringr 1.4.0
✓ readr   2.1.2     ✓ forcats 0.5.1
── Conflicts ────────────────────────────────────────────────────────────── tidyverse_conflicts() ──
x dplyr::filter() masks stats::filter()
x dplyr::lag()    masks stats::lag()
> library(lubridate)  # for manipulation of dates and times

Attaching package: ‘lubridate’

The following objects are masked from ‘package:base’:

    date, intersect, setdiff, union

> library(RSQLite)    # need for some sql manipulation
> (.packages())    # display loaded packages
 [1] "RSQLite"   "lubridate" "forcats"   "stringr"   "dplyr"     "purrr"     "readr"     "tidyr"    
 [9] "tibble"    "ggplot2"   "tidyverse" "motusData" "motus"     "stats"     "graphics"  "grDevices"
[17] "utils"     "datasets"  "methods"   "base"     
> getwd()          # display your current working directory
[1] "/Users/rich/Projects/MOTUS/General_Motus/Motus_R/project337"
> proj.num <- 337  ## "USFW MB R9 Shorebird Project"
> sql.motus <- tagme(projRecv = proj.num, new = TRUE,  update = TRUE, dir = "databases/")  
Please enter a value for login name at motus.org
==> 
*********
Please enter a value for password at motus.org
==> 
********
Checking for new data in project 337
Updating metadata
activity:     0 new batch records to check
nodeData:     0 new batch records to check
Fetching deprecated batches
Error in `dplyr::anti_join()`:
! Join columns must be present in data.
x Problem with `batchID`.
Run `rlang::last_error()` to see where the error occurred.
> rlang::last_error()
<error/rlang_error>
Error in `dplyr::anti_join()`:
! Join columns must be present in data.
x Problem with `batchID`.
---
Backtrace:
 1. motus::tagme(...)
 6. dplyr:::anti_join.data.frame(b, ., by = "batchID")
Run `rlang::last_trace()` to see the full context.
> rlang::last_messages()
list()
> rlang::last_trace()
<error/rlang_error>
Error in `dplyr::anti_join()`:
! Join columns must be present in data.
x Problem with `batchID`.
---
Backtrace:
     ▆
  1. ├─motus::tagme(...)
  2. │ └─motus:::fetchDeprecated(src = rv)
  3. │   └─... %>% dplyr::mutate(removed = 0)
  4. ├─dplyr::mutate(., removed = 0)
  5. ├─dplyr::anti_join(b, ., by = "batchID")
  6. └─dplyr:::anti_join.data.frame(b, ., by = "batchID")
  7.   └─dplyr:::join_filter(x, y, by = by, type = "anti", na_matches = na_matches)
  8.     └─dplyr:::join_cols(tbl_vars(x), tbl_vars(y), by = by, error_call = error_call)
  9.       └─dplyr:::standardise_join_by(...)
 10.         └─dplyr:::check_join_vars(by$x, x_names, error_call = error_call)
 11.           └─rlang::abort(bullets, call = error_call)
>