Inventory Problem (Koboldv2)

[kalak]

Alright, so I've got this problem. Before I start, I'll preface this by saying that I'm almost absolutly sure that I've followed the Koboldv2 installation instructions to the letter (the one with the pictures).

However, nothing stays in the inventory. They'll stay in until a loading screen comes up or until I close the game, and then they all dissapear. When I pick up an item in game, I get a long error in the WS_Server_Alive batch file:

21 23:54:16 E sqlpp: error executing query, error code[1][Unknown column 'type_i
            E sqlpp: d' in 'field list']
21 23:54:16 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
            E sqlpp:  `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
            E sqlpp: 7387905, '1 1073741824 3 19230 1065353216 0 1 0 1 0 0 0 0 0
            E sqlpp:  1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
            E sqlpp: 0 0 0 0 0 ', '1 1073741824 3 19230 1065353216 0 1 0 1 0 0 0
            E sqlpp:  0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
            E sqlpp: 0 0 0 0 0 0 0 ', 1, 3, '0 ' ) ]
21 23:54:16 E item: error: db << guid[4000000000000001] flags[1]
21 23:54:16 E sqlpp: error executing query, error code[1][Unknown column 'type_i
            E sqlpp: d' in 'field list']
21 23:54:16 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
            E sqlpp:  `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
            E sqlpp: 7387905, '1 1073741824 3 19230 1065353216 0 1 0 1 0 0 0 0 0
            E sqlpp:  1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
            E sqlpp: 0 0 0 0 0 ', '1 1073741824 3 19230 1065353216 0 1 0 1 0 0 0
            E sqlpp:  0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
            E sqlpp: 0 0 0 0 0 0 0 ', 1, 3, '0 ' ) ]
21 23:54:16 E item: error: db << guid[4000000000000001] flags[1]
21 23:54:16 E sqlpp: error executing query, error code[1][Unknown column 'type_i
            E sqlpp: d' in 'field list']
21 23:54:16 E sqlpp: your failed query[INSERT INTO item_instances (guid, `data`,
            E sqlpp:  `indepData`, flags, type_id, `loot`) VALUES ( 461168601842
            E sqlpp: 7387905, '1 1073741824 3 19230 1065353216 0 1 0 1 0 0 0 0 0
            E sqlpp:  1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
            E sqlpp: 0 0 0 0 0 ', '1 1073741824 3 19230 1065353216 0 1 0 1 0 0 0
            E sqlpp:  0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
            E sqlpp: 0 0 0 0 0 0 0 ', 1, 3, '0 ' ) ]
21 23:54:16 E item: error: db << guid[4000000000000001] flags[1]

That was just for one item, randomly imported into my pack. Looting/buying produces the same error.

What I've done so far:
1) completely removed the database and koboldv2, set it up again
2) copied out the inventory parts in various sqls and imported them into navicat
3) asked for help on this forum

Thanks in advance for suggestions/answers.

[MentaL]

[chriz0001]

the table-structure for item_instance has changed in V2 ..

guid bigint 20
data text
indepdata text
flags int 11
typeid int 11
loot longtext

[kalak]

eh... what do i do with that?