[ERROR] Api must be of Type Character and show ALL toons :)

API System Screwed - Can't fetch Toons : bool(false) API System Screwed - Can't Fetch Standings : bool(false) There is a problem fetching Standings : int(9999)

Eh, sorry to burst the bubble. I'm now experiencing an error when attempting to add an API key to an existing account:



I triple-checked to make sure the key was to show all characters, and even created an entirely new key to show all characters. But the error persists.

Thoughts?

Also, in checking the mod settings, this error appears at the top of the page:

My testing was done on our dev site, which apparently was not an exact mirror of our production site.

The only hiccup we experienced on the prod environment was that the mod may have wiped out the registration agreement that users must agree to before registering. The text is gone, but the user still has to click on "I accept the terms of the agreement". So they are basically agreeing to nothing. :P

It's not a big deal really. And we're not even sure if the TEA mod is what caused it. I wish I had more info for you but I have very limited access to our prod site. Getting the mod installed at all has been a ridiculously long process, simply because I have to keep lighting a fire under our admin's ass.

We only use the mod to grant forum access. TS access is handled manually since our community members play other games besides EVE. The Scheduled Tasks seem to be working as intended, though. Users input their API info and are granted appropriate access within a few minutes.

OK ... so all in all it does appear to be working on your prod site ? No error messages when you go to the Mod settings page for TEA ?

TEA "shouldn't" touch the registration agreement and it is certainly still present on both my production and dev forums.

G'day Guys,

I am getting the following 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 '' at line 1
File: D:\sites\owen1brunker\recursiveerror.com\home\Sources\TEA.php
Line: 2465

Does anyone have any ideas?

Thanks in advance

Cheers
OwenJ

Can I get a little more detail ... what were you doing when you got this error message ?
Have you upgraded from an earlier version or is this a new installation ?

I clicked the "Run Full Member Check Now" which is under "CHECKS" on the Temars Eve Api menu.

Background History

I didn't do the original install of SMF. The CEO of a corp, who recently left our alliance, was the person who did the original hosting, installation and forum maintenance. He gave me a copy of the database and forums. The Temars version number was a bit weird I think. 1.3.0.175. The version number of SMF was 2.0.4, which I patched to SMF 2.0.5.

It was with this environment that I was getting errors. I don't know if the errors existed before I patched. The first error which was reported by Temars was a database version mismatch. From my research I couldn't identify a database change between SMF 2.0.4 and SMF 2.0.5, so I changed the version number in the database. This is when the current message started happening.

I have, since my post for help, uploaded a vanilla SMF 2.0.5 as per the SMF manual and then deleted all package mods. I then uploaded and installed Temars Eve API Version 1.3.1 R2.

In running the same option, "Run Full Member Check Now", I still get the same error message but on a different line number. The error is the same error within the same PHP function Settings_checks($scripturl) and it occurs when doing an SQL SELECT via a call to $this -> smcFunc['db_query'].

I can't fault the SQL statement. A similar SQL statement runs perfectly in the MySQL query tool. I say similar because I manually resolved the {db_prefix} macro in my test. It should resolve to ''. I suspect this is where the problem might be. The forums themselves are working so I cant see the null value used for db_prefix being an issue.

I hope this fills you in.

Thanks again.

OwenJ

Edit : Not sure how comfy you are making some changes ... can you try changing TEA.php ?

on line 1367 it should say :
$lastid = 0;

can you add directly below that line the following :

$this -> lastid = 0;

It a long shot but the SQL query you list uses $this -> lastid and it is possible that this variable isn't set if you have only a very few api keys in your db.

The website encountered an error while retrieving http://blackwatchsyndicate.com/forum/index.php?action=admin;area=tea;sa=rules;e217bb3d5bd=86af0d286d8f40f9e887b6d834beac86. It may be down for maintenance or configured incorrectly.
Reload this webpage.
Press the reload button to resubmit the data needed to load the page.
Error code: 500

Fresh install of both SMF2 and TEA. So far, everything seems to be going smoothly until I try to add a rule and get the following:



Everything else works fine, but, it seems to think that the server goes down while I'm trying to submit the rule. Everything else on the server functions just fine, and this only occurs when I'm trying to set a rule.

