Rename Database - Database connect failed

Hi,

I renamed my database and made the changes to the /inc/header.inc.php file:

$db['user']                = 'blaine69_isexclub';

$db['db']                  = 'blaine69_isexclub';

Array
(
    [1] => Array
        (
            [file] => /home/blaine69/public_html/isexclub.net/inc/modules.inc.php
            [line] => 22
            [args] => Array
                (
                    [0] => /home/blaine69/public_html/isexclub.net/inc/db.inc.php
                )

            [function] => require_once
        )

    [2] => Array
        (
            [file] => /home/blaine69/public_html/isexclub.net/inc/admin.inc.php
            [line] => 23
            [args] => Array
                (
                    [0] => /home/blaine69/public_html/isexclub.net/inc/modules.inc.php
                )

            [function] => require_once
        )

    [3] => Array
        (
            [file] => /home/blaine69/public_html/isexclub.net/inc/design.inc.php
            [line] => 22
            [args] => Array
                (
                    [0] => /home/blaine69/public_html/isexclub.net/inc/admin.inc.php
                )

            [function] => require_once
        )

    [4] => Array
        (
            [file] => /home/blaine69/public_html/isexclub.net/index.php
            [line] => 39
            [args] => Array
                (
                    [0] => /home/blaine69/public_html/isexclub.net/inc/design.inc.php
                )

            [function] => require_once
        )

)

Array
(
    [_csoot] => 1282856913123
    [_csuid] => 47497fcffa8de181
    [ak14] => ok
    [hcl_chatid] => 3
    [idAff] => 1
    [lang] => en
    [Statistics] => have
    [strSec] => 209457b1ee988152b3698e63cd0b57ec
    [test_cook] => oui
)

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/blaine69/public_html/isexclub.net/inc/db.inc.php on line 251

... how can I fix this?

Unless you also changed the username for database access then this value. $db['user']                = 'blaine69_isexclub'; should have remained as it was. That is currently my best guess.

http://www.boonex.com/trac/dolphin/ticket/2140

The ticket system isn't to report problems that exist due to user error (or who knows, maybe it is an issue due to a bug). I recommend you re-check your database credentials and clear your /cache/ (except for the .htaccess file) directory.

Your kidding, he created a ticket on this?

Magnussoft is right. You don't create tickets for user created problems.

deano92964, I did rename my db_username as well

Magnussoft, I cleared the "cache" directory like you suggested and I still get "Database connect failed"....

Do you gentlemen have any other ideas?

( Is there another location that I need to change the database Name & Username? )

Blaine.

Sorry, about that guys.... the re-re-design of the boonex.com sight confused me a bit, I used the "search" box and somehow arrived at "submit a ticket".... now I know.

When I cleared the /cache/ directory I noticed that it did not have a .htaccess file inside.... is it supposed to?

Blaine.

I tried changing the Username back to the original and that seemed to do the trick.....

Why can't the username be changed and if it can be, how would I do it?

Blaine.

It may be hidden, depending on your viewing preferences in you FTP client. That said, try undoing the change to your database username.

Edit: There you go. If you only changed the database name, the username doesn't need to change. And if you do change the username, you also need to assign privleges to the related database name.

Ah that's right. privileges need to be granted to the database for the new username. Now why on earth did i not think of that. Damm, i am slipping.