Hi,
I've been trying to install dbplyr package with no success. If I just install it automatically with RStudio (from CRAN), I get error that cli and dplyr packages are too old versions, but new versions cant be installed, because the only available binaries are from older versions.
I tried finding an older version of dbplyr, but the only 2.1.1 I could find for manual download seemed to not be in the right format (tar.gz) and gave me another error when I unpacked it and put in the library directory with all other packages.
I also tried manually installing newest versions of cli and dplyr, but even new errors arise after doing that.
The log when trying to instal dbplyr automatically:
Installing 'dbplyr' ...
[1/3] Installing cli...
There is a binary version available but the source version is later:
binary source needs_compilation
cli 3.2.0 3.3.0 TRUE
Binaries will be installed
trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.0/cli_3.2.0.zip'
Content type 'application/zip' length 1256176 bytes (1.2 MB)
==================================================
downloaded 1.2 MB
package 'cli' successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\******\AppData\Local\Temp\1\RtmpU5vQvP\downloaded_packages
[2/3] Installing dplyr...
There is a binary version available but the source version is later:
binary source needs_compilation
dplyr 1.0.8 1.0.9 TRUE
Binaries will be installed
trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.0/dplyr_1.0.8.zip'
Content type 'application/zip' length 1381331 bytes (1.3 MB)
==================================================
downloaded 1.3 MB
package 'dplyr' successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\********\AppData\Local\Temp\1\RtmpU5vQvP\downloaded_packages
[3/3] Installing dbplyr...
also installing the dependencies 'cli', 'dplyr'
There are binary versions available but the source versions are later:
binary source needs_compilation
cli 3.2.0 3.3.0 TRUE
dplyr 1.0.8 1.0.9 TRUE
dbplyr 2.1.1 2.2.1 FALSE
Binaries will be installed
trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.0/cli_3.2.0.zip'
Content type 'application/zip' length 1256176 bytes (1.2 MB)
==================================================
downloaded 1.2 MB
trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.0/dplyr_1.0.8.zip'
Content type 'application/zip' length 1381331 bytes (1.3 MB)
==================================================
downloaded 1.3 MB
package 'cli' successfully unpacked and MD5 sums checked
package 'dplyr' successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\*******\AppData\Local\Temp\1\RtmpU5vQvP\downloaded_packages
installing the source package 'dbplyr'
trying URL 'https://cran.rstudio.com/src/contrib/dbplyr_2.2.1.tar.gz'
Content type 'application/x-gzip' length 670569 bytes (654 KB)
==================================================
downloaded 654 KB
* installing *source* package 'dbplyr' ...
** package 'dbplyr' successfully unpacked and MD5 sums checked
** using staged installation
** R
** inst
** byte-compile and prepare package for lazy loading
Error in loadNamespace(j <- i[[1L]], c(lib.loc, .libPaths()), versionCheck = vI[[j]]) :
namespace 'cli' 3.2.0 is already loaded, but >= 3.3.0 is required
Calls: <Anonymous> ... namespaceImportFrom -> asNamespace -> loadNamespace
Execution halted
ERROR: lazy loading failed for package 'dbplyr'
* removing 'C:/Users/********/Documents/R/R-4.0.4/library/dbplyr'
The downloaded source packages are in
'C:\Users\*******\AppData\Local\Temp\1\RtmpU5vQvP\downloaded_packages'
<U+2714> Package 'dbplyr' successfully installed.
Warning message:
In utils::install.packages("dbplyr", repos = "https://cran.rstudio.com/") :
installation of package 'dbplyr' had non-zero exit status