Browser is Chrome; Same error occurs with testing in IE.
Server is running Debian Linux x64, Apache2, PHP5

Any ideas?

[ERROR] Api must be of Type Character and show ALL toons :)

i clear my smf_tea_cache but have this msg again. api is correct

Can you get the error out of your apache error logs please ... this doesn't happen for me either on my "production" forums or the one I use for testing.

[Tue Sep 24 19:51:06 2013] [error] [client 205.250.184.170] PHP Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/www/forum/Sources/TEA.php:1981\nStack trace:\n#0 /home/www/forum/Sources/TEA.php(1981): SimpleXMLElement->__construct('')\n#1 /home/www/forum/Sources/TEA.php(1630): TEA->settings_rules('http://blackwat...')\n#2 /home/www/forum/Sources/TEA.php(3417): TEA->Settings('http://blackwat...')\n#3 /home/www/forum/Sources/Admin.php(519): ModifyTEASettings()\n#4 [internal function]: AdminMain()\n#5 /home/www/forum/index.php(151): call_user_func('AdminMain')\n#6 {main}\n thrown in /home/www/forum/Sources/TEA.php on line 1981, referer: http://blackwatchsyndicate.com/forum/index.php?action=admin;area=tea;sa=rules;save

Edit 2: Fundamentally though the problem is because you are not getting back XML from the API servers. Trouble is the TEA code isn't handling that very well.

That tells me WHAT the problem is, but, I have no idea how to fix it.

It also fails to accept my own API key.

try{
$xml = new SimpleXMLElement($xml);
}
catch(Exception $e)
{
var_dump($xml);
var_dump($e);
die;
}

This is not a fix ... the code will stop rather than give the error 500 but it will print some info that I need to see in order to tell what you are getting instead of expected XML

bool(false) object(Exception)#6 (7) { ["message":protected]=> string(33) "String could not be parsed as XML" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(31) "/home/www/forum/Sources/TEA.php" ["line":protected]=> int(1982) ["trace":"Exception":private]=> array(6) { [0]=> array(6) { ["file"]=> string(31) "/home/www/forum/Sources/TEA.php" ["line"]=> int(1982) ["function"]=> string(11) "__construct" ["class"]=> string(16) "SimpleXMLElement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(0) "" } } [1]=> array(6) { ["file"]=> string(31) "/home/www/forum/Sources/TEA.php" ["line"]=> int(1630) ["function"]=> string(14) "settings_rules" ["class"]=> string(3) "TEA" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(46) "http://blackwatchsyndicate.com/forum/index.php" } } [2]=> array(6) { ["file"]=> string(31) "/home/www/forum/Sources/TEA.php" ["line"]=> int(3425) ["function"]=> string(8) "Settings" ["class"]=> string(3) "TEA" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(46) "http://blackwatchsyndicate.com/forum/index.php" } } [3]=> array(4) { ["file"]=> string(33) "/home/www/forum/Sources/Admin.php" ["line"]=> int(519) ["function"]=> string(17) "ModifyTEASettings" ["args"]=> array(0) { } } [4]=> array(2) { ["function"]=> string(9) "AdminMain" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(25) "/home/www/forum/index.php" ["line"]=> int(151) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) { [0]=> &string(9) "AdminMain" } } } ["previous":"Exception":private]=> NULL }

curl_close($ch);

Return $data;

curl_close($ch);
var_dump($data);die;
Return $data;

Again this is just more debug. Tell me what the result is. Depending on your browser and what is returned you may well need to view the page source to get the full content of what is returned.

bool(false)

All it returned was this:



That's even with looking at the page source.

And no, no other API related functions work.

An idea popped into my head. This server is freshly setup, I've never run anything else off of it. Is it possible that I missed a base pre-req? I can't think of anything that I missed... I got Apache2, PHP5, MySQL, curl, php5-mysql... I can't think of anything else that might be needed, but, did I possibly overlook something?

EDIT: when I try to add my own API key for checking, it gives me this error: [ERROR] Api must be of Type Character and show ALL toons :)

I've seen that before on here, so, I'll see if any of those fixes work for this.

EDIT2: Nope, no changes. I'll await your response.

You are missing php5-curl ... BUT the code "should" warn you of this. If it isn't then we have another bug :)

