These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Kinda new to this API stuff

First post
Author
Previous Topic Next Topic
Char'lee Foxtrot
Caldari Provisions
Caldari State
#1 - 2015-07-04 19:37:41 UTC
Greetings!

I am a total noob when it comes to this, so maybe I am doing something wrong.

I am attempting to import the latest database from Static Data Export (SDE) by following the tutorial outlined by Trenker (kudos BTW).

Unfortunately, the procedure may be out of date. When I try to import the ebs_DATADUMP.sql file, I receive an error:
#1064 - 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 'IF OBJECT_ID ('dbo.trnTranslations') IS NOT NULL
DROP TABLE dbo.trnTranslatio' at line 2

(I tried to cut and paste each line of SQL into phpMyAdmin and even tried adding semicolons but to no joy).

I just downloaded the latest version of XAMPP (Version 5.6.8) today. So I assume I have the latest and greatest bundle.

Thanks in advance for any assistance.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-07-04 21:32:20 UTC
Out of date.

get:
https://www.fuzzwork.co.uk/dump/mysql56-carnyx-1.0-113321.tbz2

(or wait until Aegis is out, and I have that converted Blink )

untar it with 7zip.



c:\xampp\mysql\bin\mysqladmin.exe -u root drop eve
c:\xampp\mysql\bin\mysqladmin.exe -u root create eve
c:\xampp\mysql\bin\mysql.exe -u root eve < mysql56-carnyx-1.0-113321.sql

(assuming you're in the same directory as you unzipped that file to. )

The ebs_DATADUMP.sql file isn't important, in any way, shape, or form. The SDE's meat comes in the form of the yaml files, the universe sqlite db and an MS SQL backup. Which is why I provide a conversion of it Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Mr Mac
Dark Goliath
#3 - 2015-07-04 21:33:12 UTC  |  Edited by: Mr Mac
Char'lee Foxtrot wrote:
Greetings!

I am a total noob when it comes to this, so maybe I am doing something wrong.

I am attempting to import the latest database from Static Data Export (SDE) by following the tutorial outlined by Trenker (kudos BTW).

Unfortunately, the procedure may be out of date. When I try to import the ebs_DATADUMP.sql file, I receive an error:
#1064 - 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 'IF OBJECT_ID ('dbo.trnTranslations') IS NOT NULL
DROP TABLE dbo.trnTranslatio' at line 2

(I tried to cut and paste each line of SQL into phpMyAdmin and even tried adding semicolons but to no joy).

I just downloaded the latest version of XAMPP (Version 5.6.8) today. So I assume I have the latest and greatest bundle.

Thanks in advance for any assistance.


Those .BAK and .SQL files for MS SQL.

Try Steve's MySQL conversion

EDIT: You beat me, Steve Pirate
Vinoth Gebrial
State War Academy
Caldari State
#4 - 2015-07-07 02:09:48 UTC  |  Edited by: Vinoth Gebrial
I'm also really new to this api stuff but I've managed to access info on the public crest so far. I'm having trouble figuring out how to access the auth crest. I've been looking but can't find any recent-ish guides. Anywhere in specific I should be looking?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-07-07 11:35:34 UTC
Vinoth Gebrial wrote:
I'm also really new to this api stuff but I've managed to access info on the public crest so far. I'm having trouble figuring out how to access the auth crest. I've been looking but can't find any recent-ish guides. Anywhere in specific I should be looking?



Do you have a language of preference?

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Vinoth Gebrial
State War Academy
Caldari State
#6 - 2015-07-09 17:09:49 UTC  |  Edited by: Vinoth Gebrial
Steve Ronuken wrote:
Vinoth Gebrial wrote:
I'm also really new to this api stuff but I've managed to access info on the public crest so far. I'm having trouble figuring out how to access the auth crest. I've been looking but can't find any recent-ish guides. Anywhere in specific I should be looking?



Do you have a language of preference?



I'm using python right now and I've made significant progress. I managed to use the sso to obtain an access token and I've figured out how to refresh it after it expires. I've sent a few get requests to the auth crest for market buy orders but it's sending back a 'Bad Request' response(response 400). Can't seem to figure out why.

Got it working. Not sure what I was doing wrong but it's sending back the proper data now :)