[Slashcode-development] [ slashcode-Patches-411885 ] bug in create_user?

[<no...@so...>]

Patches item #411885, was updated on 2001-03-28 05:23
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=304421&aid=411885&group_id=4421

Category: None
Group: None
Status: Open
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: bug in create_user?

Initial Comment:
I have a problem running the slash-2.0.0-pre1
version of slash on my site. I'm not sure this is due 
to a misconfiguration or error in the code. 

When I tried to add an user to the database I got the 
error on my slash site that this userid was allready 
assigned. Looking at the logs I saw the following:

[root@p2p logs]# tail p2p.nta.no_error_log
DBD::mysql::st execute failed: You have an error in 
your SQL syntax near 'AND us
ers_comments.uid= AND users_index.uid= AND 
users_info.uid= AND users_prefs' at l
ine 1 at /usr/lib/perl5/site_perl/5.6.0/i386-
linux/Slash/DB/Utility.pm line 163.
[Wed Mar 28 09:10:57 2001] 
[error] /users.pl:Slash::DB::MySQL:/usr/lib/perl5/sit
e_perl/5.6.0/i386-linux/Slash/DB/MySQL.pm:2665:SELECT 
* FROM users,users_comment
s,users_index,users_info,users_prefs WHERE users.uid= 
AND users_comments.uid= AN
D users_index.uid= AND users_info.uid= AND 
users_prefs.uid=
[Wed Mar 28 09:10:57 2001] [error] Which was called 
by:Apache::ROOTp2p_2enta_2en
o::users_2epl:/usr/local/slash/site/p2p.nta.no/htdocs/u
sers.pl:361:SELECT * FROM
 
users,users_comments,users_index,users_info,users_prefs
 WHERE users.uid= AND us
ers_comments.uid= AND users_index.uid= AND 
users_info.uid= AND users_prefs.uid=

DBD::mysql::db selectall_arrayref failed: You have an 
error in your SQL syntax n
ear '' at line 1 
at /usr/lib/perl5/site_perl/5.6.0/i386-
linux/Slash/DB/Utility.p
m line 218.
[Wed Mar 28 09:10:57 2001] 
[error] /users.pl:Slash::DB::MySQL:/usr/lib/perl5/sit
e_perl/5.6.0/i386-linux/Slash/DB/MySQL.pm:2666:SELECT 
name,value FROM users_para
m WHERE uid=
[Wed Mar 28 09:10:57 2001] [error] Which was called 
by:Apache::ROOTp2p_2enta_2en
o::users_2epl:/usr/local/slash/site/p2p.nta.no/htdocs/u
sers.pl:361:SELECT name,v
alue FROM users_param WHERE uid=


I would be very pleased if you could help me to 
resolve this problem for me.

Regards René


----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=304421&aid=411885&group_id=4421