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.
 

TEA (v1.2.1) - Member Management Mod for SMF 2, TeamSpeak 3 and Jabber

First post
Author
Previous Topic Next Topic
Jognu
French Kiss Singularity
#321 - 2013-01-22 10:27:30 UTC
I try, and I receive a lot of :
Quote:
No database selectedError: Database modifications failed!


Maybe no link with the problem but : this mod works with postgresql ?

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Shin Chogan
Federal Navy Academy
Gallente Federation
#322 - 2013-01-22 10:40:08 UTC
Jognu wrote:
I try, and I receive a lot of :
Quote:
No database selectedError: Database modifications failed!


Maybe no link with the problem but : this mod works with postgresql ?



Ah ... there doesn't appear to be any mention of a db requirement in the original docs BUT .... The code uses mysql_query calls which would lead me to conclude that it DOESN'T work with postgresql.
Jognu
French Kiss Singularity
#323 - 2013-01-22 10:42:12 UTC
Shin Chogan wrote:
Jognu wrote:
I try, and I receive a lot of :
Quote:
No database selectedError: Database modifications failed!


Maybe no link with the problem but : this mod works with postgresql ?



Ah ... there doesn't appear to be any mention of a db requirement in the original docs BUT .... The code uses mysql_query calls which would lead me to conclude that it DOESN'T work with postgresql.

Yes, I came to the same conclusion.
I'll maybe take a look to see if it's easy or not to make it compatible with postgresql.

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Troy Aihaken
Quekz
#324 - 2013-01-22 14:03:31 UTC
Hey guys,
This time i come to you for help. Ive been looking at the code but im still baffuled.
When i click run full members check i get this eroor:

Incorrect integer value: 'no error code' for column 'errorid' at row 1

Any suggestions?

NodeJS Developer | Frontend Development | Programming Enthusiast
Shin Chogan
Federal Navy Academy
Gallente Federation
#325 - 2013-01-22 14:22:09 UTC  |  Edited by: Shin Chogan
Troy Aihaken wrote:
Hey guys,
This time i come to you for help. Ive been looking at the code but im still baffuled.
When i click run full members check i get this eroor:

Incorrect integer value: 'no error code' for column 'errorid' at row 1

Any suggestions?



anything showing in your apache error.log ... any more info regarding which file and line this shows up in ?

There looks to be 5 places in TEA.php where the column errorid shows up.

Edit ... interesting in that errorid should be an integer and the code has ' round the number - one of them is my fault, but I just copied what was already there.

Looking at that error I'm thinking it is either line 311 :
Quote:

$this -> query("UPDATE {db_prefix}tea_api SET status = 'API Error', errorid = '".$error[0]."', error = '".$error[1]."', status_change = ".time()." WHERE ID_MEMBER = ".$id." AND userid = ".$apiuser);


or 349 :

Quote:

$this -> query("UPDATE {db_prefix}tea_api SET status = 'API Error', errorid = '".$error[0]."', error = '".$error[1]."', status_change = ".time()." WHERE ID_MEMBER = ".$id." AND userid = ".$apiuser);


in each case the code does a get_error which returns the values "no error code" and "no error message" and puts them into the $error array. I'm guessing it is just another symptom of CCP's servers sometimes returning these application errors.
Impudent Dragon
Native Freshfood
Minmatar Republic
#326 - 2013-01-24 12:05:50 UTC
What is the working version of TEA? Today have problems with "check all" function.....
Jognu
French Kiss Singularity
#327 - 2013-01-24 12:37:15 UTC
I switched from postgresql to MySQL, it works great !

I have a request : could you add the ability to register an account without the need of fill the API ?
I didn't tick the "Is a Valid Api required to Register?", but when I try to register I have the error : "The API needs to show All characters on the account" (the ID and the verification code are blank and I didn't click the "Get Characters" button).

Thanks !

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Nutbolt
University of Caille
Gallente Federation
#328 - 2013-01-24 13:27:43 UTC
On the subject of requests/suggestions: The link to the EVE API pages should really open up in a new tab, not in the same tab, as that's just silly :)

Join Avalon Project Today!
Shin Chogan
Federal Navy Academy
Gallente Federation
#329 - 2013-01-24 13:38:07 UTC
Nutbolt wrote:
On the subject of requests/suggestions: The link to the EVE API pages should really open up in a new tab, not in the same tab, as that's just silly :)


Are you talking about the link at the bottom on the Profile pages ? or during registration ?
if the former then the version I posted "should" do that ... at least it does it for me ... there is a target="_blank" in the href.
Nutbolt
University of Caille
Gallente Federation
#330 - 2013-01-24 13:48:29 UTC
Shin Chogan wrote:
Are you talking about the link at the bottom on the Profile pages ? or during registration ?
if the former then the version I posted "should" do that ... at least it does it for me ... there is a target="_blank" in the href.


In both its not doing it, and I have the most recent version from a few posts up. Odd. I know I can edit the files myself, just suggesting its added for both pages in the 'official' release as I have had a few corpies complaining about it lol.

Join Avalon Project Today!
Shin Chogan
Federal Navy Academy
Gallente Federation
#331 - 2013-01-24 13:52:53 UTC
Nutbolt wrote:
Shin Chogan wrote:
Are you talking about the link at the bottom on the Profile pages ? or during registration ?
if the former then the version I posted "should" do that ... at least it does it for me ... there is a target="_blank" in the href.


