[IPT] IPT bug -> MySQL

["Dröge, Gabriele"]

Dear all,

I've downloaded the latest IPT version 2.0.5-r4398 and tried to map my data.
I want to use a MySQL database, but there seems to be a bug in IPT concerning MySQL.
IPT is not able to handle the SQL statement even though it is correct (tested on the MySQL server directly)
Log file says:

1.       Error in SQL (there is definitely no error in the sql statement)

2.       IPT expects one more column than the sql statement queries for (unclear why)

3.       IPT can't handle datetime (unclear why)

A CSV file and a connection to a MS SQL Server did work.

Preview looks like this:

[cid:image001.jpg at 01CECB47.70BB6950]


It would be great if someone could fix those bugs.
Thanks in advance!

Best wishes,
Gabi

-----------------------------------------------------------------
Gabriele Droege
Coordinator - DNA Bank Network
Global Genome Biodiversity Network (GGBN)
Berlin-Dahlem DNA Bank
Deputy Women's Officer ZE BGBM

Botanic Garden and Botanical Museum Berlin-Dahlem
Freie Universität Berlin
Koenigin-Luise-Str. 6-8
14195 Berlin
Germany

+49 30 838 50 139

www.dnabank-network.org<http://www.dnabank-network.org>
www.ggbn.org<http://www.ggbn.org>
www.bgbm.org<http://www.bgbm.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.gbif.org/pipermail/ipt/attachments/20131017/31b73500/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 27462 bytes
Desc: image001.jpg
Url : http://lists.gbif.org/pipermail/ipt/attachments/20131017/31b73500/attachment-0001.jpg