ZKB SQL error

[xrtdgrv]

Hey all,

lets start with the sequence of events.

1. Ran fresh install of KB
2. had issues pulling from zkill
3. installed the hot fix
4. was able to bull 01/01/19 thru 01/15/19 no issues then started to experience what seemed to be hung imports
5. installed the "Kill posting throws an error for specific kills"
6. cleared cache
7. now getting this error: Database error: Data truncated for column 'isDefault' at row 1
SQL: REPLACE INTO kb3_dgmtypeeffects (`typeID`, `effectID`, `isDefault`) VALUES (52252, 4902, 0), (52252, 7085, 0), (52252, 7086, 0), (52252, 7092, 0), (52252, 7093, 0), (52252, 7094, 0), (52252, 7112, 0), (52252, 7211, 0), (52252, 7228, 0)

any help would be great thanks

[xrtdgrv]

this looks to be possibly a temporary error and clears up but occurs off and on.

Thanks

[Salvoxia]

Hi,

thanks for bringing this to my attention.
This is probably caused by rather strict settings on your database.
I attached an updated version of common/includes/class.item.php. Could you please replace yours with it and check if that error is gone for good?

Also, this can only happen if there's an item in the killmail which is not yet in EDK's database.
At the moment you won't be able to check it using zKBFetch, as it seems that the zKB Blackout also covers the API.

Best Regards,
Salvoxia