Re: [R] RMySQL Installation Error
Dear Prof Brian,
Thank you for telling the solution and from next time i will follow the
posting guide.
On Sun, Feb 22, 2015 at 11:51 PM, Prof Brian Ripley
wrote:
> On 22/02/2015 17:07, avinash barnwal wrote:
>
>> Hi List,
>>
>> I am trying to install RMySQL on Windows 7(64 Bit) with R Version 2.15.1
>> on
>> RStudio. I have also followed the steps mentioned on the different web
>> sources and finally drilled down to following steps:
>>
>
> Hmm, those are not the correct instructions for the version of RMySQL you
> used. Undo them and follow the current instructions
>
>
>> 1. *Installed MySQL to "C:\Program Files (x86)\MySQL\MySQL Server
>> 5.6”*
>> 2. * Added "MYSQL_HOME" with a value of "C:/Program Files
>> (x86)/MySQL/MySQL Server 5.6/"*
>> 3. *Created the directory "opt" within "C:\Program Files
>> (x86)\MySQL\MySQL Server 5.6\lib" and copy-paste "C:\Program Files
>> (x86)\MySQL\MySQL Server 5.6\lib\libmysql.lib" to "C:\Program Files
>> (x86)\MySQL\MySQL Server 5.6\lib\opt\" and*
>> 4. *Copy-paste "C:\Program Files\MySQL\MySQL Server
>> 5.5\lib\libmysql.dll" to "C:\Program Files\R\R-2.15.1\bin\i386\".*
>>
>> *B But i am getting following error while executing
>> install.packages('RMySQL',type='source') command in RStudio.*
>>** preparing package for lazy loading
>>
>> Error in setClass("MySQLDriver", contains = "DBIDriver", slots = list(Id =
>> "integer")) :
>>
>>unused argument(s) (slots = list(Id = "integer"))
>>
>> Error : unable to load R code in package 'RMySQL'
>>
>> ERROR: lazy loading failed for package 'RMySQL'
>>
>> * removing 'C:/Users/barney/Documents/R/win-library/2.15/RMySQL'
>>
>> Warning in install.packages :
>>
>>running command 'C:/PROGRA~1/R/R-215~1.1/bin/x64/R CMD INSTALL -l
>> "C:/Users/barney/Documents/R/win-library/2.15"
>> C:\Users\barney\AppData\Local\Temp\RtmpgJXVPT/downloaded_
>> packages/RMySQL_0.10.1.tar.gz'
>> had status 1
>>
>> Warning in install.packages :
>>
>>installation of package ‘RMySQL’ had non-zero exit status.
>>
>>
>> Request your help in solving the problem.
>>
>
>
> Follow the posting guide. Your R is very old, and you were asked to
> update before posting. Most likely that version of RMySQL requires a
> current version of R.
>
>
>> [[alternative HTML version deleted]]
>>
>
> Do not do that, as the posting guide required of you.
>
>>
>> __
>> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide http://www.R-project.org/
>> posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>>
>
> --
> Brian D. Ripley, rip...@stats.ox.ac.uk
> Emeritus Professor of Applied Statistics, University of Oxford
> 1 South Parks Road, Oxford OX1 3TG, UK
>
--
Avinash Barnwal, M.Sc.
Statistics and Informatics
Department of Mathematics
IIT Kharagpur
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] RMySQL Installation Error
On 22/02/2015 17:07, avinash barnwal wrote:
Hi List,
I am trying to install RMySQL on Windows 7(64 Bit) with R Version 2.15.1 on
RStudio. I have also followed the steps mentioned on the different web
sources and finally drilled down to following steps:
Hmm, those are not the correct instructions for the version of RMySQL
you used. Undo them and follow the current instructions
1. *Installed MySQL to "C:\Program Files (x86)\MySQL\MySQL Server 5.6”*
2. * Added "MYSQL_HOME" with a value of "C:/Program Files
(x86)/MySQL/MySQL Server 5.6/"*
3. *Created the directory "opt" within "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib" and copy-paste "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib\libmysql.lib" to "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib\opt\" and*
4. *Copy-paste "C:\Program Files\MySQL\MySQL Server
5.5\lib\libmysql.dll" to "C:\Program Files\R\R-2.15.1\bin\i386\".*
*B But i am getting following error while executing
install.packages('RMySQL',type='source') command in RStudio.*
** preparing package for lazy loading
Error in setClass("MySQLDriver", contains = "DBIDriver", slots = list(Id =
"integer")) :
unused argument(s) (slots = list(Id = "integer"))
Error : unable to load R code in package 'RMySQL'
ERROR: lazy loading failed for package 'RMySQL'
* removing 'C:/Users/barney/Documents/R/win-library/2.15/RMySQL'
Warning in install.packages :
running command 'C:/PROGRA~1/R/R-215~1.1/bin/x64/R CMD INSTALL -l
"C:/Users/barney/Documents/R/win-library/2.15"
C:\Users\barney\AppData\Local\Temp\RtmpgJXVPT/downloaded_packages/RMySQL_0.10.1.tar.gz'
had status 1
Warning in install.packages :
installation of package ‘RMySQL’ had non-zero exit status.
Request your help in solving the problem.
Follow the posting guide. Your R is very old, and you were asked to
update before posting. Most likely that version of RMySQL requires a
current version of R.
[[alternative HTML version deleted]]
Do not do that, as the posting guide required of you.
__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
--
Brian D. Ripley, rip...@stats.ox.ac.uk
Emeritus Professor of Applied Statistics, University of Oxford
1 South Parks Road, Oxford OX1 3TG, UK
__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
[R] RMySQL Installation Error
Hi List,
I am trying to install RMySQL on Windows 7(64 Bit) with R Version 2.15.1 on
RStudio. I have also followed the steps mentioned on the different web
sources and finally drilled down to following steps:
1. *Installed MySQL to "C:\Program Files (x86)\MySQL\MySQL Server 5.6”*
2. * Added "MYSQL_HOME" with a value of "C:/Program Files
(x86)/MySQL/MySQL Server 5.6/"*
3. *Created the directory "opt" within "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib" and copy-paste "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib\libmysql.lib" to "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib\opt\" and*
4. *Copy-paste "C:\Program Files\MySQL\MySQL Server
5.5\lib\libmysql.dll" to "C:\Program Files\R\R-2.15.1\bin\i386\".*
*B But i am getting following error while executing
install.packages('RMySQL',type='source') command in RStudio.*
** preparing package for lazy loading
Error in setClass("MySQLDriver", contains = "DBIDriver", slots = list(Id =
"integer")) :
unused argument(s) (slots = list(Id = "integer"))
Error : unable to load R code in package 'RMySQL'
ERROR: lazy loading failed for package 'RMySQL'
* removing 'C:/Users/barney/Documents/R/win-library/2.15/RMySQL'
Warning in install.packages :
running command 'C:/PROGRA~1/R/R-215~1.1/bin/x64/R CMD INSTALL -l
"C:/Users/barney/Documents/R/win-library/2.15"
C:\Users\barney\AppData\Local\Temp\RtmpgJXVPT/downloaded_packages/RMySQL_0.10.1.tar.gz'
had status 1
Warning in install.packages :
installation of package ‘RMySQL’ had non-zero exit status.
Request your help in solving the problem.
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
