3

I am trying to use dbWriteTable to store a data frame into MySQL database. Here is the code:

mydb = getDbConnect(courseSlug)
dbWriteTable(mydb, name = table_name, value = dataframe, overwrite = TRUE, row.names = FALSE , 
           field.types = list(col1 = "varchar(5)",col2 = "bigint",Visits = "bigint"
           ,col3 = "bigint",col4 = "bigint",`col 5` = "double",`col 6` = "double")) 
dbDisconnect(mydb)

It perfectly works in my local machine:

  • R version 3.2.3 (2015-12-10)
  • Platform: i386-w64-mingw32/i386 (32-bit)

However, I get the following error

Error: evaluation nested too deeply: infinite recursion / options(expressions=)?

in the AWS server machine which has R with following specifications:

  • R version 3.3.0 beta (2016-03-30 r70404)
  • Platform: x86_64-pc-linux-gnu (64-bit)

Would you help me what the issue might be?

zx8754
  • 52,746
  • 12
  • 114
  • 209
Mahsa Chitsaz
  • 111
  • 1
  • 5

0 Answers0