Search found 16 matches

by 1450
Mon Feb 04, 2019 21:31
Forum: Support
Topic: New Killboard install with multiple SQL errors
Replies: 6
Views: 10215

Re: New Killboard install with multiple SQL errors

It looks like you used a hyphen - rather than underscore _ in your my.cnf so it hasn't took effect (which is why the variables show the 5.7 defaults) I actually believe MySQL 5.6 default was sql_mode="NO_ENGINE_SUBSTITUTION" and I also believe you can set it on the fly using `SET GLOBAL` j...
by 1450
Sun Feb 03, 2019 16:29
Forum: Support
Topic: New Killboard install with multiple SQL errors
Replies: 6
Views: 10215

Re: New Killboard install with multiple SQL errors

You set the sql_mode variable in your my.cnf (MySQL server configuration)

You will likely need to add it, under the [mysqld] section.

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
by 1450
Sat Feb 02, 2019 19:55
Forum: Support
Topic: New Killboard install with multiple SQL errors
Replies: 6
Views: 10215

Re: New Killboard install with multiple SQL errors

While the query should be re-written in code, the issue is brought to light by default settings changes in MySQL 5.7

You can set sql_mode="" in your my.cnf to revert to previous behavior which should bypass the warning.
by 1450
Mon Jan 28, 2019 21:03
Forum: Modding
Topic: [EDK4] allicorpstats_page update
Replies: 60
Views: 107480

Re: [EDK4] allicorpstats_page update

697462 Kills (46 queries SQL time 15.2061s, Total time 15.2304s)

Didn't measure memory consumption, DB is on 7200RPM HDDs, caching disabled.

So it's certainly possible to run :)
by 1450
Thu Jan 24, 2019 22:07
Forum: General Killboard Chat
Topic: EDK 4.4.2.0 (Onslaught 1.0)
Replies: 15
Views: 31442

Re: EDK 4.4.2.0 (Onslaught 1.0)

Thanks for the hotfix, resolves the issue :)
by 1450
Sun Jan 20, 2019 23:02
Forum: General Killboard Chat
Topic: EDK 4.4.2.0 (Onslaught 1.0)
Replies: 15
Views: 31442

Re: EDK 4.4.2.0 (Onslaught 1.0)

Not tried zKB but ESI pulling is broken with killmails involving Standup fighters, keepstars common/includes/class.esiparser.php: - Around line 641: throw new EsiParserException("Involved party is an NPC with a ship type not found in the database! Kill-ID: ".$this->externalID); } $involved...
by 1450
Sun Jan 10, 2016 01:24
Forum: Support
Topic: clearing cache
Replies: 2
Views: 7177

Re: clearing cache

It would be nice to have an option to disable the Pheal cache as we use API Proxies that handle caching so it's redundant on the EDK side.

I have disabled it through code modification but it would be nice to have a settable option.
by 1450
Wed Dec 23, 2015 00:17
Forum: Support
Topic: PHP Error when using PHP7.0
Replies: 13
Views: 19874

Re: PHP Error when using PHP7.0

EDK works under PHP 7.0 however there are some code warnings/deprecated notices (which is what spawned the work to only display errors if display errors is enabled in PHP)

Oh and it doesn't have memcache only memcached extension :)
by 1450
Sat Nov 28, 2015 15:16
Forum: General Killboard Chat
Topic: EDK 4.2.16.0 (Parallax 1.0)
Replies: 16
Views: 23115

Re: EDK 4.2.16.0 (Parallax 1.0)

Has anyone else had any issues with manually posting killmails and the time on the mail being inserted with time added to it? http://pastebin.com/7PT9jQ4r Shows on the killboard as: 2015-11-28 08:28:00 and using the Killboard link to view the killmail outputs the mail with the changed time: http://p...
by 1450
Fri Jul 03, 2015 20:00
Forum: Support
Topic: Duplicate names cause issues
Replies: 5
Views: 10108

Re: Duplicate names cause issues

It probably shouldn't be in the upcoming release for July. But posted more as a foundation to lay the work for further work on the matter. I was working on it at stupid o'clock in the morning so I will need some further time to assess it since at the moment it only works/is tested with entities with...