MCDB insert error

[bendmorris]

I'm getting this error on mysql, postgres, and sqlite (Ubunt 12.04)

INSERT INTO MCDB_communities (record_id, site_id, initial_year, species_id, presence_only, abundance, mass) VALUES (null, 1008, 2002, CHPE, '0', 52, null);

psycopg2.ProgrammingError: column "chpe" does not exist

[ethanwhite]

Weird. I don't get this for any of the DBMS using the current master on Ubuntu 12.04. However, I am now seeing a different error when importing the trapping table (new issue coming momentarily).

[bendmorris]

This is kind of funny - I had previously tested all scripts using every engine, including CSV. CSV created a file in my retriever directory called MCDB_communities.csv, which also happens to be the name of the raw data file. So it was trying to use that file instead of the actual raw data file. Nothing to see here.

[ethanwhite]

What's even funnier is that in getting ready to report the new error I'm seeing I checked to see if it happened on CSV as well, it didn't, I switched back to get the error message and then started getting something like your error message. If I hadn't glanced at my email I would have been totally confused.

[bendmorris]

Yeah, I spent a decent amount of time trying to figure this one out. I blame the MCDB people; how dare they use such reasonable file names for their data.