search

beanumber / fec

Exploration of FEC contributions data with dplyr
4 stars 7 forks source link

command is not supported in the prepared statement protocol yet [1295] #10

Open evagjekmarkaj opened 7 years ago

evagjekmarkaj commented 7 years ago

Issue when trying to load the tables into database.

evagjekmarkaj commented 7 years ago 
fec <- etl("fec", db, dir = "~/dumps/fec") 
etl_init(fec)
SessionInfo
R version 3.3.1 (2016-06-21)
Platform: x86_64-apple-darwin13.4.0 (64-bit)
Running under: OS X 10.11.6 (El Capitan)

locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] fec_0.0.0.9010 etl_0.3.3.1    dplyr_0.5.0    RMySQL_0.11-3 

loaded via a namespace (and not attached):
 [1] Rcpp_0.12.7     lubridate_1.6.0 tidyr_0.6.0     assertthat_0.1  R6_2.1.3        DBI_0.5-1      
 [7] magrittr_1.5    stringi_1.1.1   lazyeval_0.2.0  readxl_0.1.1    curl_1.2        tools_3.3.1    
[13] stringr_1.1.0   readr_1.0.0     tibble_1.2
beanumber commented 7 years ago

Note: (https://github.com/rstats-db/RMySQL/issues/117)

beanumber commented 7 years ago

This works for me.

R version 3.3.1 (2016-06-21)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Ubuntu 16.04.1 LTS

locale:
 [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C               LC_TIME=en_US.UTF-8       
 [4] LC_COLLATE=en_US.UTF-8     LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8   
 [7] LC_PAPER=en_US.UTF-8       LC_NAME=C                  LC_ADDRESS=C              
[10] LC_TELEPHONE=C             LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C       

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] fec_0.0.0.9010 etl_0.3.4      dplyr_0.5.0    RMySQL_0.10.9  DBI_0.5-1     

loaded via a namespace (and not attached):
 [1] Rcpp_0.12.7     lubridate_1.6.0 digest_0.6.10   assertthat_0.1  R6_2.2.0        magrittr_1.5   
 [7] stringi_1.1.2   readxl_0.1.1    tools_3.3.1     stringr_1.1.0   downloader_0.4  readr_1.0.0    
[13] tibble_1.2