Welcome Guest, Not a member yet? Register   Sign In
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists
#1

[eluser]Dam1an[/eluser]
Hi everybody,
I tried to create a new table (called users) in my database using phpMyAdmin, and it comes back saying a table with that name already exists, but it doesn't
I even tried creating a new database, and tried creating the same table, and got the same error

I can create tables with other names
I've also tried restarting MySQL/Apache but no luck

Here's what phpMyAdmin comes back with
Code:
Error

SQL query:

CREATE TABLE `project_trackr`.`users` (
`id` INT( 32 ) NOT NULL ,
`first_name` VARCHAR( 64 ) NOT NULL ,
`last_name` VARCHAR( 64 ) NOT NULL ,
`email` VARCHAR( 255 ) NOT NULL ,
`password` VARCHAR( 32 ) NOT NULL ,
`created_on` DATETIME NULL ,
`updated_on` DATETIME NULL ,
`accessed_on` DATETIME NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM

MySQL said: Documentation
#1050 - Table 'users' already exists

Anyone come accross something like this, and know how to solve it?

Any help is greatly appreciated

Update: I've also tried creating the users table manually using SQL, and using the CI DB forge class, but both methods failed Sad


Messages In This Thread
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists - by El Forum - 04-26-2009, 02:24 PM



Theme © iAndrew 2016 - Forum software by © MyBB