Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 2 Years, 5 Months, 3 Weeks, 1 Day, 9 Hours, 58 Minutes, 1 Second ago "unable to select database"
#1
Solved: 2 Years, 5 Months, 3 Weeks, 1 Day, 9 Hours, 58 Minutes, 1 Second ago
Hi there!.

I have a little problem with my mybb installation.

It works great when i use

PHP Code:
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'mydatabase';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = '127.0.0.1';
$config['database']['username'] = 'root';
$config['database']['password'] = 'mypassword'

but it gives a "[READ] unable to select database" when i try

PHP Code:
$config['database']['type'] = 'mysqli';
$config['database']['read']['database'] = 'mydatabase';
$config['database']['read']['table_prefix'] = 'mybb_';

$config['database']['read']['hostname'] = '127.0.0.1';
$config['database']['read']['username'] = 'root';
$config['database']['read']['password'] = 'mypassword';

$config['database']['write']['database'] = 'mydatabase';
$config['database']['write']['table_prefix'] = 'mybb_';

$config['database']['write']['hostname'] = '172.74.32.252';
$config['database']['write']['username'] = 'root';
$config['database']['write']['password'] = 'mypassword'

Any sugesstion?, 172.74.32.252( is a mysql master server ), and this webserver is a mysql slave, it replicates the database on each single change on the master.


PD: Versión 1.6.4
I copyed&pasted the database name, into the file after 4 attemps.
I would apreciate your help. Merci ^^
Stargate Galactic Travellers web based game project developper.
Reply
#2
Solved: 2 Years, 5 Months, 3 Weeks, 1 Day, 9 Hours, 58 Minutes, 1 Second ago
I've always put localhost instead of 127.0.0.1 and had no issues. Have you tried that yet?
Reply
#3
Solved: 2 Years, 5 Months, 3 Weeks, 1 Day, 9 Hours, 58 Minutes, 1 Second ago
not, but i have tried this right now, and not getting any good result

may be the database name? it haves a "_" "Example_Foro
This errors appears even only if i only write the read section

when i write ['read'] , then it will start failing

Must i edit anything?

PD: "Problem fixed, but i don't feel like to show the fix, for the bad support"
Stargate Galactic Travellers web based game project developper.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)