Databases
StackOverflow2013
Postsdbo
POCodeigniter database connection error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCodeigniter database connection error
    primarykey
    data
    text
    <p>I have a curious problem...</p> <p>Using Codeigniter I've redesigned my website on a test domain and hosting package, and today I have copied all files over to my other domain and hosting package, changed my database configurations (they are 100% correct) - and I'm getting this error:</p> <p>A Database Error Occurred</p> <p>Unable to connect to your database server using the provided settings.</p> <p>Filename: core/Loader.php</p> <p>Line Number: 346</p> <p>I shouldn't have to change any other setting values in any files as it's still working on my test domain, just not on the other one... - are there any other configuration settings I've forgot to switch aside from main 'application/config/database.php'</p> <pre><code>&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); /* | ------------------------------------------------------------------- | DATABASE CONNECTIVITY SETTINGS | ------------------------------------------------------------------- | This file will contain the settings needed to access your database. | | For complete instructions please consult the 'Database Connection' | page of the User Guide. | | ------------------------------------------------------------------- | EXPLANATION OF VARIABLES | ------------------------------------------------------------------- | | ['hostname'] The hostname of your database server. | ['username'] The username used to connect to the database | ['password'] The password used to connect to the database | ['database'] The name of the database you want to connect to | ['dbdriver'] The database type. ie: mysql. Currently supported: mysql, mysqli, postgre, odbc, mssql, sqlite, oci8 | ['dbprefix'] You can add an optional prefix, which will be added | to the table name when using the Active Record class | ['pconnect'] TRUE/FALSE - Whether to use a persistent connection | ['db_debug'] TRUE/FALSE - Whether database errors should be displayed. | ['cache_on'] TRUE/FALSE - Enables/disables query caching | ['cachedir'] The path to the folder where cache files should be stored | ['char_set'] The character set used in communicating with the database | ['dbcollat'] The character collation used in communicating with the database | NOTE: For MySQL and MySQLi databases, this setting is only used | as a backup if your server is running PHP &lt; 5.2.3 or MySQL &lt; 5.0.7 | (and in table creation queries made with DB Forge). | There is an incompatibility in PHP with mysql_real_escape_string() which | can make your site vulnerable to SQL injection if you are using a | multi-byte character set and are running versions lower than these. | Sites using Latin-1 or UTF-8 database character set and collation are unaffected. | ['swap_pre'] A default table prefix that should be swapped with the dbprefix | ['autoinit'] Whether or not to automatically initialize the database. | ['stricton'] TRUE/FALSE - forces 'Strict Mode' connections | - good for ensuring strict SQL while developing | | The $active_group variable lets you choose which connection group to | make active. By default there is only one group (the 'default' group). | | The $active_record variables lets you determine whether or not to load | the active record class */ $active_group = 'default'; $active_record = TRUE; $db['default']['hostname'] = '79.170.40.242'; $db['default']['username'] = 'xxxxxx'; $db['default']['password'] = 'Xxxxxx'; $db['default']['database'] = 'xxxxxx'; $db['default']['dbdriver'] = 'mysql'; $db['default']['dbprefix'] = ''; $db['default']['pconnect'] = TRUE; $db['default']['db_debug'] = TRUE; $db['default']['cache_on'] = FALSE; $db['default']['cachedir'] = ''; $db['default']['char_set'] = 'utf8'; $db['default']['dbcollat'] = 'utf8_general_ci'; $db['default']['swap_pre'] = ''; $db['default']['autoinit'] = TRUE; $db['default']['stricton'] = FALSE; /* End of file database.php */ /* Location: ./application/config/database.php */ </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser2505513
    1. USuser2505513
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COpost your database.php config file, an sure it's a database.php param wrong that produces that error, like password, or db name, or user or host
      singulars
      1. POCodeigniter database connection error
      1. USsbaaaang
    2. CO@sbaaaang As requested... Aside from username, password and database variables there is no difference from the same file on my test domain (which is working)
      singulars
      1. POCodeigniter database connection error
      1. USuser2505513
    3. COare you using different host for your db? why not 127.0.0.1? is somewhere else located the db i mean?
      singulars
      1. POCodeigniter database connection error
      1. USsbaaaang
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload