WordPress MU

I want users to register for their own blog on the site. FOr the whole night i have been searching for some hack like it and couldn't find any.

basically i want to make a site like this.

http://freeblogz.info/signup.php

I know this is probably dumbest questin ever but i need to learn abcd of blogs now.

Thanks for the help in advance.

Try http://yourwebsite.com/wp-signup.php

HELP please: syntax error on registration page:
This appears at the bottom of my registration page [new sign-up]
WordPress 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 'GROUP BY year(post_date), month(post_date), dayofmonth(post_dat]
SELECT DISTINCT post_date FROM GROUP BY year(post_date), month(post_date), dayofmonth(post_date)

I checked in php myadmin, and can not find any errors. checked every table, the entire structure, ran repair - everything returns the OK.
am at a loss what to do.
Can anyone please help?

What version of MySQL and MU are you running?

Was this on wp-signup.php?

Can you list the specific steps you did to recreate this error?

You may want to hit this page sou you can give us more details.

hi,
yes it came up by accessing: http://marsart.org/blogs/wp-signup.php
this was the first time that I accessed this page, could not find before where users can register for a blog [lol]

MySQL - 4.0.27-standard
PHP 4.4.2
on Linux, Apache 1.3.36 [Unix]
MU version , am not sure, downloaded and installed June 26.2006 - thought this was then the latest 'unstable.zip' version.

ps: probably will need to go ahead and do a new clean install anyway, because I have a problem somewhere I can not fix [some links autmatically lead me to our regular website home page, which was not intended, but can not find where to fix this.
since I have not opened the MU anyway and no users, it's not a big deal to re-install

warning message does not appear on main page or comment pages
http://marsart.org/blogs/

I do have a question though regarding a new install - if I don't take the wp-install = currently I absolutely need to have the forward slash at the end of the url to access the blog page, if no end slash I get 404?
it's already not http://www. what most users would assume, so if they also forget to type the slash at the end, they will always wind up with a 4o4.
How can I avoid this? if at all

adding info:
and of course, also never received the email to activate the blog [checked everywhere - no email]

This is what my Syntax currently shows:
SELECT COUNT( * ) AS Rows , t
FROM wp_registration_log
GROUP BY t
ORDER BY t
LIMIT 0 , 30

has anyone figured out why activation email does not get to a user?
I signed up [registered] for a blog, last register page says correctly that I have to activate it and should look for the email.
But I never got an email.
Used a different domain email address, since that is what will be when a user signs up - some email address from another domain...
So - because of this, have no blogs yet.
the admin [default blog] works fine

Check your mail server logs?