<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Glad you found the problem.<br>
<br>
Ken<br>
<br>
Riccardo Tacconi wrote:
<blockquote
cite="mid:2afc4b3c1002030901h4a6aa2acsfc1b1ef58fc05e03@mail.gmail.com"
type="cite">This line was causing the error: `honcho_userID`
mediumint(8) unsigned NOT NULL default '11' COMMENT 'honcho'<br>
<br>
Thanks for your help.<br>
<br>
<div class="gmail_quote">On Wed, Feb 3, 2010 at 4:24 PM, Riccardo
Tacconi <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:rtacconi@gmail.com">rtacconi@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Using
perror 150 I understood that. I have found this post: <a
moz-do-not-send="true" href="http://bugs.mysql.com/bug.php?id=7831"
target="_blank">http://bugs.mysql.com/bug.php?id=7831</a> but I do not
see any difference in the filed type.
<div>
<div class="h5"><br>
<br>
<div class="gmail_quote">On Wed, Feb 3, 2010 at 4:02 PM, David
Salgado <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:david@digitalronin.com" target="_blank">david@digitalronin.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>> ERROR 1005 (HY000) at line 447: Can't create table<br>
> './intranet_dump/dept.frm' (errno: 150)<br>
<br>
</div>
Possible solution here;<br>
<br>
<a moz-do-not-send="true"
href="http://forums.mysql.com/read.php?22,19755,269293#msg-269293"
target="_blank">http://forums.mysql.com/read.php?22,19755,269293#msg-269293</a><br>
<br>
If I'm reading it correctly, it implies there might be a type mismatch<br>
between the key field and the field it's referencing - i.e. one is a<br>
signed integer and the other is unsigned (or vice versa).<br>
<br>
Hope this helps.<br>
<font color="#888888"><br>
David<br>
</font>
<div>
<div>_______________________________________________<br>
Chat mailing list<br>
<a moz-do-not-send="true" href="mailto:Chat@lists.lrug.org"
target="_blank">Chat@lists.lrug.org</a><br>
<a moz-do-not-send="true"
href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
</div>
</div>
<div>
<div class="h5">-- <br>
Riccardo Tacconi<br>
Web developer at Wolseley UK <br>
VIRTUELOGIC LIMITED (Director)<br>
<br>
<a moz-do-not-send="true"
href="http://www.linkedin.com/in/riccardotacconi" target="_blank">http://www.linkedin.com/in/riccardotacconi</a><br>
<a moz-do-not-send="true"
href="http://riccardotacconi.blogspot.com/" target="_blank">http://riccardotacconi.blogspot.com/</a><br>
<a moz-do-not-send="true" href="http://twitter.com/rtacconi"
target="_blank">http://twitter.com/rtacconi</a><br>
Linux user: #400461<br>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Riccardo Tacconi<br>
Web developer at Wolseley UK <br>
VIRTUELOGIC LIMITED (Director)<br>
<br>
<a moz-do-not-send="true"
href="http://www.linkedin.com/in/riccardotacconi">http://www.linkedin.com/in/riccardotacconi</a><br>
<a moz-do-not-send="true" href="http://riccardotacconi.blogspot.com/">http://riccardotacconi.blogspot.com/</a><br>
<a moz-do-not-send="true" href="http://twitter.com/rtacconi">http://twitter.com/rtacconi</a><br>
Linux user: #400461<br>
<pre wrap="">
<hr class="__postbox_mime_separator" size="4" width="90%">
_______________________________________________
Chat mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a>
<a class="moz-txt-link-freetext" href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a>
</pre>
</blockquote>
</body>
</html>