Jump to content



Photo
- - - - -

Includes/configure.php - Database entry in CAPS?


This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1   Shivers Polokwane

Shivers Polokwane
  • Members
  • 1 posts

Posted 26 April 2012 - 10:12

I Cant get the site talking to the database...
Hosting company says it's gotta be in caps, but in caps i get an error as well.

Anyway now when i use the two, I get two different errors:

lowercase - no db selected
uppercase - "Server error on http://www.shivers.co.za/shiversite/index.php. It may be down for maintenance or configured incorrectly."

my includes/config.php file


define('DB_SERVER', '196.22.172.209');
define('DB_SERVER_USERNAME', 'm1656920');
define('DB_SERVER_PASSWORD', 'this isn't the ral pass');
define('DB_DATABASE', 'CLDBHOST_M1656920');

from hosting company:
Database Server: db3.swh.mweb.net or 196.22.172.209
It's in cap in PHPMYadmin.

Lowercase works fine on my other hosting company using a clone of this site.

Anyone familiar with this?

#2   MrPhil

MrPhil
  • Members
  • 5,289 posts

Posted 26 April 2012 - 18:47

I would double check with your host on the format of database name and user name. Many hosts require you to "prepend" your account name to the actual database and user names, like shivers_m1656920. It's unusual to require names be in CAPS, but I suppose it's possible. You would look in your hosting control panel > databases (possibly in phpMyAdmin) to see what name was given to the database and what user name is associated with it (did you overlook any steps needed of associating the user name with the database, and granting sufficient permissions to that user?). Naturally, capitalization should match exactly with what you use in configure.php (maybe that's what your host was trying to tell you). You may need to prepend your account name to those fields.