CakePHP Error Database not defined

Question

I searched in every question an answer to this, but nothing found! This is the error when I enter in localhost/cakephp:

Notice (8): Undefined index: datasource [CORE\Cake\Model\ConnectionManager.php, line 258]

The other error:

Cake is NOT able to connect to the database.

Datasource class could not be found.

This is my config in database.php:

<?php
class DATABASE_CONFIG {
var $default = array('driver' => 'mysql',
                 'persistent'  => false,
                 'database' => '',
                     'host'        => 'localhost',
                     'login'       => 'lorizz',
                     'password'    => 'reyxD22!',
                     'database'    => 'my_cakephp_project',
                     'prefix'      => '');

var $test = array('driver' => 'mysql',
                 'persistent'  => false,
                  'database' => '',
                     'host'        => 'localhost',
                     'login'       => 'lorizz',
                     'password'    => 'reyxD22!',
                     'database'    => 'my_cakephp_project',
                     'prefix'      => '');

}
?>

Any answer?

What is the location of the file, and what is the location of APP? — Chris Trahey
– Chris Trahey, Commented Nov 11, 2012 at 18:14
Are you sure it is in the correct location (in the Config directory in you application folder)? It may be case sensitive. — fracz
– fracz, Commented Nov 11, 2012 at 18:15
public $Mysql = array([...] ? It says it cant find connection "Mysql", so have you defined "Mysql" ? — Green Black
– Green Black, Commented Nov 11, 2012 at 18:16

Rashi Goyal · Accepted Answer · 2012-11-12 10:37:28Z

2

There you need to remove database used twice in your variables var $default and var $test

the config in database.php should be :

<?php
class DATABASE_CONFIG {
var $default = array('driver' => 'mysql',
                 'persistent'  => false,
                     'host'        => 'localhost',
                     'login'       => 'lorizz',
                     'password'    => 'reyxD22!',
                     'database'    => 'my_cakephp_project',
                     'prefix'      => '');

var $test = array('driver' => 'mysql',
                 'persistent'  => false,
                     'host'        => 'localhost',
                     'login'       => 'user',
                     'password'    => 'password!',
                     'database'    => 'test_database_name',
                     'prefix'      => '');

}
?>

edited Nov 12, 2012 at 10:37

answered Nov 12, 2012 at 10:30

Rashi Goyal

9519 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

4444 · Accepted Answer · 2014-10-29 15:14:17Z

0

only change 'driver' => 'mysql', to 'datasource' => 'Database/Mysql',

<?php
class DATABASE_CONFIG {
public $default = array('datasource' => 'Database/Mysql',
                 'persistent'  => false,
                 'database' => '',
                     'host'        => 'localhost',
                     'login'       => 'lorizz',
                     'password'    => 'reyxD22!',
                     'database'    => 'my_cakephp_project',
                     'prefix'      => '');

public $test = array('datasource' => 'Database/Mysql',
                 'persistent'  => false,
                  'database' => '',
                     'host'        => 'localhost',
                     'login'       => 'lorizz',
                     'password'    => 'reyxD22!',
                     'database'    => 'my_cakephp_project',
                     'prefix'      => '');

}
?>

edited Oct 29, 2014 at 15:14

4444

3,73010 gold badges35 silver badges47 bronze badges

answered Oct 29, 2014 at 14:35

Saan

1781 silver badge11 bronze badges

1 Comment

Saan Over a year ago

set database name and see the solution.

Collectives™ on Stack Overflow

CakePHP Error Database not defined

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related