search for: mysqlexecstatement

Displaying 8 results from an estimated 8 matches for "mysqlexecstatement".

2009 Jan 10
0
RMySQL CREATE TABLE error
...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...
2011 Mar 16
0
Quantmod getSymbol.MySQL
...;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...
2010 Jan 25
1
RMySQL Append data.frame to table
...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...
2007 May 31
1
RMySQL DBI question
...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...
2010 Mar 04
1
mysqlWriteTable . error in your SQL syntax?
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'...
2009 Mar 01
0
How to create temporary table in MySQL
...> 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...
2012 Mar 30
0
RMySQL and german umlaute
...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...
2013 Feb 14
0
Test if mysql connection is alive
...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