Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in result_create(conn@ptr, statement) : no such table: ... #13

rerickson-usgs opened this issue Apr 24, 2019 · 2 comments


None yet
2 participants
Copy link

commented Apr 24, 2019

I am trying to run code that worked on a co-workers machine.

When I try to run

 taxa <- accessionToTaxa(arthropoda[ condor_index, 1], sqlFile= "accessionTaxa.sql")

I get the following error message

Error in result_create(conn@ptr, statement) :
no such table: accessionTaxa
Timing stopped at: 0.031 0.003 0.036

A quick Google search found this question on SO and a comment one of the answers notes

The problem is that RSQLite 2.0 was just released and does not work with older versions of sqldf. sqldf 0.4-11 which was just released should be used (or else use an older version of RSQLite)

I have tried upgrading taxonomizr and am using taxonomizr_0.5.3. Do you have any suggestions? Or has anyone else seen this with the package before?


This comment has been minimized.

Copy link

commented Apr 24, 2019

That could be something complex but I wonder if something went wrong when making the database. Could you try deleting accessionTaxa.sql and reinstalling with prepareDatabase('accessionTaxa.sql') (note that'll download some big files and take a while to process)?


This comment has been minimized.

Copy link

commented Apr 25, 2019

Thank you for the tip. There is some problem with how my machine was regenerating the sql database. (My solution was to just use the sql database generated on my co-workers machine).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.