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

[Aakash Singhal]

UPDATE::
Need help ASAP please.

So basically we went in and looked at what the original table that  
sakai had created.
We still have the same error as before

Before, in the 2.4 the way we had it set up was as follows

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;

But when we looked in the 2.5.0 on how it was created, it seems like  
the same to us, but we aren't sure, is the way we are doing it  
affecting the outcome? This is the way the auto.ddl had set it up.

CREATE MEMORY TABLE CHAT2_CHANNEL(CHANNEL_ID VARCHAR(99) NOT NULL  
PRIMARY KEY,PLACEMENT_ID VARCHAR(99),CONTEXT VARCHAR(99) NOT  
NULL,CREATION_D
ATE TIMESTAMP,TITLE VARCHAR(64),DESCRIPTION VARCHAR(255),FILTERTYPE  
VARCHAR(25),FILTERPARAM INTEGER,PLACEMENTDEFAULTCHANNEL  
BOOLEAN,ENABLE_USE
R_OVERRIDE BOOLEAN,MIGRATEDCHANNELID VARCHAR(99))


It is slightly different, would it matter and so if yes, what should  
we change in ours???

Thanks,
Aakash


On Jul 22, 2009, at 11:28 AM, Aakash Singhal wrote:

> 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"
>
>
> _______________________________________________
> 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"