dbrummer
ASTARTES CORP Hashashin Cartel
79
|
Posted - 2012.10.03 22:37:00 -
[1] - Quote
A few things. First, thank you for putting this together, it's greatly appreciated.
When I ran through the install, it did not execute the .sql included in the RAR, I had to manually execute it.
When veiwing a full apis contracts, I receive this error:
Quote: FATAL SQL ERROR
QUERY: 'SELECT solarSystemID, solarSystemName FROM mapSolarSystems WHERE solarSystemID IN ()'
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 ')' at line 1
Backtrace: #0 eveDb->query(SELECT solarSystemID, solarSystemName FROM mapSolarSystems WHERE solarSystemID IN ()) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/eveDb.php:620] #1 eveDb->cacheLocationIds(Array ([0] => )) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/eveApiContracts.class.php:370] #2 eveApiContracts->loadAPI() called at [/webpages/astartes.digitalnode.net/public_html/jackknife/eveApi.base.php:57] #3 eveApi->fetch_xml(/char/Contracts.xml.aspx, Array ([characterID] => 90194439,[keyID] => 1368255,[vCode] => lIfLQTWCZJeVta3sGXFiVHVzk0l84cdgwAjH1etYg9hvx8qGPxbzb8JTeCZNEBSY)) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/eveApiContracts.class.php:173] #4 eveApiContracts->fetch(90194439, 1368255, lIfLQTWCZJeVta3sGXFiVHVzk0l84cdgwAjH1etYg9hvx8qGPxbzb8JTeCZNEBSY, ) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/pages/auditorContractsPage.class.php:65] #5 auditorContractsPage->GetOutput(eveDb Object ([link] => Resource id #23,[queries] => 8,[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array ([SELECT stationID, stationName, solarSystemID FROM staStations WHERE stationID IN (60012154,60007573,60014452,60004588,60002860)] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60012154 LIMIT 1] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60007573 LIMIT 1] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60014452 LIMIT 1] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60004588 LIMIT 1] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60002860 LIMIT 1] => 1))) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/index.php:307]
All of my assets show 'UNKNOWN TYPE', is that expected?
Thanks. |