By mbroome on

found the problem from below. heres whats happening when creating this table i receive the following:
mysql> CREATE TABLE profile_fields (
-> fid int(10) NOT NULL auto_increment,
-> title varchar(255) default NULL,
-> name varchar(128) default NULL,
-> explanation TEXT default NULL,
-> category varchar(255) default NULL,
-> page varchar(255) default NULL,
-> type varchar(128) default NULL,
-> weight tinyint(1) DEFAULT '0' NOT NULL,
-> required tinyint(1) DEFAULT '0' NOT NULL,
-> register tinyint(1) DEFAULT '0' NOT NULL,
-> visibility tinyint(1) DEFAULT '0' NOT NULL,
-> options text,
-> KEY category (category),
-> UNIQUE KEY name (name),
-> PRIMARY KEY (fid)
-> );
ERROR 1005 (HY000): Can't create table '.\webpage\profile_fields.frm' (errno: 12
1)
mysql>

ideas?

Comments

dman’s picture

dman commented

I almost missed this post, and it doesn't help anyone who may be looking for a similar answer in the future.

Could be a few things. Most of them MySQL, not Drupal.

First thing is check write permissions on the MySQL data directory. The location will depend on where you installed MySQL. You still haven't mentioned your platform, version etc, so it's really tedious guessing how to help you.

Did you compile MySQL yourself? are you using mysql commandline for everything, or could the authentication be getting mixed up with phpmyadmin or something?
Does MySQL work for other stuff in general, or is it just this one table? If so, does it already exist ? Can you DROP it?

I'd drop the entire database, ensure the mysql/data/webpage directory had also been deleted, and start again, pasting in the CREATE blocks one by one.

What you have is MySQL strangeness.

http://www.coders.co.nz/

.dan. is the New Zealand Drupal Developer working on Government Web Standards