WordPress MU

I've read other threads where people have the same problem, and I've tried all the fixes but I can't get it working!

Fatal Error
Could Not Find Blog!
Searched for bloghost.clBASE in bloghost_blog::wp_blogs table. Is that right?
Please check that your database contains the following tables:
wp_blogs
wp_users
wp_usermeta
wp_site
wp_sitemeta
wp_sitecategories
If you suspect a problem please report it to support forums!

I am on a shared account, if that matters.

error messages really suck...

vhost or subdirs?
please tell us what URL the blog is and what content is in wp_site and wp_blogs, that query show do it:
SELECT * FROM wp_blogs;

subdirs

the blog is located at bloghost.cl

blog_id site_id domain path registered last_updated is_public
1 1 bloghost.cl/ /home2/bloghost/public_html/ 2005-08-09 00:00:00 2005-08-09 00:00:00 yes

maybe if you change the path in the db to /
Sadly wpmu isn't it handling correctly every day.

Nope, changed it to that and no luck :(

sorry, it's like /blog of course, it's not the absolute path on the server but the path you type in in the browser.

For the main blog use /main and add following to your .htaccess (somewhere at the start after starting the RewriteEngine):
RewriteRule ^/?$ http://bloghost.cl/main/ [R=301,L]

This will rewrite bloghost.cl to bloghost.cl/main where your main-blog should be.

maybe you find more interesting stuff in my htaccess:
http://tomk32.de/tmp/wpmu-htaccess

There are no folders apart from wp-admin/wp-content/wp-includes

I don't undestand what you are trying to tell me to do :P
All I did was a fresh install, I can't login, create or do anything with this.

wpmu is pre-alpha and it's not installing the first blog correctly. happens, but you can fix it if you play around enough.
in wp-settings.php is the code for selecting the right blog, try some print_r() if you want to see what it's doing.

Ok, I got it to install but it screwed up the url and I can't even login :P

Dear User,

Your new blog has been successfully set up at:
http://cl/bloghost/

You can log in to the administrator account with the following information:
Username: admin
Password: xxxx
Login Here: http://cl/bloghost/wp-login.php

We hope you enjoy your new weblog.
Thanks!

--The WordPress Team

What did I do wrong there? :P

Edit: Also, if I click on the links at bloghost.cl with the sessionid, I get a database error.

Ok, I got this fixed and so far everything is working.

Now to test, design the front page and test some more :D