[R] sqldf hanging on macintosh - works on windows

[Marc Schwartz]

On Nov 1, 2010, at 10:55 AM, Gabor Grothendieck wrote:

> On Mon, Nov 1, 2010 at 10:55 AM, GL <pflugg at shands.ufl.edu> wrote:
>> 
>> 
>>> 
>>> library(sqldf)
>> Loading required package: DBI
>> Loading required package: RSQLite
>> Loading required package: RSQLite.extfuns
>> Loading required package: gsubfn
>> Loading required package: proto
>> Loading required package: chron
>>> debug(sqldf)
>>>   df.final <- sqldf('select Date, Hour, x as RoomsInUse from
>>> "df.possible.combos"
>> +     left join "df.aggregate" using (Hour, Date)')
>> debugging in: sqldf("select Date, Hour, x as RoomsInUse from
> ...
>> debug: words. <- words <- strapply(x, "[[:alnum:]._]+")
>> Browse[2]>
>> Loading required package: tcltk
>> Loading Tcl/Tk interface ...
>> +
> 
> There is something wrong with tcltk on your system.  You can tell it
> not to use tcltk by setting the appropriate option as discussed in
> sqldf FAQ #5:
> 
> http://code.google.com/p/sqldf/#5._I_get_a_message_about_tcl_being_missing.


GL,

If you installed R using the OSX binary from CRAN, it does not include tcl/tk. You need to install the separate tcltk package that Simon has put together and is available from:

  http://cran.us.r-project.org/bin/macosx/tools/

You also need to have X11 installed, which is available from the OSX DVD in the Optional Installs section.

HTH,

Marc Schwartz