search

biow0lf / evedev-kb

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

typeID missing in Items on kill_detail page #159

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
The version I downloaded from git gives me an error :- 

"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 
D:\www\killboard\common\includes\class.dbnormalquery.php
PHP 5.3.4 (WINNT), EDK 3.3beta (Incursion)
File: D:\www\killboard\common\includes\class.dbnormalquery.php, line: 46, 
function: trigger_error
File: D:\www\killboard\common\includes\class.item.php, line: 166, class: 
DBNormalQuery, function: execute
File: D:\www\killboard\common\includes\class.destroyeditem.php, line: 132, 
class: Item, function: getSlot
File: D:\www\killboard\common\kill_detail.php, line: 185, class: DestroyedItem, 
function: getLocationID
File: D:\www\killboard\common\kill_detail.php, line: 161, class: pKillDetail, 
function: fittingSetup
File: D:\www\killboard\common\includes\class.pageassembly.php, line: 63, 
function: call_user_func_array
File: D:\www\killboard\common\includes\class.pageassembly.php, line: 32, class: 
pageAssembly, function: call
File: D:\www\killboard\common\kill_detail.php, line: 1386, class: pageAssembly, 
function: assemble
File: D:\www\killboard\common\index.php, line: 286, function: include
File: D:\www\killboard\index.php, line: 27, function: include"

If I change line 164 from "and d.typeID = ".$this->row_['typeID']."" to and 
d.typeID = ".$this->row_['itt_id']." the error goes away

The url clicked was http://killboard.localhost/index.php/kill_detail/90/

I checked out this version 
http://code.google.com/p/evedev-kb/source/browse/?r=3f6acd541995f456e94b727112e5
9df11d2400f9

Original issue reported on code.google.com by vascowhite on 6 Sep 2011 at 6:38

GoogleCodeExporter commented 9 years ago 
It is intended to be typeID, not itt_id/groupID.

Since the typeID is also the id for the Item itself, something has gone wrong 
with the list of items on the ship. Is the error still occurring for you? If 
so, try going to admin, cache, and clear the file cache. If you still see the 
error try disabling the Object Cache. If either of these make the error go 
away, please re-enable to check if they return.

Original comment by kovellia on 7 Sep 2011 at 12:03

GoogleCodeExporter commented 9 years ago 
This was a brand new install on a new server, so I had discounted cacheing as 
part of the problem. I have tried what you suggested with no success.

A var_dump($row) at line 33 gave me a list of items, here is one :-

array
  'itm_icon' => string '01_08' (length=5)
  'itm_externalid' => string '11648' (length=5)
  'itm_value' => string '1645999' (length=7)
  'itt_id' => string '328' (length=3)
  'itt_cat' => string '7' (length=1)
  'itt_name' => string 'Armor Hardener' (length=14)
  'itt_slot' => string '3' (length=1)
  'itm_techlevel' => string '5' (length=1)
  'usedcharge' => null
  'usedlauncher' => null
  'groupID' => string '328' (length=3)
  'typeName' => string 'Armor Thermic Hardener II' (length=25)
  'capacity' => string '0' (length=1)
  'raceID' => string '0' (length=1)
  'basePrice' => string '478192' (length=6)
  'marketGroupID' => string '535' (length=3)
  'itd_quantity' => string '2' (length=1)
  'itd_itm_id' => string '11648' (length=5)
  'itd_itl_id' => string '0' (length=1)
  'itl_location' => string 'Fitted - High slot' (length=18)

As you can see itemID doesn't appear, so I'm not sure what is going on.

Original comment by vascowhite on 7 Sep 2011 at 8:51

GoogleCodeExporter commented 9 years ago 
I can find a way to create the Item without the typeID set - when the ItemList 
class creates it. I still don't see why it's a problem now, since it's not been 
a problem before!

Does the latest commit help?

Original comment by kovellia on 8 Sep 2011 at 5:01

GoogleCodeExporter commented 9 years ago 
Yes, lates t commit has solved the problem, whatever it was....

Thanks.

Original comment by vascowhite on 8 Sep 2011 at 8:37

GoogleCodeExporter commented 9 years ago

Original comment by kovellia on 30 Oct 2011 at 12:11

GoogleCodeExporter commented 9 years ago 
alright getting this error 2. the killboard database/config has not been 
touched. Started showing up yesterday

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/bladerunners/bladerunners-eve.net/common/includes/class.dbnormalquery.php
PHP 5.3.5 (Linux), EDK 4.0.1 (Crucible)
File: 
/home/bladerunners/bladerunners-eve.net/common/includes/class.dbnormalquery.php,
 line: 46, function: trigger_error
File: /home/bladerunners/bladerunners-eve.net/common/includes/class.item.php, 
line: 152, class: DBNormalQuery, function: execute
File: /home/bladerunners/bladerunners-eve.net/common/includes/class.idfeed.php, 
line: 706, class: Item, function: getSlot
File: /home/bladerunners/bladerunners-eve.net/common/includes/class.idfeed.php, 
line: 472, class: IDFeed, function: processItem
File: /home/bladerunners/bladerunners-eve.net/common/includes/class.idfeed.php, 
line: 403, class: IDFeed, function: processKill
File: /home/bladerunners/bladerunners-eve.net/common/includes/class.idfeed.php, 
line: 131, class: IDFeed, function: processFeed
File: 
/home/bladerunners/bladerunners-eve.net/common/admin/admin_idfeedsyndication.php
, line: 153, class: IDFeed, function: read
File: 
/home/bladerunners/bladerunners-eve.net/common/admin/admin_idfeedsyndication.php
, line: 83, function: getIDFeed
File: /home/bladerunners/bladerunners-eve.net/common/index.php, line: 293, 
function: include
File: /home/bladerunners/bladerunners-eve.net/index.php, line: 27, function: 
include

Original comment by franky...@gmail.com on 30 May 2012 at 7:00

GoogleCodeExporter commented 9 years ago 
I have the same Issue for my board when I try Sindication.
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 C:\ampp\htdocs\eve\common\includes\class.dbnormalquery.php
 PHP 5.3.5 (WINNT), EDK 4.0.4 (Crucible)
 File: C:\ampp\htdocs\eve\common\includes\class.dbnormalquery.php, line: 46, function: trigger_error
 File: C:\ampp\htdocs\eve\common\includes\class.item.php, line: 152, class: DBNormalQuery, function: execute
 File: C:\ampp\htdocs\eve\common\includes\class.idfeed.php, line: 806, class: Item, function: getSlot
 File: C:\ampp\htdocs\eve\common\includes\class.idfeed.php, line: 556, class: IDFeed, function: processItem
 File: C:\ampp\htdocs\eve\common\includes\class.idfeed.php, line: 485, class: IDFeed, function: processKill
 File: C:\ampp\htdocs\eve\common\includes\class.idfeed.php, line: 138, class: IDFeed, function: processFeed
 File: C:\ampp\htdocs\eve\common\admin\admin_idfeedsyndication.php, line: 155, class: IDFeed, function: read
 File: C:\ampp\htdocs\eve\common\admin\admin_idfeedsyndication.php, line: 83, function: getIDFeed
 File: C:\ampp\htdocs\eve\common\index.php, line: 293, function: include
 File: C:\ampp\htdocs\eve\index.php, line: 27, function: include

Original comment by timotocu...@gmail.com on 1 Jun 2012 at 1:32