Hi, I've had great experiences with the RMySQL library and MySQL from windows XP and Gentoo/Linux environments with R-2.7.2 so I'm happy to test solutions or to try to find out more about the problem. I've (unfortunately) had the same (previous report appended) experience with a new install of Vista on a Vaio/VGN-NS255J laptop, running R (I checked 2.7.2 and 2.8 both exhibit the same behavior). My MySQL binaries are from a fresh install of MySQL server (32bit) 5.1. The MySQL server is separate and plays well with other Windows/Linux R installations. The download/install is clean, I can connect and run dbGetQuery(conn, "SHOW TABLES;") at least a few times, but when I run a query against any table, even one which returns limited data (conn, "SELECT * FROM blah LIMIT 6;") Vista says "there has been a problem with R and it needs to close" (paraphrased). The message is completely uninformative. It then proceeds to close R with no further comment. I will let you know if I find any more information but I don't know if there are better error logs somewhere on Vista.... any suggestions would be appreciated in dealing with this. Best regards, Krzysztof Sakrejda-Leavitt ----------------------------------------------- Krzysztof Sakrejda-Leavitt Organismic and Evolutionary Biology University of Massachusetts, Amherst 319 Morrill Science Center South 611 N. Pleasant Street Amherst, MA 01003 work #: 413-325-6555 email: sakrejda at nsm.umass.edu ----------------------------------------------- On Mon, Jan 12, 2009 at 1:02 PM, auburneconomics
<nathan_forczyk at yahoo.com>wrote:
This is similar to another current post about RMySQL crashing R, except on the other post it crashed on connection to the database. I can successfully connect, and even can do dbListTables(). But, if I send a query or anything to actually see the data, R crashes to desktop. I have tried this on two computers, one Vista, one XP. Both crashed. I am running 2.8.1, and am using the correct version of DBI and RMySQL. They are both loaded with the library() function beforehand. Versions of MySQL that it was tried are 5.1 and 6.0a. I have searched on the internet and haven't found any answers, and would be grateful for any help, Nathan Forczyk Auburn University -- View this message in context: http://www.nabble.com/RMySQL-crashes-R-tp21419908p21419908.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at r-project.org mailing list 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.
--