search

biow0lf / evedev-kb

Automatically exported from code.google.com/p/evedev-kb
1 stars 0 forks source link

API import failing to get damage type ID #215

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.Log into admin
2.Click import all api keys

What is the expected output? What do you see instead?
I expect it to import but I think the api is not returning a typeid and I get 
the following:

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 /httpdocs/common/includes/class.dbnormalquery.php
PHP 5.3.2-1ubuntu4 (Linux), EDK 4.0.4 (Crucible)
File: /httpdocs/common/includes/class.dbnormalquery.php, line: 46, function: 
trigger_error
File: /httpdocs/common/includes/class.item.php, line: 152, class: 
DBNormalQuery, function: execute
File: /httpdocs/common/includes/class.idfeed.php, line: 806, class: Item, 
function: getSlot
File: /httpdocs/common/includes/class.idfeed.php, line: 556, class: IDFeed, 
function: processItem
File: /httpdocs/common/includes/class.idfeed.php, line: 485, class: IDFeed, 
function: processKill
File: /httpdocs/common/includes/class.idfeed.php, line: 138, class: IDFeed, 
function: processFeed
File: /httpdocs/common/includes/api/class.killlog.php, line: 128, class: 
IDFeed, function: read
File: /httpdocs/common/admin/admin_api.php, line: 95, class: API_KillLog, 
function: Import
File: /httpdocs/common/index.php, line: 293, function: include
File: /httpdocs/index.php, line: 27, function: include

What version of the board are you using? e.g. 3.2.3 or 4.0 revision
4b53033f8a1b.

4.04

What version of PHP and MySQL does the board run on?

What is the url of a page where the error occurs or has occurred?
/?a=admin_api

Please provide any additional information below.
I believe it was importing correctly into eve-kill.net

Original issue reported on code.google.com by afin...@gmail.com on 14 Jun 2012 at 12:22

GoogleCodeExporter commented 9 years ago 
Sorry I've jsut noticed this is a duplicate of 214.  Please mark as a duplicate

Original comment by afin...@gmail.com on 14 Jun 2012 at 4:16

GoogleCodeExporter commented 9 years ago

Original comment by idun@theexecutioners.org on 16 Jan 2013 at 8:47