I've checked and it appears to be installed. On the possibility that there was something wrong with it, I removed it and reinstalled it and the same problem is occuring.

Any other pre-reqs that might be missing?

Pings go through just fine. I tried telnet, but that failed. I would not be surprised if they have telnet blocked. How else might I test?

Telnet to port 443?

Thanks. This worked flawlessly.

So yes, I can contact the server without issue.

So you can connect to the api servers manually, you have php-curl installed but when it tries to make an API call you get nothing not even an error.

Silly clutch at straw here ... you do have https://api.eveonline.com set in the server field at the bottom of the Tea setting page ?

Sweet ... Glad that fixed it coz I was out of ideas :)

A minor thing: On the modify profile > jabber tab page, the jabber account is not created until I go through the process of selecting an alt character > change profile > selected main character > add password > change profile.

Is this a problem you're aware of or do I just have a borked layout or something?

Hmm ... not aware of that one ... when you say select alt character where are you selecting this.

Just as a note the Jabber account setup is a completely seperate step so you register/add api to your forum account (you have to save your profile if you are adding an api) that then go to the jabber page and select a toon and set a password and save that.

Thanks for replying so quickly.



That's exactly the tab page I am talking about.

Under the Profile menu item, select TEMAR's Eve Api
Go to the Jabber tab page

If I select my main char, enter a password and save it (by clicking change profile), the jabber account isn't created. No messages other than your profile is updated. I thought for a while my settings were bad or something until I tried selecting an alt char and saving, and then selecting my main again and saving again, then noticed the jabber account was created.. I deleted the account on jabber and tried again. Same thing. I tested it a few more times and same thing every time. I am not sure why that is exactly.

If you can give a hint about which file the jabber form is in perhaps I can go in and look at the code and see what the problem might be.

Also, do you know of any plugins available for SMF that support eve fittings and other in game browser functions? I had a search around and the only ones I could find seem to be abandoned. In my opinion this is the only area in which SMF doesn't surpass phpBB as a forum for Eve alliances.

I can't replicate that behaviour at all.

I had a test account with no API key.
Added key and hit save.
Selected main character and hit save.
Went to Jabber page (main toon was already selected) added password and hit save ... look on jabber server and the account is there.

All the Jabber stuff is in TEA_Jabber.php and TEA_Jabber_OF.php ( _OF is the utility functions most of which are unused :) )

As for the rest of it no I don't know of any fittings/IGB functions. What exactly are you looking for in terms of IGB functions ?

Acutally, another question. Does the TS integration work if the TS server is NOT using a mysql db? I am connecting to the server fine as I am seeing all ts groups. Only rule is to add forum group to corresponding ts group and when clicking register I keep getting "[ERROR] Unknown Unknown method"

I'd posted this in error in the 1.2.1 forum topic so I'm just cross posting this question here as I'm using the 1.3.0 R179 version of TEA.

I'm having some trouble with the Skills rule set. I was trying to use them to assign a secondary group of Capital Pilots, but when i use something simple such as 'Amarr Carrier' with a skill level requirement of 4 it doesn't assign the group to anyone. I did have a Corp ID AND attached but was struggling with it working so lowered to just 1 skill to test.

Is there a particular syntax for inputting the skill names? How can I debug why it isn't matching? I've tried Skill ID's and the Names, nothing seems to work.

I should say i've managed to assign secondary groups using corp titles and roles successfully. Just can't seem to get the skills correct.

Edit - I've updated to 1.3.1 r4

Still unable to use the Skills correctly, getting the same results as above.

Yep I've tested this on my boards and I'm seeing the same issue along with some errors in the board error log about undefined variables ... I'll need to investigate :)

This is a heads up for Windows Servers.

If you have issues pulling the API (Empty chars) it can be your server SSL cert which has exspired. curl will not Work if this is the case.

Eh ? You don't need a cert on your server to connect to the CCP api url ... or am I mistaking what you mean ?

edit ... do you mean the CA cert ?

http://thefuriousangels.com/index.php?topic=7580.msg126587;topicseen
Undefined variable: reds
File: /home/angels/domains/thefuriousangels.com/public_html/Sources/TEAC.php
Line: 267

