Re: [phpesp-general] problems with signup.php

[Jim B. <jp...@si...>]

* Harry Mangalam <hj...@ta...> [2005-07-20 11:29]:
> I tried to use the undocumented signup.php script that allows respondents to 
> make their own logins, but was unable to make it work.  After correcting the 
> missing paren, it further complained about the 'auto' designation  in the 
> realm field.
> 
> The insert statement was:
> 
> INSERT INTO respondent (username,password,email,fname,lname,realm) VALUES 
> ('tacg',PASSWORD('baba'),'hj...@ta...','Harry ','Mangalam',auto)
> 
> and the response was:
> 
> Request failed, please choose a different username.[ 1054: Unknown column 
> 'auto' in 'field list' ]
> 
> At this point I don't know what the problem is.  'auto' appears to be the 
> right group, altho it might need to be quoted (?) in some way?
> 
> Any hints?  With this feature, it'll be just about perfect!
> 
> -- 
> Cheers, Harry
> Harry J Mangalam - 949 856 2847 (vox; email for fax) - hj...@ta... 
>             <<plain text preferred>>
> 

IIRC, auto is a reserved keyword, so MySQL may be barfing on that.

Quoting 'auto' does work.  Should give you what you want.

I don't use respondents however, so my knowledge ends here.

Best Regards,
Jim B.