No database connection??

[_molly_ccDESIGN]

when i go to my stores Online Catalog link i get this error:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

 

um.......what did i do wrong and how can i fix this shit?

thankx

>_<

[Guest]

Molly,

 

Check catalog/includes/configure.php. Do you have your database values filled in correctly (near the bottom of the file)?

 

ed

[_molly_ccDESIGN]

// define our database connection

 

should i have something here?

define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers

 

define('DB_SERVER_USERNAME', '***');

define('DB_SERVER_PASSWORD', '****');

define('DB_DATABASE', '***');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

 

I am using a dedicated virtual server and i am very new to all of this php/database stuff..........any suggestions?

<_<

[Guest]

Molly,

 

You shouldn't post your database name/userid/password on a public forum. I just sent a note to the admins to edit the post.

 

Try setting the database server to 'localhost'. Also, is that the name of the database and the username/password of an account on the database?

 

ed

[_molly_ccDESIGN]

SHIT! see i am new to this.

thank you for letting me know these things. yes that is the username and password...i will try and enter localhost and see what happens.

again thank u!

>_<

[_molly_ccDESIGN]

Im still getting the same error........

i tryed putting localhost on catalog/admin/includes/configure.php also.

 

what does this mean?

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

and any thing else i can try?? :blink:

thank u so very much!

[Guest]

Molly,

 

I looked at your posting history. You had the catalog working at one point, although you were using different username/password values. What changed from then til now?

 

I assumed the db server was localhost because most shops are set up that way. This only works if the catalog AND the database is on the same server. Are they?

 

Are you sure the database is running? That could cause a connection error.

 

Finally, I'm not a prude and can curse with the best of them but I tailor my language for the environment. Vulgarities are generally not used on this forum. That may be turning off some people from wanting to help.

 

ed

[♥Vger]

If this does not work:

 

define('DB_SERVER', 'localhost');

 

Try this:

 

define('DB_SERVER', '127.0.0.1');

 

this works for servers using RedHat Enterprise Linux.

 

If you are on a Windows server, or your host uses seperate servers for mysql then the address may be different - so check with them.

 

Vger