[Building Sakai] Unable to delete table during conversion from 2.4 to 2.5.0 script running

[Aakash Singhal]

I have gotten past that problem, but it has only seemed to build up  
upon it now. All I had to do was put in the following part before I  
did the rest.

SET FOREIGN_KEY_CHECKS = 0;


Now I get another error that does not make any sense, and I am doing  
the same things as before.
The error is:

ERROR 1005 (HY000): Can't create table './sakai/ 
chat2_channel.frm' (errno: 150)


On Jul 22, 2009, at 9:49 AM, aakashsinghal wrote:

>
> ERROR 1217 (23000): Cannot delete or update a parent row: a foreign  
> key
> constraint fails
>
> I am getting this error around line 102 or 103 for the conversion  
> script.
> Apparently the table exists from when we first run sakai to have it  
> set up
> and everything. And on this part of the script, we have to drop it.  
> So we
> decided to try to push each line in and see what happens and this is  
> what
> happens.
>
> ERROR 1217 (23000): Cannot delete or update a parent row: a foreign  
> key
> constraint fails\
> mysql> CREATE TABLE `CHAT2_CHANNEL` (
>    -> `CHANNEL_ID` varchar(99) NOT NULL default '',
>    -> `CONTEXT` varchar(36) NOT NULL default '',
>    -> `CREATION_DATE` datetime default NULL,
>    -> `title` varchar(64) default NULL,
>    -> `description` varchar(255) default NULL,
>    -> `filterType` varchar(25) default NULL,
>    -> `filterParam` int(11) default NULL,
>    -> `contextDefaultChannel` tinyint(1) default NULL,
>    -> `ENABLE_USER_OVERRIDE` tinyint(1) default NULL,
>    -> `migratedChannelId` varchar(99) default NULL,
>    -> PRIMARY KEY  (`CHANNEL_ID`),
>    -> KEY `CHAT2_CHNL_CNTXT_I` (`CONTEXT`),
>    -> KEY `CHAT2_CHNL_CNTXT_DFLT_I`  
> (`CONTEXT`,`contextDefaultChannel`)
>    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> ERROR 1050 (42S01): Table 'chat2_channel' already exists
>
> I even tried to drop it here and it didn't work.
>
> Then I went into the database itself and tried to delete it myself.
>
> mysql> drop table CHAT2_CHANNEL;
> ERROR 1217 (23000): Cannot delete or update a parent row: a foreign  
> key
> constraint fails
>
> I have made sure I am accessing the right database, Anyone that can  
> help,
> thanks!
> -- 
> View this message in context: http://www.nabble.com/Unable-to-delete-table-during-conversion-from-2.4-to-2.5.0-script-running-tp24606908p24606908.html
> Sent from the Sakai - Development mailing list archive at Nabble.com.
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org 
>  with a subject of "unsubscribe"