http://thefuriousangels.com/index.php?topic=7580.msg126587;topicseen
Invalid argument supplied for foreach()
File: /home/angels/domains/thefuriousangels.com/public_html/Sources/TEA.php
Line: 276

Ya CA Cert

You need a selfsigned cert with the curl calls you are making, thats why i had so many issues with your version. You can turn it off in the calls (Dont have code in head) so after editing your code, you version worked fine.

http://www.devcha.com/2009/10/how-to-execute-curl-and-skip.html
http://curl.haxx.se/docs/sslcerts.html

ok mate, first great work your doing here.

I got it to install by uninstalling the old one first.


it all seems to be working.


So how do i set it so it needs a full api key ?

Hey,

Getting errors on this Package.

Nothing seems to be working lol. Its not pulling any API's

I can ping the api server.

I have:

XAMPP on a Windows 2k8 server.
SMF 2.0.6
Temars EVE API 1.3.1 r4
Curl appears to be enabled in php.ini

I don't think it is pulling the API properly.

API Page

DB Error

Screwed Error

Hey,

Getting errors on this Package.

Nothing seems to be working lol. Its not pulling any API's

I can ping the api server.

I have:

XAMPP on a Windows 2k8 server.
SMF 2.0.6
Temars EVE API 1.3.1 r4
Curl appears to be enabled in php.ini

I don't think it is pulling the API properly.

API Page

DB Error

Screwed Error

Alright, everything seems to working like a champ except for this one odd detail, when we have used go to their profile and try and use the eve avatar, it will pull up the right pic for whichever toon they select, but when they save it, we end up with just the broken pic image. this happens regardless of whatever size we set the avatar size to.

Thought? Something silly I am overlooking?

(Thanks for your time on this epic mod!)

I'm not sure if this have been covered in a previous thread or not, there was a little too much to read through. My corp has friends that are in NPC corps, the individuals are set light blue at the corporation, but are not being placed in the Blues group. Will TEA not work with individual character standings?

I've not had this issue but that sounds more like a smf path/permissions problem to me rather than something specific to smf ... when you right click on the broken link image what is the path/filename ? You'll need to dig in there and see if the folder permissions are correct or if the path is even correct.

I don't think it was covered before ... I know I've not looked at that section of code ... it appears to only look at at the toons Alliance and Corp and compares that to the standings fetched from the master api key.

any chance to add mumble support to this mod in the future?

Ok, so players in NPC corps have to be manually added to a group. Fair enough.

New question. it seems that if someone botches up their API key and tries to register with it, then gets a error, and tries to register again with the corrected key they get an error that the character already exists and I have to clear them out of the table. Do I have something setup wrong?

ok...after doing some digging, what it looks like it's doing is not appending the size.jpg to the character ID it's pulling from the API mod. So when I inspect the avatar element, it looks like:

https://image.eveonline.com/Character/1088364566

instead of:

https://image.eveonline.com/Character/1088364566_128.jpg

If I fix the HTML manually on the page, it pulls the right pic down.

Any more thoughts on why this would be? I set the entire board to 777 while testing, so I don't think it's permission issue...and it's got the right path, just not adding in the missing section to the end (which I think would be done by the mod, since you can set the size of the avatars you want used in the Temar API settings...it's just not actually doing it).

Having a hard time getting Jabber integration to work. Can you help? Not sure what I'm missing.

I have everything plugged into the Jabber section and enabled it however I see 0 traffic in the MySQL logs being generated from the mod. If I try to register a user I just get unable to match any groups but still no log entries.

I'm sure I'm missing something dumb?

Ok, so that's what it was. I just put it on a VPS and it works as expected.

Next question, Trying to setup TS3. I get Unknown Method when I try and register? I see all the groups when I plugged in the query login info.

We had to have member log into TS with the username given to them on the TeamSpeak section of the TEA plugin...and then when they hit register it instantly gave them the right roles on TS. If they weren't logged into TS, we got the same message you did.

[quote=1Gordon Gekko1][quote=Magenta Flori]
It also seems that if I manually remove the corp list and standing files and re-run TEA_Cron.php I get an updated list and new files. I guess this is by design and I can just make a cron job around it.

