search for: mysqlexecstatement

...3 > query.string2 <- paste("SELECT t.timeseries_id, t.timeseries_signal FROM MyTemporaryTable2 t, MyTemporaryTable3 v WHERE t.participant = v.participant AND t.roi = v.roi AND t.voxel_id = v.voxel_id;",sep="") 14 > series1 <- dbGetQuery(con, query.string1) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: Table 'tsgcst.MyTemporaryTable1' doesn't exist) 15 > series2 <- dbGetQuery(con, query.string2) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: Table 'tsgcst.MyTe...

...;ACC", env = <environment>, verbose = FALSE, : At least one connection argument ( ‘user’ ‘password’ ‘dbname’ ) is not set *second i tried * setDefaults(getSymbols.MySQL,user=' ',password=' ',dbname='ts') getSymbols('ACC',src='MySQL') Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: Unknown column 'o' in 'field list') *third i tried this * setDefaults(getSymbols.MySQL,user='', password='', dbname='ts', db.fields=c("Date","Open","High",&quo...

...he fields in my "contact" table. The only other field my MySQL table has is an id field which is the PK and is set to auto increment. I'd like to load this data.frame using something like: dbWriteTable(con, "contact", dat, append=TRUE) However, I get this error: Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: Unknown column 'row_names' in 'field list') [1] FALSE Warning message: In mysqlWriteTable(conn, name, value, ...) : could not load data into table Can anyone shed light on this error, or how I might bulk load this...

...to embed the script to be called as system("R --save < whatever.R") in my perl script, I saw very strange things. One of the data frame got written into the database without any problem. But the other one refused to go to the database with the following error message: "Error in mysqlExecStatement ... RS-DBI driver: (could not run statement: Table ... already exists) I have checked on line and find http://tolstoy.newcastle.edu.au/R/help/01c/0652.html talks about the same problem I have en counted. But the problem is that I have two data frame, one works and the other does not. Also if I do...

Hi, Can somebody advice on weird mysqlWriteTable bug. > mysqlWriteTable(conn, 'comparison',design2, row.names = F, overwrite=T) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"condition" text, treatment text, condition2 text, conditionNum double, impo'...

...> con <- dbConnect(dbDriver("MySQL"), dbname = "foo", user="me",password="secret") > x<- data.frame(1:10) > colnames(x) <-c("x") > dbWriteTable(con, "#x", x, verbose=TRUE,row.names=FALSE, overwrite=T) # fails Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( x bigint )' at line 2) [1] FALSE Warning message: In mysqlWriteTable(conn, name, value...

...ry(RMySQL) Loading required package: DBI > pg <- dbDriver("MySQL") > con <- dbConnect(pg, username="dummy", host="localhost", password="", dbname="ga1prosp") > dbGetQuery(con, statement="SELECT * FROM K?rperma?e;") Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\266rperma?e' at line 1) The table "K?rperma?e" has encoding utf8, and query &qu...

...password=..,host=..,db=..) But how can I do the test connected()? I thought the way to do this was, connected()<-function(){return (exists("con") & isIdCurrent(con))} But that does'n work, after some time connected() returns TRUE, but the next dbGetQuery signals Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: MySQL server has gone away) How can I test if the connection is still valid? Thanks Frans