EDK4.04 - Item name update script.

Help and support in getting the EVE-Dev Killboard to run on your site.
epsilonion
Noob
Posts: 7
Joined: Wed Mar 04, 2009 19:51

Re: EDK4.04 - Item name update script.

Post by epsilonion »

Found this in general chat for anyone with new items been imported into the killboard
http://eve-id.net/forum/viewtopic.php? ... 4&start=30

Snapey
Greenhorn
Posts: 18
Joined: Sat Feb 16, 2013 17:53

Re: EDK4.04 - Item name update script.

Post by Snapey »

Hay guys im sure one day this week ill get my Killboard working,
Ive got some kills showing and quite a few missing due to malformed Killmails, item changed names etc..
Ive tried to follow the link from the first page but nothing is there anymore or atleast im not seeing it, also with the dates will this also sort out the newer stuff thats due out, or will i have to do it all again. could someone help me out and show me this script and explain what i do :D
Im a daily poster atm, im sorry if im getting annoying i am spending hours trying to sort it myslef and only post as i give up and go to bed.

On another note is there a way of pulling a couple of months of kills and losses for my corp maybe a few hundred kills or do i have to manually post the older ones, ive followed the instructions and set up feed syndication from
http://eve-kill.net/?a=idfeed but it doesnt seem to have done anything but i do get.
Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and d.attributeID in (137,602)' at line 5
SQL: select itt_slot from kb3_item_types inner join kb3_dgmtypeattributes d where itt_id = d.value and d.typeID = and d.attributeID in (137,602);
ERROR [256] SQL error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and d.attributeID in (137,602)' at line 5
Error on line 46 in file /home/content/77/10518677/html/common/includes/class.dbnormalquery.php
PHP 5.3.14 (Linux), EDK 4.0.4 (Crucible)
File: /home/content/77/10518677/html/common/includes/class.dbnormalquery.php, line: 46, function: trigger_error
File: /home/content/77/10518677/html/common/includes/class.item.php, line: 152, class: DBNormalQuery, function: execute
File: /home/content/77/10518677/html/common/includes/class.idfeed.php, line: 806, class: Item, function: getSlot
File: /home/content/77/10518677/html/common/includes/class.idfeed.php, line: 556, class: IDFeed, function: processItem
File: /home/content/77/10518677/html/common/includes/class.idfeed.php, line: 485, class: IDFeed, function: processKill
File: /home/content/77/10518677/html/common/includes/class.idfeed.php, line: 138, class: IDFeed, function: processFeed
File: /home/content/77/10518677/html/common/admin/admin_idfeedsyndication.php, line: 155, class: IDFeed, function: read
File: /home/content/77/10518677/html/common/admin/admin_idfeedsyndication.php, line: 83, function: getIDFeed
File: /home/content/77/10518677/html/common/index.php, line: 293, function: include
File: /home/content/77/10518677/html/index.php, line: 27, function: include

Thanks in advance again.

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

Re: EDK4.04 - Item name update script.

Post by Salvoxia »

Typical error for outdated database, update to Retribution Database here: viewtopic.php?f=503&t=21504

edit: actually, with retribution 1.1. release take this one: viewtopic.php?f=503&t=21532

wehrner_stihl
Noob
Posts: 7
Joined: Sun Mar 10, 2013 00:07

Re: EDK4.04 - Item name update script.

Post by wehrner_stihl »

i have exactly the same problem, even though i'm using the newest retribution 1.1 db when getting data from syndication.. any way to debug and check what item it is failing on ?

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

Re: EDK4.04 - Item name update script.

Post by Salvoxia »

Do you have SQL query caching enabled? If so, try disabling it.

wehrner_stihl
Noob
Posts: 7
Joined: Sun Mar 10, 2013 00:07

Re: EDK4.04 - Item name update script.

Post by wehrner_stihl »

query cache is disabled, still the same error..

$slot_array[8] = array(Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and d.attributeID in (137,602)' at line 5
SQL: select itt_slot from kb3_item_types inner join kb3_dgmtypeattributes d where itt_id = d.value and d.typeID = and d.attributeID in (137,602);
ERROR [256] SQL error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and d.attributeID in (137,602)' at line 5
Error on line 46 in file /home/pxin/pxin.info/kb/common/includes/class.dbnormalquery.php
PHP 5.3.10-1ubuntu3.5 (Linux), EDK 4.0.4 (Crucible)

and as i said earlier, i have retribution 1.1 database

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

Re: EDK4.04 - Item name update script.

Post by Salvoxia »

You'd have to find out which item ID is causing that problem. Then you could check against your database and see what's wrong.
Or you could re-download and -deploy the retribution 1.1 database in case the update was incomplete for some reason.
Right now I can't think of any other cause than an inconsistent database or SQL query caching ...

wehrner_stihl
Noob
Posts: 7
Joined: Sun Mar 10, 2013 00:07

Re: EDK4.04 - Item name update script.

Post by wehrner_stihl »

i got it to work by adding &LastID=<last working id> to the feed-url.. and it pulled quite a few kills.. the funny thing is it pulled most(all) of the kills from 2006, and 2007 and then noting util last month... wonder if eve-kill is broken...

Post Reply