I had some issues with the adi-Import.I took the adif-export from wintest and wanted to import it into my cqrlog-database.
Whenever the cqrlog-import hits a call, where its dxcc-resolution fails (ru6k ua7k la/pf1bre/mm as examples) import fails with following error message in the debug-console:
"Import failed! : Error executing query: Incorrect integer value: '' for column 'itu' at row 1"
Until I delete all of the problematic qsos out of my adi, the complete log wont import.
Deleting this qsos and inserting them manually (with manually correcting the dxcc-field) works for me, just want to let you know about this issue.
I am using 1.9.0 amd64 as well as i386 on debian, both with same results.
73, Bernd DL8BH
Wed, 2015-03-25 11:17
#1
[Solved] Problems with adi Import (solution below)
The real problem was, that my new, freebsd-based mysql server was running in mysql strict mode per default (my debian based mysql servers have strict mode disabled).
If someone gets this error too:
unset the mysql strict mode as described here:
https://support.realtyna.com/index.php?/Knowledgebase/Article/View/535/0...
73, Bernd DL8BH
a simple webinterface for cqrlog, screenshots over here: http://www.dl8bh.de/cqrweblog/