Thread

Hello,
I’m tring to enable SQL cache from Admin > System Administration > Database settings. When I click on sumbit button I get this error:

Your database.php file seems to have a problem. Unable to find the active group.

I have 2 groups defined in my database.php file but it seems to be ok (file has write permissions):

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

$active_group = 'ee_prod';
$active_record = TRUE;

$db['ee_prod']['hostname'] = "";
$db['ee_prod']['username'] = "";
$db['ee_prod']['password'] = "";
$db['ee_prod']['database'] = "";
$db['ee_prod']['dbdriver'] = "mysql";
$db['ee_prod']['dbprefix'] = "stl_";
$db['ee_prod']['pconnect'] = FALSE;
$db['ee_prod']['swap_pre'] = "exp_";
$db['ee_prod']['db_debug'] = TRUE;
$db['ee_prod']['cache_on'] = TRUE;
$db['ee_prod']['autoinit'] = FALSE;
$db['ee_prod']['char_set'] = "utf8";
$db['ee_prod']['dbcollat'] = "utf8_general_ci";
$db['ee_prod']['cachedir'] = "";

$db['ee_dev']['hostname'] = "";
$db['ee_dev']['username'] = "";
$db['ee_dev']['password'] = "";
$db['ee_dev']['database'] = "_dev";
$db['ee_dev']['dbdriver'] = "mysql";
$db['ee_dev']['dbprefix'] = "stl_";
$db['ee_dev']['pconnect'] = FALSE;
$db['ee_dev']['swap_pre'] = "exp_";
$db['ee_dev']['db_debug'] = TRUE;
$db['ee_dev']['cache_on'] = FALSE;
$db['ee_dev']['autoinit'] = FALSE;
$db['ee_dev']['char_set'] = "utf8";
$db['ee_dev']['dbcollat'] = "utf8_general_ci";
$db['ee_dev']['cachedir'] = "";

/* End of file database.php */
/* Location: ./system/expressionengine/config/database.php */

Thanks.
G.

gabric098,

What version and build of EE are you using?

Is you comment out the ee_dev group lines does the error still appear?

What version and build of EE are you using?

EE v2.1.1 build: 20101020

Is you comment out the ee_dev group lines does the error still appear?

Yes, I tried to comment or remove all ee_dev group lines but the error is still there… If I try to cange $active_group var to a non existent value (e.g. ‘ee_dummy’), I can’t access to EE control panel and I get this error:
You have specified an invalid database connection group.

Thanks.
G.

I am afraid having two groups defined like that is not a supported solution. When you restrict it to one group only, does that work? In which case two separate files, to be used interchangeably, might be an option.

Database properties update seems to work only if active_group is named ‘expressionengine’ and, in this case, works only for pconnect and db_debug properties, cache_on is never updated even if no error is shown.

This is not a big problem, I can update database.php manually but could be a good idea open a ticket in bug tracker (if this not happens only to me).

Thanks a lot!
G.

By all means, feel free to report it. Please let us know if there’s anything else we can do for you.

This “non bug”: https://support.ellislab.com/bugs/detail/13470/
is related to the issues reported here.

Very good. Thanks for the feedback, and please feel free to start a new thread as needed.