Sweet, thanks for the great work. It is supposed to give any details when you run it? Most of them give nothing but a prompt. Tea_Cron.php gives that reset id to zero or whatever message?

interesting ... where are you seeing this url ? When I look at a profile and inspect the element of the Avatar it is a url in my forum not in image.eveonline.com


Sorry I missed this :



That is about what is happening ... it fetches image from image.eveonline.com and then it should save it to either your attachments folder or your avatar folder depending on how you have things configured.

Hi,

I have a problem with your plugin for SMF... It seems that temars don't synchronize the database for openfire and so don't create the users... Can you help me about that?

I would'nt ask for help if there were enough doc of course but since there is none....

Seems that is not the solution to my problem.
the groups are visible in SMF, the user service is correctly configured because we can create new user with the URL : for example :
hostname:port/plugins/userService/userservice?type=add&secret=passexample&username=testalamain&password=test&name=MonsieurTest&[email protected]&groups=Camarade


Am I missing something here?

the rules you mean in SMF? if it's that, yeah it's activated.

the allowed ip's are blank and in mode 'accept' so normally it will accept all the connections no?

how is transfered the request to userservice?

It's just a curl call. Is SMF and Openfire on the same box ?

Try doing a packet trace on the Openfire Box and seing if you are seeing the user service being hit.

Have you a user that has gone to index.php?action=profile;area=tea;sa=jabber and selected a user and a password ? ... unless they do that no user will be created.

Only other thing I can suggest is you give me some logon details and I'll take a quick look.

Just installed SMF2.0.6 and TEA 1.3.1 r4 and have had some issues.. I've worked through some, but, a couple I cannot get by without some help.

- SMF wouldn't accept the zip file of the mod via the upload built in.. I had to ftp it up, and then unzip it in the /Packages directory. This allowed it to install from inside SMF. I also needed to copy the TS3_Class/ dir by hand to /Sources

- Not sure what API to use for our Alliance in the main config of TEA.

- Base Admin account loses admin privs.. because it has no API. Probably by cron check. a reset php script fixes this temporarily.

- Users cannot register because of the "select a character" requirement, even with "Is a Valid Api required to Register? " set to disabled/no. if you enter a single character or false API, it will tell you in the error message, a proper one will tell you to select a character.

The API function -IS- working, just the fetch characters button is doing nothing. For the admin account, I tested adding an API without selecting a character, and saving it, then opening it again and was able to select a character without a problem.
...
Also changed the API server to: http://community.eveonline.com/support/api-key/ since the other links were https, and, double redirected to this URL. an https link may also be fine, but, I was reading about prople having trouble with curl and ssl. Testing curl by hand revealed the redirects to me, actually. The fetch button didn't work with any of the urls used, but the test on the admin account worked fine with this one.

Thanks for any help you can give.

Just an FYI:

I think CCP recently changed the "403 - Forbidden" messages to more specific error messages; I got php errors when trying to validate empty or invalid keyIDs and vcodes. I managed to fix some of them by changing the "403 - Forbidden" arguments to their specific counterparts in TEAC.php

Any way to make it not accept people with an incorrect access mask? I have seen it take an API, only show one char, say incorrect mask in SMF/Tea but still gives them access.

Hi there,

First off, awesome package I've managed to hook up SMF auth and openfire without too much trouble yesterday. I have one question though:

In my rules for forum groups I have added one main rule defining that if you are in corp u go to a certain group.

However this doesnt seem to work

Rules on additional groups DO work however.

This is the only rule i have set up in main groups :


ID 3 RULE IS => Corp: 883901493 (Imperial Collective) groupname AND (enable flag checked)

In my case, additional rules throw me in the director group no problem, but main stays 'not monitored'

Hope someone can assist.

Hi,

i have installed today the TEA v1.3.1 r4 now when i try to register an new user with the api i have some problems....

when i fill in the api and i use "Get Characters" nothing happen?!

any idea?!

Sorry I'm going to need little more. What OS are you running on ? Any kind of errors being displayed ? Have you entered a master api key ?

Hi,

i work on smf 2.0.6 and i have no errors nothing.... and yes i have as well tryed a master api key but nothing happens when i get on "get characters" when i try to register without get character i get the message "A Valid API is Required to Register on this Forum" but i have tried a master api key as well ?!!?!

