ZKB SQL error

Help and support in getting the EVE-Dev Killboard to run on your site.
Post Reply
xrtdgrv
Greenhorn
Posts: 14
Joined: Tue Nov 10, 2009 02:39

ZKB SQL error

Post by xrtdgrv » Wed Jul 10, 2019 20:23

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
Greenhorn
Posts: 14
Joined: Tue Nov 10, 2009 02:39

Re: ZKB SQL error

Post by xrtdgrv » Wed Jul 10, 2019 22:03

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

Thanks

User avatar
Salvoxia
Developer
Posts: 1584
Joined: Wed Feb 22, 2012 12:11

Re: ZKB SQL error

Post by Salvoxia » Fri Jul 12, 2019 14:32

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
Attachments
class.item.zip
(4.09 KiB) Downloaded 3 times

Post Reply

Return to “Support”

Who is online

Users browsing this forum: No registered users and 4 guests