[R-sig-DB] DBI problem after R upgrade

[Prof Brian Ripley]

On Thu, 20 Oct 2005, Parlamis Franklin wrote:

> I upgraded R to 2.2.0 (Mac Cocoa GUI 1.13) this evening.  I am
> running MySQL Standard version 4.1.14 locally, which I installed
> several months ago from binaries on the MySQL web site (mysql-
> standard-4.1.14-apple-darwin8.2.0-powerpc-64bit.dmg).  Before I
> upgraded R, everything worked fine with RMySQL and DBI (all I used
> was DBSendQuery, DBReadTable and DBWriteTable).
>
> However, now when I load the DBI package I get the following error:
>
>         Warning message:
>         RS-DBI driver warning: (MySQL mismatch between compiled
> version 4.0.24 and runtime version 4.1.14)
>
> Then, if I attempt to use one of the DBI functions, say DBReadTable,
> R quits unexpectedly.  I reinstalled MySQL from binaries, and I also
> reinstalled the DBI and RMySQL packages from binaries.  Nothing has
> helped.  I have never had MySQL 4.0.24 on my computer (4.1.14 was my
> first and only install).

It is the (powerpc/2.2) RMySQL MacOS X binary that is compiled against 
MySQL 4.0.24.  It seems you need to install RMySQL from the sources.

This is not really a R-sig-DB topic but a MacOS one.

-- 
Brian D. Ripley,                  ripley using 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