[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