So you do get an error message :) - A Valid API is Required to Register on this Forum.

This means that your system is not fetching a character list from your api ... either it isn't allowed to coz your api key is wrong/expired or your system is not able to fetch anything ... you didn't say what OS you are using ... if it is Windows then you will need to turn off SSL Peer checking ... there is a post somewhere in this thread that says how.

Windows and apachi....

and i geht this message now

API System Screwed - Can't Fetch Standings : bool(false) There is a problem fetching Standings : int(9999)

Would it be possible to allow users in a specific SMF usergroup to register TS and Jabber accounts?

Ideally I would like to give a specific group access to TS and Jabber, without the need for an API key. People that stopped playing Eve or friends from other games for example, that still would like to hang out on the same TS and Jabber servers.

They have an incorrect mask but it still matches them to a group because they have "enough" access via the API even though it is not the "correct" mask. Is there a way to force it to be the exact access mask or have their account removed with the dbcleanup? It is supposed to do this now?

Is there an easy way to just remove everyone with invalid apis?

Hiya,

Running SMF 2.0.6
Teamod 1.3.1 r5

I'm having two issues.

- It happens if I set a a rule "ISNT Corp" for our corporation at first rule positon, any members that have alts on the same account but in different corp (either NPC or not) will get matched to that rule and assigned the corresponding group.
In our case that will be guest access, but being corp member with at least 1 toon they should be granted member access.

- On the API mask check.
I found 2 members using an invalid mask, but with the minimal required fields.
I can see the red error message stating BOTH api id's when I check any of our members API after a full check.

[ERROR] Check your Access Mask - keyid = masked ;)

I have an issue. When a user registers for jabber via temars, it reads as though it was successful on the forum-side, and it populates the prefix_tea_jabber_users table, however, it doesn't actually create a user on the Openfire server.

When I use the user service link manually to try and create a user, it works perfectly, but via temars it's not actually creating the user, even though it 'thinks' it is....

any thoughts as to what could be causing this?

Also Temars is talking to the Openfire server just fine as the groups are available to map via rules....so I can't figure out what's going on...

Shin, thanks for the quick response. I do have group mappings set and there are users in them on the SMF side. I do have two members that I manually created on jabber as well via the user service link (directly into browser), and that worked fine.

The IP security is empty. I've tried it with the IP of the box that SMF is on (different than jabber) and tried it without an IP. Even with members in mapped groups on both ends, trying to authorize a new user on jabber gives me a "successful" message on the SMF side, but no member created within OpenFire....

Hi Shin,

Running SMF 2.0.6
Teamod 1.3.1 r5

I found eventhough I have "Is a Valid Api required to Register?" checked, users can register to our forum without any API filled.
Anyway I can fix this?

Are skill rules still broke?

I've tried to telnet to api.eveonline.com 443 and get no response -- i've disabled the windows firewall and still no joy; so I'm stumped.

It would seem to me you need to get basic connectivity to CCP's API server first. As to how to do that if it isn't the Windows Firewall ... I'm afraid I can't help.

Thanks for the reply. I'll dive into it tonight and see what I can figure out. Was getting late last night and I was getting desperate haha; figured I'd see if anyone had had the same issue after going to r5.

IF anyone has experience with 2008 R2 and knows why I'm not getting outbound 443 connections, please share.
(I can't remember if I verified that https:// browsing is functional; although I seem to recall it as working in the past - will verify that 100% tonight)

I hate to say "it works for me" but .... It works correctly for me ...

So I have to ask :

is there any info in the logs (either SMF's or Apache's) ?
And the obligatory ... Are you 100% sure the option is set ?
Have you tried unchecking the box saving then checking the box again and resaving ?

Follow up: telnet api.eveonline.com 443 is successful (get a blinky cursor until anything is pressed then I get a connection lost message).

Error displayed at the top of the settings page where you enter the API key: API call error while fetching standings: Error Code = 221 for key id = 1976416 API call error while fetching standings: Error Code =

I am running r4 but change notes didn't say anything about rules with r5, should I try r5? Any gotcha I need to know before upgrading? What is the best way for upgrading, uninstalling and just installing the new?

ok so I upgraded...

getting a lot of these when I run a full member check


API call error while fetching roles: Error Code = 221 for key id = API call error while fetching roles: Error Code = 221 for key id =

Update:

All those errors were occurring on some, not all, accounts that invalid API's. Also the table would show the character name but no details on those accounts when running the member check. I simply removed all those API's and now the error does not occur anymore and they are given No API when the check is ran. So I guess its working, not sure what happened there.

Also skill rules are working now.

Hi Shin,

Cant find any specific errors in either apache or smf, where is this setting supposed to be stored?

Doublechecked, the checkmark is there and also did try the off,save,on,save trick.
Without any result.

Out of curiosity Naella do you have the EFTMod installed? (the one which adds in a EFT BB code to display fittings nicely). I have noticed my cron jobs aren't running and I think it is due to this (havn't had time to test yet).

