[Solved] Problems with adi Import (solution below)

2 posts / 0 new
Last post
DL8BH
[Solved] Problems with adi Import (solution below)

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

DL8BH
The real problem was, that my

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/