From ripley at stats.ox.ac.uk  Sat Mar 17 17:44:19 2012
From: ripley at stats.ox.ac.uk (Prof Brian Ripley)
Date: Sat, 17 Mar 2012 16:44:19 +0000
Subject: [Rd] How to install sqldf to R with version 2.10?
In-Reply-To: <4F64BAFB.9090108@statistik.tu-dortmund.de>
References: <CAOHYbfsaVOBNWwEa_cyahTepjXmDUV2qSXs-0RZeWJfWUTWmkw@mail.gmail.com>
	<CAPPM_gQtaUnwqWJy5g_9eVRnWYt65s8r-iKBeRNC9ohuefy6JQ@mail.gmail.com>
	<4F64BAFB.9090108@statistik.tu-dortmund.de>
Message-ID: <4F64BF63.1080008@stats.ox.ac.uk>

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



[Rd] How to install sqldf to R with version 2.10?
Prof Brian Ripley