When you say they don't need a valid api even though the option is ticked do you mean they are entering an api key that doesn't have the right options ticked or that they are not entering an api key at all ?

Not entering one at all. Just go to our forums to test (www.avalonproject.co.uk/forums).

Not entering one at all. Just go to our forums to test (www.avalonproject.co.uk/forums).

Doh ... found the problem ... I thought I'd tested with no api key but it looks like I just tested with duff ones.

Change line 3295 to read :

if ((empty($chars)) || (gettype($chars) == 'integer'))

and that "should" fix it.

as it says it can't get the standings ... the reason looks to be coz the master API key you've entered doesn't allow standings to be fetched. You need to use a corp key.

First of all Shin, thanks for taking this on. I go back to ESAM with a former alliance and have always preferred SMF and this mod, thanks for updating it!

I'm having a whale of a time with TS3 integration though. Am I to understand it the mod will not work unless you have database access on the server? Our comms are hosted by Lightspeed Gaming so not sure if that would be possible for us or not. I put all the info on for the ServerQuery login but nothing seems to take.

If anyone else has TS3 integration set up and can provide any tips would appreciate it.

--Rax

Ok got a new one I'm stuck on. Got an ex member, left 8 days ago. Confirmed his API key really shows him as gone yet SMF still shows him as in corp. He has no alts in corp/alliance or any alt that matches any rules with the API key that is provided on his account. I even run full member check manually and it still shows him as in corp/alliance. I try to run php TEA_Cron.php debug but it does not give me anything at all to work with. Not sure how to troubleshoot.

Ok got the debug output sorted. I'm assuming the first number is the user of smf. Main is the main rule and the additional are the other rules. My rule 16 is an alliance rule and the other rule 10 is a corp rule. So it clearly thinks this user is still in alliance/corp? I'm baffled.


[246]=>
array(2) {
["main"]=>
string(2) "16"
["additional"]=>
array(1) {
[0]=>
string(2) "10"
}
}

I even removed his API and re-added it. The same API that I can check with evemon and it shows him as in the NPC corp. After I re-added it, it still put him right back into alliance in SMF.

If I create a rule for the npc corp he is in, it sees it and applies the npc corp rule. When I remove that rule, it puts him right back in Alliance. I do have a neut rule before the alliance rule in case it was looking at history for some reason. Did not matter, still says in Alliance.

https://api.eveonline.com/account/Characters.xml.aspx also shows both characters with this API as in NPC corps.


Spent about 4-5 hours trying to sort this out. I'm stumped.

UPDATE: I discovered that the smf_tea_cache table was not updating, even when removing and re-adding this users API. So I backed up my DB and truncated that table. Welp, that fixed it. Next time I put the key in and ran full member check it pulled new data from api.eveonline.com. So I guess the question is did I have DB corruption? Why was it pulling from this cache and not updating it? Should I do a cron job to wipe this table out daily? I also have noticed that the full member check was running super fast. Now it is back to running slow with about 10 per page or so. Instead of 100 per page.

K, how often when I run full member check should it be slow and actually check every API instead of using the cache? Been another hour or so and its still super fast and runs through a few hundred in a couple seconds.

What's the in-game character associated with the lead developer on this project now? According to the GitHub commits, "barneycg" seems to have the most development activity. I'd like to send an ISK donation to you in-game. Is that you, Shin Chogan?