In both its not doing it, and I have the most recent version from a few posts up. Odd. I know I can edit the files myself, just suggesting its added for both pages in the 'official' release as I have had a few corpies complaining about it lol.


In the version I posted a few days ago both the links have the requisite html in to open that link in a new tab.
Jognu
French Kiss Singularity
#332 - 2013-01-24 13:52:54 UTC
Shin Chogan wrote:
Nutbolt wrote:
On the subject of requests/suggestions: The link to the EVE API pages should really open up in a new tab, not in the same tab, as that's just silly :)


Are you talking about the link at the bottom on the Profile pages ? or during registration ?
if the former then the version I posted "should" do that ... at least it does it for me ... there is a target="_blank" in the href.

The link CharacterInfo, CharacterSheet, FacWarStats open a new tab, but not the two links https://support.eveonline.com/api/Key.

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Shin Chogan
Federal Navy Academy
Gallente Federation
#333 - 2013-01-24 13:55:50 UTC
Jognu wrote:
I switched from postgresql to MySQL, it works great !

I have a request : could you add the ability to register an account without the need of fill the API ?
I didn't tick the "Is a Valid Api required to Register?", but when I try to register I have the error : "The API needs to show All characters on the account" (the ID and the verification code are blank and I didn't click the "Get Characters" button).

Thanks !


I'll look at that soonish ... I added the check for an account type key to try prevent people having toons in red corps on the same account ... no need to make it easy for them :) I didn't even think that people would want to allow registration without an api.
Shin Chogan
Federal Navy Academy
Gallente Federation
#334 - 2013-01-24 15:06:53 UTC  |  Edited by: Shin Chogan
Jognu wrote:
Shin Chogan wrote:
Nutbolt wrote:
On the subject of requests/suggestions: The link to the EVE API pages should really open up in a new tab, not in the same tab, as that's just silly :)


Are you talking about the link at the bottom on the Profile pages ? or during registration ?
if the former then the version I posted "should" do that ... at least it does it for me ... there is a target="_blank" in the href.

The link CharacterInfo, CharacterSheet, FacWarStats open a new tab, but not the two links https://support.eveonline.com/api/Key.



Ah ... ha ... those would be the ones the original dev put in ... I turned the required options bit at the bottom into a link :)

I've updated the file with both fixes and updated the google drive file.

You will need to install again for the registration fix or look at mod_register.xml and modify Sources/Register.php appropriately :)
Nutbolt
University of Caille
Gallente Federation
#335 - 2013-01-24 15:25:53 UTC
Shin Chogan wrote:

Ah ... ha ... those would be the ones the original dev put in ... I turned the required options bit at the bottom into a link :)

I've updated the file with both fixes and updated the google drive file.

You will need to install again for the registration fix or look at mod_register.xml and modify Sources/Register.php appropriately :)


Now you've made the changes lol, may I suggest the links be changed to the one which creates a key with the correct mask. busy atm, but something like apiurl.com/createpredefined/58293498 (use correct mask). Makes registering that much easier and takes them straight to the create api page.

Join Avalon Project Today!
Shin Chogan
Federal Navy Academy
Gallente Federation
#336 - 2013-01-24 15:50:06 UTC
Nutbolt wrote:
Shin Chogan wrote:

Ah ... ha ... those would be the ones the original dev put in ... I turned the required options bit at the bottom into a link :)

I've updated the file with both fixes and updated the google drive file.

You will need to install again for the registration fix or look at mod_register.xml and modify Sources/Register.php appropriately :)


Now you've made the changes lol, may I suggest the links be changed to the one which creates a key with the correct mask. busy atm, but something like apiurl.com/createpredefined/58293498 (use correct mask). Makes registering that much easier and takes them straight to the create api page.


I did :)
Jognu
French Kiss Singularity
#337 - 2013-01-24 16:49:54 UTC
I also have some users who think that the button "Change profil" would be better at the bottom of the page.
But not really important, just detail.

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Impudent Dragon
Native Freshfood
Minmatar Republic
#338 - 2013-01-25 08:56:57 UTC
I am using "Temars Eve API auth for smf " by Shin Chogan. API key was created - https://support.eveonline.com/api/Key/CreatePredefined/25165896 . While updating in forum profile i get error "API Error (no error message)".
Shin Chogan
Federal Navy Academy
Gallente Federation
#339 - 2013-01-25 13:24:06 UTC
Impudent Dragon wrote:
I am using "Temars Eve API auth for smf " by Shin Chogan. API key was created - https://support.eveonline.com/api/Key/CreatePredefined/25165896 . While updating in forum profile i get error "API Error (no error message)".



You'll get that when one of the API calls doesn't get xml back (ie CCP's servers having another fit) Note that since I fixed the caching you'll now also have to wait an hour before it will get anything back except the same response :(
admiral root
Red Galaxy
#340 - 2013-01-25 16:17:14 UTC
I'm using 1.3.0 r169 (Troy), and have a couple of questions. Firstly, the page where you enter the corp standings API key - does it really need a full key, or is that just text that hasn't been changed from when the mod used legacy keys? Secondly, how do I force the mod to grab an update for standings?

No, your rights end in optimal+2*falloff