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 » Fri Dec 28, 2012 21:14

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 http://eve-id.net/forum/viewtopic.php?f=503&t=21504&start=30

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

Re: EDK4.04 - Item name update script.

Post by Snapey » Tue Feb 19, 2013 00:33

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: 1517
Joined: Wed Feb 22, 2012 12:11

Re: EDK4.04 - Item name update script.

Post by Salvoxia » Tue Feb 19, 2013 08:28

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

edit: actually, with retribution 1.1. release take this one: http://evekb.org/forum/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 » Sun Mar 10, 2013 00:09

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: 1517
Joined: Wed Feb 22, 2012 12:11

Re: EDK4.04 - Item name update script.

Post by Salvoxia » Sun Mar 10, 2013 01:31

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 » Sun Mar 10, 2013 09:32

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: 1517
Joined: Wed Feb 22, 2012 12:11

Re: EDK4.04 - Item name update script.

Post by Salvoxia » Sun Mar 10, 2013 15:20

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 » Sun Mar 10, 2013 20:16

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

Return to “Support”

Who is online

Users browsing this forum: No registered users and 5 guests