FOSS gamedev and creative worlds

I've followed all the instructions I could find to build under windows 32bit.
Using MinGW
CMake configures and generates ok, it compiles, but then when it get to linking (link.txt) I get hundreds of

I:/MineTest_build/sqlite-3.8.7.4/bin/sqlite3.lib(sqlite3.dir/Release/sqlite3.obj):(.text[_sqliteblahblahblah]+hexnumber): undefined reference to 'variable_blahblahblah'

I'm using sqlite-3.8.7.4 , DIR is my base dir that all libraries are located in

SQLITE3_LIBRARY = DIR/sqlite-3.8.7.4/bin/sqlite3.lib
SQLITE3_INCLUDE_DIR = DIR/sqlite-3.8.7.4/include (it has sqlite3.h in it)

do I not have something in the correct place?
would any other information help diagnose this?

Did you compile that sqlite3.lib with MinGW or is it a pre-compiled library? Compile it on your machine and try again.

If you need a CMakeLists.txt for this, use this (stupid simple) code:

I used a precompiled ver, I'll try to compile it, thanks.