+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: [SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists (/showthread.php?tid=18124)
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists - El Forum - 04-26-2009
[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 existsAnyone 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
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists - El Forum - 04-26-2009
[eluser]slowgary[/eluser]
A hosting issue, maybe? Dementia? Maybe the error is wrong... could it be a permissions issue?
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists - El Forum - 04-26-2009
[eluser]Thorpe Obazee[/eluser]
[quote author="slowgary" date="1240808050"]A hosting issue, maybe? Dementia? Maybe the error is wrong... could it be a permissions issue?[/quote]
I'll vote for Dementia :p
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists - El Forum - 04-26-2009
[eluser]slowgary[/eluser]
Have you started MySQL with the --ndbcluster option? Others on the web have reported having the same problem using this option, as it does not allow the creation of new tables. That wouldn't explain though why you can create other tables, just not `user`.
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists - El Forum - 04-26-2009
[eluser]Dam1an[/eluser]
Its not a hosting issue, as I'm running this on localhost using XAMPP
And I've never seen this problem in 5+ years of dev/MySQL/phpMyAdmin
And I'm pretty sure its not demntia either
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists - El Forum - 04-27-2009
[eluser]TheFuzzy0ne[/eluser]
Have you tried clearing your browsers cache, and using a different browser?
Also, you might want to grab yourself a copy of [url="http://dev.mysql.com/downloads/gui-tools/5.0.html"]MySQL Administrator[/url] and see if that makes anything clearer.
[SOLVED, kind of] phpMyAdmin refuses to create table, claims it exists - El Forum - 04-27-2009
[eluser]Dam1an[/eluser]
@TheFuzzyOne: I tried it in Firefox and IE7, and it had the same problem (I didn't expect it to make a difference, as it failed creating it from SQL and DBForge (via CI)
The problem seemed to have somehow resolved itself, and I was able to create the table on another machine (I have Dropbox sync the htdocs and SQL folders in XAMPP between multiple machines, which has worked flawlessly for as long as I can remember)