By odyy on

HI!
I've installed correctly,by launching my browser, I get this error "Site off-line The site is currently not available due to technical problems. Please try again later. Thank you for your understanding." and then "The mysqli error was: Unknown database 'drupal_openpublish'."
help please

⋅ Categories: Drupal 6.x

Comments

bwv’s picture

bwv commented

Check to make sure that your database information -- password, user name, database name, and db server identifier -- are correctly recorded in the settings.php file, in the /sites/default directory of your root installation.

odyy’s picture

odyy commented

in my file .sites / default / settings.php I had this line:
$db_url = 'mysqli://odette:passer@localhost/isoc';
and it makes me this error:
Warning: Table 'isoc.access' doesn't exist query: SELECT 1 FROM access WHERE type = 'host' AND LOWER('127.0.0.1') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in C:\wamp\www\drupal-6.14\includes\database.mysqli.inc on line 128

Warning: Table 'isoc.system' doesn't exist query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in C:\wamp\www\drupal-6.14\includes\database.mysqli.inc on line 128

Warning: Table 'isoc.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in C:\wamp\www\drupal-6.14\includes\database.mysqli.inc on line 1

after having change it like this: $db_url = 'mysqli://odette:passer@localhost/drupal_openpublish';
the error disappears but i got the message "site offline"

odyy’s picture

odyy commented

I've installed correctly drupal 6.14,by launching my browser, I get this error "Site off-line The site is currently not available due to technical problems. Please try again later. Thank you for your understanding." and then "The mysqli error was: Unknown database 'drupal_openpublish'."
help please

bwv’s picture

bwv commented

If you do not open your settings.php file and read through it to make sure that the information in it corresponds to the information on your server, then you will never be able to resolve this problem.

This is what you are looking for:

* Database URL format:
 *   $db_url = 'mysql://username:password@localhost/databasename';
 *   $db_url = 'mysqli://username:password@localhost/databasename';
  */
$db_url = 'mysql://someusername:somepassword@localhost/databasenamehere';
$db_prefix = 'if_there_is_a_db_prefix_it_goes_here';
/**
odyy’s picture

odyy commented

in my file .sites / default / settings.php I had this line:
$db_url = 'mysqli://odette:passer@localhost/isoc';
and it makes me this error:
Warning: Table 'isoc.access' doesn't exist query: SELECT 1 FROM access WHERE type = 'host' AND LOWER('127.0.0.1') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in C:\wamp\www\drupal-6.14\includes\database.mysqli.inc on line 128

Warning: Table 'isoc.system' doesn't exist query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in C:\wamp\www\drupal-6.14\includes\database.mysqli.inc on line 128

Warning: Table 'isoc.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in C:\wamp\www\drupal-6.14\includes\database.mysqli.inc on line 1

after having change it like this: $db_url = 'mysqli://odette:passer@localhost/drupal_openpublish';
the error disappears but i got the message "site offline"

yelvington’s picture

yelvington commented

Why did you put "drupal_openpublish" there?

You can't just make up a database name. You have to use the name of an existing database.

Your error messages suggest that you have no such database "drupal_openpublish."
You do have "isoc," but it has not been populated with Drupal tables and data.

odyy’s picture

odyy commented

it was a solution I find on the net,otherwise I have no idea what "drupal_openpublish" may be.
but when i keep my initial file settings.php i got errors.
after having replaced it in: $db_url = 'mysqli://odette:passer@localhost/drupal_openpublish'; i can't access to the site,it's offline

I can not find the problem

sivachayanam’s picture

sivachayanam commented

Hi odyy,

Can you please explain me in details. because i was also facing the same problem. i will not connect to drupal at my local system.
$db_url = 'mysqli://root:@localhost/drupal123'; I cannt access the site, instead of a blank page is displaying. mean.
I try to this one also $db_url = 'mysql://root:@localhost/drupal123';

but no output.

If you know the solution can you please explain me in detail.

Thank you...!
Siva