Re: [Rd] How to install sqldf to R with version 2.10?

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Sat, 17 Mar 2012 16:44:19 +0000

On 17/03/2012 16:25, Uwe Ligges wrote:
>
>
> On 17.03.2012 17:20, Joshua Ulrich wrote:
>> On Sat, Mar 17, 2012 at 9:56 AM, zhu free<freezhu8_at_gmail.com> wrote:
>>> Hi,
>>> How to install sqldf to R with version 2.10? I used the R in the
>>> cluster of
>>> university and there seems no way to update the R version to 2.14.
>>> However,
>>> I do need sqldf. I tried to install and there is the problem of
>>> namespace.
>>> How could I solve the problem of namespace and run sqldf on R with
>>> version
>>> 2.10? Thank you!
>>>
>> Download and unpack the sqldf source, add a NAMESPACE file, then build
>> the Windows binary using R-2.10.x and Rtools210 or Rtools211.
>
>
> I don't think the OP is using Windows on a cluster.
> The point is that the new sqldf may not be compatible with the old

And in any case, there is no 'R 2.10', as the posting guide points out.

> release of R - and I don't have such an old version around for testing.
> Anyway: Go to CRAN and the package's archive, you will find old versions
> of the package that may work with the old R-2.10.x

And possibly older versions of all the packages it depends on/imports to.

But, I do have R 2.10.1 around, so I can reproduce the problem:

* installing *source* package sqldf ...
** R
** demo
** inst
** preparing package for lazy loading

Loading required package: proto
Error : package 'gsubfn' does not have a name space ERROR: lazy loading failed for package sqldf

So the unstated problem is that sqldf does not work with gsubfn in R < 2.14.0. And the solution as Uwe said is to use an older version of sqldf (at least).

'zhu free' really does need to study the posting guide at http://www.r-project.org/posting-guide.html, and learn to post answerable questions.

> Uwe Ligges
>
>
>
>
>> All these steps are documented throughout the "Writing R Extensions"
>> manual.
>> http://cran.r-project.org/doc/manuals/R-exts.html
>>
>> HTH,
>> --
>> Joshua Ulrich | FOSS Trading: www.fosstrading.com

-- 
Brian D. Ripley,                  ripley_at_stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________
R-devel_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
Received on Sat 17 Mar 2012 - 16:47:14 GMT

This quarter's messages: by month, or sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

All messages

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 17 Mar 2012 - 19:00:30 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-devel. Please read the posting guide before posting to the list.

list of date sections of archive