EDK4.04 - Item name update script.

[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]

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
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.

[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]

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 ?

[Salvoxia]

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

[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

[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]

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...