Menu

#1 Import of sql Error

open
nobody
5
2011-07-16
2011-07-16
tishllc
No

/* Error during phpMyADMIN import CentOS/MySQL

Error

SQL query:

--
-- Table structure for table `areasuper`
--
CREATE TABLE areasuper(
as_id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
as_area_id int( 11 ) unsigned NOT NULL default '0',
as_uid int( 11 ) unsigned NOT NULL default '0',
PRIMARY KEY ( as_id ) ,
KEY as_area_id( as_area_id ) ,
KEY as_uid( as_uid ) ,
CONSTRAINT areasuper_ibfk_1 FOREIGN KEY ( as_area_id ) REFERENCES areas( area_id ) ON DELETE CASCADE ON UPDATE CASCADE ,
CONSTRAINT areasuper_ibfk_2 FOREIGN KEY ( as_uid ) REFERENCES users( user_id ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1005 - Can't create table './ptcorg_time/areasuper.frm' (errno: 150) (<a href="server_engines.php?engine=InnoDB&amp;page=Status&amp;token=0e0c09f81356b9e7c83482f1959b5766">Details...</a>)

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.