Unable to create Admin account

[tlikb]

When I install everything was fine until creating Admin account.  I says table 'dbname.yabbse_members' not found.  The reasion is that I specify the db table prefix to yabbse but it does not use when creating the table.  When it tries to create the Admin account it looks for the table with prefix, so that it could not find.

Does anyone has this problem?  How would you fix it to have the table prefix works?

Thank you!

[andrea]

When I install everything was fine until creating Admin account.  I says table 'dbname.yabbse_members' not found.  The reasion is that I specify the db table prefix to yabbse but it does not use when creating the table.  When it tries to create the Admin account it looks for the table with prefix, so that it could not find.

Does anyone has this problem?  How would you fix it to have the table prefix works?

Just an idea to try out: maybe the dot "." in the prefix is the problem? Try out 'dbname_yabbse_members', I mean replace the dot "." by an underline "_".

[Ted]

Yes; andrea is right - dots are used for making joint queries. They won't work as part of a table name.

[tlikb]

Oh! No.  My prefix is only yabbse the dbname in part of 'dbname.yabbse_members' is mySQL database name.

If I don't use the prefix it works!  However, I want to use this feature to have two boards sharing same database.

[andrea]

How does the db info in your Settings.php look like? Is the $db_prefix set?

The db_prefix is working fine in my board. In my Settings.php the db info section looks like this:

########## Database Info ##########
$db_name = "xxxxxxxxxxxxxxx";
$db_user = "xxxxxxxxxxxxxx";
$db_passwd = "xxxxxxxxxxxxxx";
$db_server = "localhost";
$db_prefix = "yabbse_";

[tlikb]

Mine looks like this:

$db_name = "xxxxxx";
$db_user = "xxxxxxxxxx";
$db_passwd = "xxxxxxxx";
$db_server = "localhost";
$db_prefix = "";

So, the installer did not put this in correctly.  There fore the tables created without prefixes.  However, when the installer tries to create the admin account, it looks for the name of the table with prefix.  That's is where it messes up.

Now, I can't add the prefix because the tables were created without.