When click get characters button on registration page nothing happens

[GoogleCodeExporter]

TEA Version?

TEA 1.3.0 r168 © 2009-2011, Temars EVE API

SMF Version?

SMF 2.0.1 | SMF © 2011, Simple Machines

What steps will reproduce the problem?
1. Go to register character 
2. Enter API details
3. Click the get character button

What is the expected output? What do you see instead?

A list of characters to be shown?

Please provide any additional information below.

Database 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 
'(this has different values - looks like names of people trying to register)' 
at line 1

Original issue reported on code.google.com by ca9...@gmail.com on 11 Oct 2011 at 10:12

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

kind of a crippling bug, no one can register on the forum :(  Is there any 
solution or quick fix that works until the next revision?

Original comment by LogicSeq...@gmail.com on 18 Oct 2011 at 5:44

[GoogleCodeExporter]

I get this error as well and when I make : Run Full Member Check Now
I got :
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: /var/www/forum/Sources/TEA.php
Line: 2149

Original comment by serge...@gmail.com on 19 Oct 2011 at 9:45

[GoogleCodeExporter]

Assuming this is in reg_checks() around line 2840 then it isn't stopping people 
registering who are actually doing it correctly.
What is happening is people are putting in a name of some kind (probably the 
name they assigned to the api key) instead of the numeric API ID.

I've added :
if(!is_numeric($_POST['tea_user_id']))                {
       return("Enter API ID not Name you dope !!!");
}

just before :
if(!empty($_POST['tea_user_id']))

in the function reg_checks().

Hope that helps.

Original comment by bar...@telinformix.com on 20 Oct 2011 at 1:51

[GoogleCodeExporter]

unfortunately that's not the case.  I've tried creating a new account myself.  
Remember this version uses the new API now.  If you enter your ID and 
verification code and hit "Get characters" nothing happens at all, in all 
browsers.

Original comment by LogicSeq...@gmail.com on 20 Oct 2011 at 3:55

[GoogleCodeExporter]

it's fixed for me, it was php5-curl extension not installed.

Original comment by serge...@gmail.com on 20 Oct 2011 at 10:20

[GoogleCodeExporter]

Not installed where? Locally or server? Could u go thru the exact steps you 
took to fix this problem PLEASE?

Original comment by LogicSeq...@gmail.com on 20 Oct 2011 at 1:36

[GoogleCodeExporter]

it was on server side.
for Debian Servers:

apt-get install php5-curl 

and it's done !

Original comment by serge...@gmail.com on 20 Oct 2011 at 2:41

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Resolved my issue. The TEA folder that belongs in the forum directory was not 
copied into the directory on install, manually placing it there solved the 
problem. There may be an installer bug. either way I'd say check for that if 
you are still having issues. 

Original comment by LogicSeq...@gmail.com on 20 Oct 2011 at 8:06