I love this middleware app and want to support future development and maintenance updates. Thanks for your contributions to this project. For any other alliance IT guys, I highly suggest sending ISK to this man to encourage continued development on this. It brings massive value and one good turn deserves another.

Ok so yeah that works. Not to sure what happened there. Have you tried TEA with SMF 2.07 yet?

I've had one of the directors give me a new full corp key (the previous one was "shared")... still getting the same error :(

I'm running TEA with SMF 2.0.7 ; it works like a charm ;)

With TS and Jabber on a separate server I'm starting to get somewhere but running into problems.

The TS script is giving me Undefined index errors for tea_charid, tea_userid and tea_api at lines 86, 87 and 88 in TEA_TS.php-- do I have something misconfigured somewhere?

Jabber integration is seeing the server, can't seem to create any users at this point, working on it still.

--Rax

Oh farnsworth !!!! ... fsking TS code ... never touched it ... don't use TS ... comes back and bites me in the fsking arse.

Looks like Temar never actually updated the TS code in line with the rest of the code for the CAK keys. it is using old db values that don't exist anymore !!!

You should be able to safely ignore those errors ... that chunk of code doesn't actually do anything useful anyway it looks like it was copy pasted from another chunk of code and even though these bits aren't used in this function Temar left them in.

*sigh*

We are having trouble getting the Director rule to work properly.
The additional group rule is set as follows:

(ID) 19
IS => Alliance: 99003478 (The Harlequin's)
IS => Role: Director
(Group) Director
AND

It would seem that even though both conditions are in the same rule, it is still looking at all characters on the API instead of just one, causing characters with Director roles in other corps/alliances to be counted.

Anything we're missing?

I've not noticed this on our boards but ...

Is this a Main rule or a Secondary rule ?

im having trouble with the rules section. people not in my alliance are able to sign up and see everything. people in my allliance are able to sign up and see onlly what i want them to see. i tried to set up a rule where neut/red/ no standing get put into a "spy" group where they cant see or do anything but it doesnt seem to be putting them into the group. any tips?

Please, what is your command line to set TEA CRON on cpanel ?

My settings in cpanel : php /home/..../Packages/TEA_1_3_1/TEA/TEA_Cron.php
644 for the file access right
755 for the folder

Error 500...

I have a very simple .htaccess file with "allow from all, satisfy any".

Have tried different access rights for the file tea cron, a test named for htaccess file... Don't have the solution at this time.

Thx for your help.

API call error while fetching toons: Error Code = 106 for key id = [ERROR] Connection timed out

Still have this error. I can't see any proposition on TS GROUP on TS rules panel ...

API call error while fetching toons: Error Code = 106 for key id = [ERROR] connection failed, you are banned (you may retry in 557 seconds )

Hi all,

A very strange error has just started happening on my forums, the mod has been running successfully for months without any issues then since yesterday whenever I try to update someones tea profile setting i get a page not found error when I click the change profile button.

Also when trying to look at the settings page of the Tea mod I get the following error:

MySQL server has gone away
File: /Sources/TEA.php
Line: 1413

I have run a database tables check and repair through cpanel, checked the error logs of the forum (nothing found), uninstalled deleted the files and reinstalled the mod and contacted my host to ask them if anything has changed.

Now I am at a bit of a loss, as this has just started happening recently I just wondered if anyone had any ideas what I could do.

Thanks a lot for any tips help..... its a great mod.

Regards,

Nori.

Hmmm very strange indeed ... that error could be caused by a timeout or maybe a limit on the number of open connections you can have to the DB being reached. It could also be that something else is closing the connection to the DB for some reason before you are able to make the call to the TEA cache table ... which is what is happening on the line you mention.

I tried clearing out the smf_tea_cache table also contacted my host to restore the database and website, tried everthing I can think of. Contacted my hosting company again they said that something with the query is taking ages to execute at index.php?action=admin;area=tea;sa=settings; but just dont know what else I can try

The only pages where I get the error are the settings page and running the actual checks :/ all the other pages load up fine. Could there be something in one of tables which the settings page calls up which is corrupt? or any weird permissions problem with the files.. I think all the files that should be 0644 are.

When I try to run the checks I get the following messages:

API System Screwed : bool(false)

and

MySQL server has gone away
File: /Sources/TEA.php
Line: 2408