USDA plants error - PostgreSQL 8.4

[weecology]

USDA plants error - PostgreSQL 8.4

[ethanwhite]

Is this on the most recent release (1.3)?

I can't replicate in Postgres 9.1 on Ubuntu 12.04. The only thing that seems unique about that line is that there are 2 unicode characters (there are several lines above it with one of the same character). Both characters are stripped out in 9.1 on Ubuntu.

[ethanwhite]

OK, I've replicated this on 8.4 on Windows. Platform dependence how you vex me.

[ethanwhite]

The rest of the error message is "Acer negundo L. ssp. interius (Britton) A. L& D. L, '', 'Aceraceae');".

So, it looks to me like the second umlaut-ed 'o' is causing the double quote at the end of the species field to not be read in, thus breaking the insert.

I don't yet know whether this difference is OS, Postgres version, or even the Python version that the .exe was compiled with compared to that on Ubuntu 12.04.

[ethanwhite]

Same error on Windows using PostgreSQL 9.1, so it's not a Postgres version issue (at least not just a Postgres version issue). Similar problem with quotes and INSERT error on McGlinn 2010.

...VALUES(257, 'seneplat', 'Asteraceae', 'Packera', 'plattensis', '', '', 'Packera plattensis', '(Nutt.) W.A. Weber & A. L,'')

Oh, and Kate, thanks again for being our number one user and helping us run down all of these bugs. If we didn't have folks working on other systems we'd never have a fully working package. Thanks!

[ethanwhite]

And in Del Moral 2010. The common theme is a field containing parentheses is missing the final single quote, which is causing the error.

[ethanwhite]

I just rebuilt this on Windows and it seems to work fine, so this might have been a Python version issue. Can you download it again and see if that fixes the problem.

[ethanwhite]

Closing based on my tests. This means that we probably need to make sure that the Windows machine we use for building releases is running Python >= 2.7.3