包sqldf下载错误

Question

我试图通过代码在rstudio服务器中安装sqldf包

install.packages("sqldf")

但是，当我尝试下载这个文件时，出现了以下错误

Installing package into ‘/home/mrshekar/R/x86_64-pc-linux-gnu-library/3.4’
(as ‘lib’ is unspecified)
trying URL 'https://cloud.r-project.org/src/contrib/sqldf_0.4-11.tar.gz'
Content type 'application/x-gzip' length 63097 bytes (61 KB)
==================================================
downloaded 61 KB

* installing *source* package ‘sqldf’ ...
** package ‘sqldf’ successfully unpacked and MD5 sums checked
** R
** demo
** inst
** byte-compile and prepare package for lazy loading
Warning: S3 method ‘format.SQLiteConnection’ was declared in NAMESPACE but not found
Error: package or namespace load failed for ‘RSQLite’ in library.dynam(lib, package, package.lib):
 shared object ‘RSQLite.so’ not found
Error : package ‘RSQLite’ could not be loaded
ERROR: lazy loading failed for package ‘sqldf’
* removing ‘/home/mrshekar/R/x86_64-pc-linux-gnu-library/3.4/sqldf’
Warning in install.packages :
  installation of package ‘sqldf’ had non-zero exit status

The downloaded source packages are in
    ‘/tmp/RtmpJSQqsy/downloaded_packages’

现在，据我所知，RSQLite包出现了问题，但是它是单独下载的，它也出现在我的package选项卡中。如果我做错了什么，错误是什么？请帮帮忙。谢谢!

Answer 1

我也有过类似的问题。检查您的RSQLite包。它已被下载，但也将无法工作。尝试删除软件包，然后再安装它。

然后再安装sqldf包。这对我来说似乎是正确的。

Answer 2

问题不在于此。sqldf包安装RSQLite包。现在我已经安装了它，正如您正确地指出的，关于RSQLite包没有正确安装的错误，即使我只是在删除RSQLite包之后安装了sqldf包，它也就足够了。不需要再次安装RSQLite包。不过还是要谢谢你。