jennybc / googlesheets

Google Spreadsheets R API
Other
783 stars 191 forks source link

gs_ls() gives error message and restart r session #377

Closed henda52 closed 5 years ago

henda52 commented 5 years ago

I use a script that worked fine last week but now it doesn't, see comments below. I use the following code:

library(googlesheets) #gives no error message gs_ls() #gives the following error message before it eventually restarts the R session

Error in is_atomic(x) && is_scalar_atomic(y) : evaluation nested too deeply: infinite recursion / options(expressions=)? Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup: Error during wrapup:

My session info is: R version 3.5.2 (2018-12-20) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows >= 8 x64 (build 9200)

Matrix products: default

locale: [1] LC_COLLATE=Swedish_Sweden.1252 LC_CTYPE=Swedish_Sweden.1252 LC_MONETARY=Swedish_Sweden.1252 [4] LC_NUMERIC=C LC_TIME=Swedish_Sweden.1252

attached base packages: [1] stats graphics grDevices utils datasets methods base

other attached packages: [1] googlesheets_0.3.0

loaded via a namespace (and not attached): [1] NLP_0.2-0 Rcpp_1.0.0 later_0.8.0 cellranger_1.1.0 pillar_1.3.1
[6] compiler_3.5.2 plyr_1.8.4 tools_3.5.2 digest_0.6.18 jsonlite_1.6
[11] tibble_2.0.1 gtable_0.2.0 viridisLite_0.3.0 pkgconfig_2.0.2 rlang_0.3.1
[16] shiny_1.2.0 rstudioapi_0.9.0 parallel_3.5.2 yaml_2.2.0 xml2_1.2.0
[21] dplyr_0.8.0.1 httr_1.4.0 topicmodels_0.2-8 htmlwidgets_1.3 shinydashboard_0.7.1 [26] stats4_3.5.2 ade4_1.7-13 grid_3.5.2 tidyselect_0.2.5 glue_1.3.0
[31] data.table_1.12.0 R6_2.4.0 plotly_4.8.0 ggplot2_3.1.0 purrr_0.3.0
[36] tidyr_0.8.2 magrittr_1.5 promises_1.0.1 scales_1.0.0 modeltools_0.2-22
[41] revtools_0.3.0 htmltools_0.3.6 MASS_7.3-51.1 assertthat_0.2.0 xtable_1.8-3
[46] mime_0.6 colorspace_1.4-0 httpuv_1.4.5.1 lazyeval_0.2.1 munsell_0.5.0
[51] slam_0.1-44 tm_0.7-6 crayon_1.3.4

I've restarted both R and the computer without any improvment. Any other suggestions on what to test?

jennybc commented 5 years ago

Well, the immediate error is coming from functions in rlang, but that doesn't mean it's the culprit.

googlesheets has grown very long in the tooth and I am focusing attention on its successor(s): googledrive (already on CRAN) and googlesheets4 (still GitHub only, still read only). It's definitely in maintenance/archive mode.

I'd advise switching to those packages for everything possible. For example, for listing your Sheets, a better approach than gs_ls() would be drive_find(type = "spreadsheet"). That will give you file names or IDs, which you could use in whatever comes next. Sorry we are in an awkward state at the moment.

henda52 commented 5 years ago

Thank you!

DataStrategist commented 5 years ago

This affects me too. I'm happy you're combining these two packages it really was annoying to have to remember which one came from where.