{"id":2836,"date":"2017-03-24T14:01:08","date_gmt":"2017-03-24T22:01:08","guid":{"rendered":"http:\/\/bien.nceas.ucsb.edu\/bien\/?page_id=2836"},"modified":"2018-05-10T15:04:26","modified_gmt":"2018-05-10T23:04:26","slug":"rbien-faq","status":"publish","type":"page","link":"https:\/\/bien.nceas.ucsb.edu\/bien\/tools\/rbien\/rbien-faq\/","title":{"rendered":"RBIEN FAQ"},"content":{"rendered":"<p><strong>Frequently Asked Questions:<\/strong><\/p>\n<ul>\n<li><strong>I received the error, \u201cError in postgresqlNewConnection(drv, &#8230;) :\u00a0RS-DBI driver: (could not connect\u00a0public_bien@vegbiendev.nceas.ucsb.edu\u00a0on dbname \"public_vegbien\")\u201d, what went wrong?<\/strong><\/li>\n<\/ul>\n<p>This error is usually caused by the SQL connections that this package relies upon being blocked by either an institution or a computer\u2019s software (often a firewall or antivirus program).\u00a0 If the issue lies with your institution, the simplest solution is to run the code in a different location (e.g. at home or a coffee shop).\u00a0 If the issue is with a user\u2019s computer, this can be fixed by changing your software settings.\u00a0 Note that sometimes only wireless SQL connections are blocked and using a wired connection will resolve the issue.<\/p>\n<ul>\n<li><strong>Which columns are returned by which RBIEN functions, and are they by default or optional?<\/strong><\/li>\n<\/ul>\n<p>A full listing of columns returned by specific RBIEN functions are available in <a href=\"http:\/\/bien.nceas.ucsb.edu\/bien\/wp-content\/uploads\/2017\/05\/columns_returned_by_queries_5_4_2017.csv\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>this CSV file<\/strong><\/a>.<\/p>\n<ul>\n<li><strong>What causes the following error message, and how do I fix it?<\/strong> :<\/li>\n<\/ul>\n<pre>In file included from RS-PQescape.c:7:\r\n.\/RS-PostgreSQL.h:<span class=\"aBn\" tabindex=\"0\" data-term=\"goog_304533995\"><span class=\"aQJ\">23:14<\/span><\/span>: fatal error: 'libpq-fe.h' file not found\r\n#\u00a0\u00a0\u00a0 include \"libpq-fe.h\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ^\r\n1 error generated.\r\nmake: *** [RS-PQescape.o] Error 1\r\nERROR: compilation failed for package \u2018RPostgreSQL\u2019\r\n* removing \u2018\/Library\/Frameworks\/R.<wbr \/>framework\/Versions\/3.4\/<wbr \/>Resources\/library\/RPostgreSQL\u2019\r\nWarning in install.packages :\r\n\u00a0 installation of package \u2018RPostgreSQL\u2019 had non-zero exit status\r\nERROR: dependency \u2018RPostgreSQL\u2019 is not available for package \u2018BIEN\u2019\r\n* removing \u2018\/Library\/Frameworks\/R.<wbr \/>framework\/Versions\/3.4\/<wbr \/>Resources\/library\/BIEN\u2019\r\nWarning in install.packages :\r\n\u00a0 installation of package \u2018BIEN\u2019 had non-zero exit status\r\n\r\n<\/pre>\n<div id=\"m_9192785062870271433Signature\">\n<div id=\"m_9192785062870271433divtagdefaultwrapper\">Jamie Kass points pointed out <a href=\"https:\/\/github.com\/PecanProject\/pecan\/issues\/131\" target=\"_blank\" rel=\"noopener noreferrer\" data-saferedirecturl=\"https:\/\/www.google.com\/url?hl=en&amp;q=https:\/\/github.com\/PecanProject\/pecan\/issues\/131&amp;source=gmail&amp;ust=1494961816299000&amp;usg=AFQjCNHhPbz8Q1gEFoFEnuIMxpSB0nNUBQ\">this<\/a> issue thread, and did the following to resolve the issue (thanks, Jamie!) :<br \/>\n<code>&gt; install.packages('DBI')<\/code><br \/>\n<code>$ brew install postgresql<\/code><br \/>\n<code>$ sudo ln -s \/usr\/local\/Cellar\/postgresql \/usr\/local\/opt\/postgresql<\/code><\/div>\n<div><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>When trying to download range maps, I receive the following error:<\/strong><\/li>\n<\/ul>\n<pre><span style=\"font-weight: 400;\">NOTE: rgdal::checkCRSArgs: no proj_defs.dat in PROJ.4 shared files<\/span>\r\n<span style=\"font-weight: 400;\">Error in CRS(p4s) : no system list, errno: 2<\/span><\/pre>\n<p>This warning is caused by a problem with certain versions of PROJ on certain platforms. \u00a0For a solution, see\u00a0<a href=\"https:\/\/github.com\/OSGeo\/proj.4\/issues\/351\">https:\/\/github.com\/OSGeo\/proj.4\/issues\/351<\/a><\/p>\n<ul>\n<li><strong>Can I access a previous database version?<\/strong><\/li>\n<\/ul>\n<p>As of BIEN4.0, we are now keeping the previous database version accessible.\u00a0 Earlier versions of the database are archived, but not active.\u00a0 To access the previous database version (in the case of BIEN4.0, that will be BIEN3.4.5), you need to use an older version of the BIEN R package (in this case, version 1.2.1 of the R package), which can be installed using the \"install_version\" function in R.\u00a0 You'll also need to specify the name of the previous database version, which is \"public_3_4_5\".\u00a0 \u00a0Here's an example:<\/p>\n<pre>install_version(package = \"BIEN\",version = \"1.2.1\")\r\nlibrary(BIEN)\r\nBIEN_trait_list(species = \"Acer rubrum\", schema = \"public_3_4_5\")<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Frequently Asked Questions: I received the error, \u201cError in postgresqlNewConnection(drv, &#8230;) :\u00a0RS-DBI driver: (could not connect\u00a0public_bien@vegbiendev.nceas.ucsb.edu\u00a0on dbname \"public_vegbien\")\u201d, what went wrong? This error is usually caused by the SQL connections that this package relies upon being blocked by either an institution or a computer\u2019s software (often a firewall or antivirus program).\u00a0 If the issue lies [&hellip;]<\/p>\n","protected":false},"author":68,"featured_media":0,"parent":2792,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-2836","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/2836"}],"collection":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/users\/68"}],"replies":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/comments?post=2836"}],"version-history":[{"count":13,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/2836\/revisions"}],"predecessor-version":[{"id":3183,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/2836\/revisions\/3183"}],"up":[{"embeddable":true,"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/pages\/2792"}],"wp:attachment":[{"href":"https:\/\/bien.nceas.ucsb.edu\/bien\/wp-json\/wp\/v2\/media?parent=2836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}