Error - database already exists!

smark67

Hopefully somebody can help me with this!

I'm trying to run a routine in my browser, a file called create_db.php. I have created a database but when I run this I get the message "Error - database already exists! If you want to create a new database delete the old one first.", yet if I then delete the database and run it, it comes up with the message "Could not select database". Is there anything obvious I am missing?

Also, one other query, where should my pear libraries directory be in relation to my wamp directory?

Many thanks in advance!

Mark

bradgrafelman

Hard to say what's wrong with create_db.php when we haven't seen it. Sounds like it's trying to select the database before ever creating it, possibly as a means to try to detect if the DB already exists (although if this really is the case, then it sounds like code was poorly written).

smark67 wrote:
Also, one other query, where should my pear libraries directory be in relation to my wamp directory?

Wherever you want it to be. Just make sure that directory is added to PHP's include_path directive.

smark67

Sorry, here is the beginning of the code:

<?php

$running_upgrade_script = true;
include_once("includes/inc.global.php");

$query = $cDB->Query("SHOW VARIABLES LIKE 'have_innodb';");
$row = mysql_fetch_array($query);
if($row[1] != "YES")   die("Your database does not have InnoDB support. See the installation instructions for more information about InnoDB. Installation aborted.");

if($cDB->Query("SELECT * FROM " . DATABASE_MEMBERS))   die("Error - database already exists! If you want to create a new database delete the old one first. You may also get this error if you are trying to install the program and your database userid or password in inc.config.php is incorrect.");


$cDB->Query("CREATE TABLE " . DATABASE_MEMBERS . "( member_id varchar(15) NOT NULL default '', password varchar(50) NOT NULL default '', member_role char(1) NOT NULL default '', security_q varchar(25) default NULL, security_a varchar(15) default NULL, status char(1) NOT NULL default '', member_note varchar(100) default NULL, admin_note varchar(100) default NULL, join_date date NOT NULL default '0000-00-00', expire_date date default NULL, away_date date default NULL, account_type char(1) NOT NULL default '', email_updates int(3) unsigned NOT NULL default '0', balance decimal(8,2) NOT NULL default '0.00', PRIMARY KEY (member_id)) TYPE=InnoDB;") or die("Error - database already exists! If you want to create a new database delete the old one first.");

smark67

Hi again, I still haven't managed to get a solution to this. Would be extremely grateful if somebody could look at the code above and suggest an idiot proof solution! :-)

Many thanks in advance and Happy New Year!

Mark

bradgrafelman

As I previously mention, simply trying to SELECT data from what could be a non-existent database seems like a pretty bad way of going about what you're trying to do.

Instead, either simply try to create the database and detect the error that will occur if it already exists, or else use a 'DROP DATABASE db IF EXISTS' type of query before you try to create it.