temars-eve-api icon indicating copy to clipboard operation
temars-eve-api copied to clipboard

Published 20 hours ago • verified publisher icon barneycg

API System Screwed - Can't fetch Toons : *** api on holiday waiting an hour ***

Open richieknight opened this issue 10 years ago • 5 comments

Hey guys.

I'm currently having problems with running full checks in TEA 1.3.1 r7. I get the following error along with other similar errors..

API System Screwed - Can't fetch Toons : *** api on holiday waiting an hour *** ....

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 File: DRIVE:\PATH.................Sources\TEA.php Line: 2757

Also getting the following...

API System Screwed : bool(false) API System Screwed - Can't Fetch Titles : *** api on holiday waiting an hour ***

We're currently running an Alliance / Corp API key which has the required access.

Any help would be appreciated. :)

richieknight avatar Sep 26 '14 12:09 richieknight

Hi Guys.

Sorry to pester but I was hoping you may have some idea on what could be wrong?

richieknight avatar Sep 30 '14 11:09 richieknight

At a guess you don't have any API keys attached to a forum user account or you have a user that for some reason has an API key that is actually blank. Also keys shouldn't be a corp key and should include all the toons on the account.

barneycg avatar Sep 30 '14 12:09 barneycg

Thanks for your reply Barney.

All forum accounts have API keys attached. Isn't a corp key required in order to check against standings in the API settings page? Would a full character API key be required in the settings section of Temars Eve API instead and how would it know what toon to check standings against?

richieknight avatar Sep 30 '14 13:09 richieknight

ok ... yes ... that key should be a corp key sorry misunderstood, but that key has nothing to do with the errors you are seeing.

I missed one of the errors ... API System Screwed : bool(false) means your system is unable to fetch data from the API system.

the ones that say Toons and Titles mean exactly that ... this could be due to failure to communicate or it could be because the api key doesn't allow access. It could also be there is an error in some of the keys.

The DB error would seem to suggest that no api keys are being successfully processed hence a variable is not being set and thus is not available to be used in the SQL query.

Check you have the php curl libs installed.

barneycg avatar Sep 30 '14 13:09 barneycg

Thanks for the tips. We will take a look and see what we can do to resolve. I will post back here once we have sorted it.

richieknight avatar Sep 30 '14 14:09 richieknight