mysql - Bogus foreign key constraint fail -

-

i error message:

error 1217 (23000) @ line 40: cannot delete or update parent row: foreign key constraint fails

... when try drop table:

drop table if exists `area`;

... defined this:

create table `area` (   `area_id` char(3) collate utf8_spanish_ci not null,   `nombre_area` varchar(30) collate utf8_spanish_ci not null,   `descripcion_area` varchar(100) collate utf8_spanish_ci not null,   primary key (`area_id`),   unique key `nombre_area_unique` (`nombre_area`) ) engine=innodb default charset=utf8 collate=utf8_spanish_ci;

the funny thing i dropped other tables in schema have foreign keys against area. actually, database empty except area table.

how can possibly have child rows if there isn't other object in database? far know, innodb doesn't allow foreign keys on other schemas, it?

(i can run rename table area something_else command :-?)

two possibilities:

  1. there table within schema ("database" in mysql terminology) has fk reference
  2. the innodb internal data dictionary out of sync mysql one.

you can see table (one of them, anyway) doing "show engine innodb status" after drop fails.

if turns out latter case, i'd dump , restore whole server if can.

mysql 5.1 , above give name of table fk in error message.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more