error creating tables

im trying to create a database in a php file.i have MySql 5.0.33 PHP 5.2.1
this is the code i have in the php file



$con = mysql_pconnect("127.0.0.1","root","12345");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}


if (mysql_query("CREATE DATABASE mydatabase",$con))
{
echo 'Database created ';
}
else
{
echo "Error creating database: " . mysql_error();
}


if(!mysql_select_db("mydatabase"))
{
die('Could not select database: mydatabase ' . mysql_error());
}

echo "Database selected ";

if (mysql_query("CREATE TABLE customer
(f_name VARCHAR(15) NOT NULL,
l_name VARCHAR(15) NOT NULL,
phone VARCHAR(11) ,
account INT UNSIGNED PRIMARY KEY)")
)
{
echo 'table created';
}
else
{
echo " Error creating table: " . mysql_error();
}

when i view this file in the browser i get

Database created Database selected Error creating table: Can't create table
'.\mydatabase\customer.frm' (errno: 121)

any idea wht the prob is??
I did some reading and found it might have something to do with InnoDB. but
i dont know what that is .If that is the prob can someone please explain
InnoDB concept
--
View this message in context: http://www.nabble.com/error-creating-tables-tf3300307.html#a 9180499
Sent from the Php - Database mailing list archive at Nabble.com.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: error creating tables

check your permissions for the user, perhaps the create table permission is
missing or the permissions need to be flushed to take effect

bastien


>From: aconite
>To: php-db@lists.php.net
>Subject: [PHP-DB] error creating tables
>Date: Tue, 27 Feb 2007 03:58:23 -0800 (PST)
>
>
>im trying to create a database in a php file.i have MySql 5.0.33 PHP 5.2.1
>this is the code i have in the php file
>
>
>
>$con = mysql_pconnect("127.0.0.1","root","12345");
>if (!$con)
> {
> die('Could not connect: ' . mysql_error());
> }
>
>
>if (mysql_query("CREATE DATABASE mydatabase",$con))
> {
> echo 'Database created ';
> }
>else
> {
> echo "Error creating database: " . mysql_error();
> }
>
>
>if(!mysql_select_db("mydatabase"))
>{
>die('Could not select database: mydatabase ' . mysql_error());
>}
>
> echo "Database selected ";
>
>if (mysql_query("CREATE TABLE customer
> (f_name VARCHAR(15) NOT NULL,
> l_name VARCHAR(15) NOT NULL,
> phone VARCHAR(11) ,
> account INT UNSIGNED PRIMARY KEY)")
> )
>{
> echo 'table created';
> }
>else
> {
> echo " Error creating table: " . mysql_error();
> }
>
>when i view this file in the browser i get
>
>Database created Database selected Error creating table: Can't create table
>'.\mydatabase\customer.frm' (errno: 121)
>
>any idea wht the prob is??
>I did some reading and found it might have something to do with InnoDB. but
>i dont know what that is .If that is the prob can someone please explain
>InnoDB concept
>--
>View this message in context:
>http://www.nabble.com/error-creating-tables-tf3300307.html# a9180499
>Sent from the Php - Database mailing list archive at Nabble.com.
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>

____________________________________________________________ _____
Free Alerts : Be smart - let your information find you !
http://alerts.live.com/Alerts/Default.aspx

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: error creating tables

--Apple-Mail-3--1027160980
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

Good rule - to debug try to run the same command on the command line
of the terminal tool, you'll get better errors.

But I suspect you have not said what the PRIMARY KEY is - typically
you would say: PRIMARY KEY(f_name, l_name)
or perhaps account whatever, it should be unique.

Good Luck,
Frank

On Feb 27, 2007, at 3:58 AM, php-db-digest-help@lists.php.net wrote:

> From: aconite
> Date: February 27, 2007 3:58:23 AM PST
> To: php-db@lists.php.net
> Subject: error creating tables
>
>
>
> im trying to create a database in a php file.i have MySql 5.0.33
> PHP 5.2.1
> this is the code i have in the php file
>
>
>
> $con = mysql_pconnect("127.0.0.1","root","12345");
> if (!$con)
> {
> die('Could not connect: ' . mysql_error());
> }
>
>
> if (mysql_query("CREATE DATABASE mydatabase",$con))
> {
> echo 'Database created ';
> }
> else
> {
> echo "Error creating database: " . mysql_error();
> }
>
>
> if(!mysql_select_db("mydatabase"))
> {
> die('Could not select database: mydatabase ' . mysql_error());
> }
>
> echo "Database selected ";
>
> if (mysql_query("CREATE TABLE customer
> (f_name VARCHAR(15) NOT NULL,
> l_name VARCHAR(15) NOT NULL,
> phone VARCHAR(11) ,
> account INT UNSIGNED PRIMARY KEY)")
> )
> {
> echo 'table created';
> }
> else
> {
> echo " Error creating table: " . mysql_error();
> }
>
> when i view this file in the browser i get
>
> Database created Database selected Error creating table: Can't
> create table
> '.\mydatabase\customer.frm' (errno: 121)
>
> any idea wht the prob is??
> I did some reading and found it might have something to do with
> InnoDB. but
> i dont know what that is .If that is the prob can someone please
> explain
> InnoDB concept
> --
> View this message in context: http://www.nabble.com/error-creating-
> tables-tf3300307.html#a9180499
> Sent from the Php - Database mailing list archive at Nabble.com.
>
>


--Apple-Mail-3--1027160980--

Re: error creating tables

Hello,
I tried to run your SQL query with my private database and there
wasn't any problem. You can use primary key like your PHP code because I run
your SQL in the mysql command line succesfully. Did you connect root account
to your mysql server? If the account is root, there isn't any problem. if
the accout isn't root, you should check your user privileges.


--
Haydar TUNA
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net

"Frank Flynn" , haber iletisinde sunlari
yazdi:E3FFFA30-3B52-48F5-90F2-C2CFDD6A657C@declan.com...
> Good rule - to debug try to run the same command on the command line
> of the terminal tool, you'll get better errors.
>
> But I suspect you have not said what the PRIMARY KEY is - typically
> you would say: PRIMARY KEY(f_name, l_name)
> or perhaps account whatever, it should be unique.
>
> Good Luck,
> Frank
>
> On Feb 27, 2007, at 3:58 AM, php-db-digest-help@lists.php.net wrote:
>
>> From: aconite
>> Date: February 27, 2007 3:58:23 AM PST
>> To: php-db@lists.php.net
>> Subject: error creating tables
>>
>>
>>
>> im trying to create a database in a php file.i have MySql 5.0.33
>> PHP 5.2.1
>> this is the code i have in the php file
>>
>>
>>
>> $con = mysql_pconnect("127.0.0.1","root","12345");
>> if (!$con)
>> {
>> die('Could not connect: ' . mysql_error());
>> }
>>
>>
>> if (mysql_query("CREATE DATABASE mydatabase",$con))
>> {
>> echo 'Database created ';
>> }
>> else
>> {
>> echo "Error creating database: " . mysql_error();
>> }
>>
>>
>> if(!mysql_select_db("mydatabase"))
>> {
>> die('Could not select database: mydatabase ' . mysql_error());
>> }
>>
>> echo "Database selected ";
>>
>> if (mysql_query("CREATE TABLE customer
>> (f_name VARCHAR(15) NOT NULL,
>> l_name VARCHAR(15) NOT NULL,
>> phone VARCHAR(11) ,
>> account INT UNSIGNED PRIMARY KEY)")
>> )
>> {
>> echo 'table created';
>> }
>> else
>> {
>> echo " Error creating table: " . mysql_error();
>> }
>>
>> when i view this file in the browser i get
>>
>> Database created Database selected Error creating table: Can't
>> create table
>> '.\mydatabase\customer.frm' (errno: 121)
>>
>> any idea wht the prob is??
>> I did some reading and found it might have something to do with
>> InnoDB. but
>> i dont know what that is .If that is the prob can someone please
>> explain
>> InnoDB concept
>> --
>> View this message in context: http://www.nabble.com/error-creating-
>> tables-tf3300307.html#a9180499
>> Sent from the Php - Database mailing list archive at Nabble.com.
>>
>>
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php