Re: 2.1.1 - 2.1.2 upgrade errors

Hi David,

Most of us were able to run the script up to the 4 last drop foreign key
stmt. Actually if I added a "commit" before them, the full script will run.
Anyhow, the decison yesterday is not to include the last 4 drop foreign key
statement and keep the old index as well as the new one till 2.2. So those
stmt were taken out from teh update script. It does seem like different
people has different problem when running the script.

Can you try
> set foreign_key_checks=0;           as Mike has suggested and just run
this stmt
> alter table SAM_ITEMGRADING_T modify column PUBLISHEDITEMID integer not
null;

and c if it works first. If it doesn't work, try this:
> alter table SAM_ITEMGRADING_T drop foreign key FKB68E6756C42AA2BC;

> drop index FKB68E6756C42AA2BC on SAM_ITEMGRADING_T;
> alter table SAM_ITEMGRADING_T modify column PUBLISHEDITEMID integer not
null;


the 1st line drop the foreign key on PublishedItemId, removing the
constraints, the 2nd line remove the index that was created for the foreign
key.

Let us know how it goes and we can work out the rest afterwards. Thanks.

Daisy

On 4/19/06, David Horwitz <dhorwitz@xxxxxxxxxxxxxx> wrote:
>
> Ok Thanks I thought it must be something like that but am loath to
> fiddle with the sam tables as my understanding of how T&Q works is
> sketchy. After yesterdays email is there an updated Update script that
> others have found to work without error on SVN somewhere?
>
> D
>
> Mike De Simone wrote:
> > David,
> >
> > From what I've seen, error 150 is a key or foreign key problem.  If the
> > field is used in a constraint clause, what I have found is that you have
> > to drop that contraint first before modifying the column the constraint
> > uses.  Similar conditions would apply if a field is an index (which I
> > think is shown by the 'KEY xxxx (`fieldname`)' syntax in mysql).
> >
> > I find the 'show create table' a very useful command in mysql.  You can
> > grab the syntax and exact constraint/key names that are used so you can
> > restore them after the mods.  Also, the 'set foreign_key_checks=0;'
> > comes in handy if you need to make changes and bypass referential
> > integrity checks.
> >
> >
> > -----------------
> > Mike De Simone
> > Director of Client Support
> > The rSmart Group
> > 602-840-7300 x106
> > icq: 161896611
> >
> > -----Original Message-----
> > From: David Horwitz [mailto:dhorwitz@xxxxxxxxxxxxxx]
> > Sent: Wednesday, April 19, 2006 7:08 AM
> > To: sakai-dev
> > Subject: 2.1.1 - 2.1.2 upgrade errors
> >
> > Hi All,
> >
> > I'm getting the following errors when I try to run the database update
> > script:
> >
> > mysql> -- SAM
> > mysql> alter table SAM_PUBLISHEDASSESSMENT_T modify column ASSESSMENTID
> > integer;
> > ERROR 1025 (HY000): Error on rename of './sakai212/#sql-7e3d_1f15' to
> > './sakai212/SAM_PUBLISHEDASSESSMENT_T' (errno: 150)
> > mysql> alter table SAM_ITEMGRADING_T modify column PUBLISHEDITEMID
> > integer not null;
> > ERROR 1025 (HY000): Error on rename of './sakai212/#sql-7e3d_1f15' to
> > './sakai212/SAM_ITEMGRADING_T' (errno: 150)
> > mysql> alter table SAM_ITEMGRADING_T modify column PUBLISHEDITEMTEXTID
> > integer not null;
> > ERROR 1025 (HY000): Error on rename of './sakai212/#sql-7e3d_1f15' to
> > './sakai212/SAM_ITEMGRADING_T' (errno: 150)
> > mysql> alter table SAM_ITEMGRADING_T modify column PUBLISHEDANSWERID
> > integer;
> > ERROR 1025 (HY000): Error on rename of './sakai212/#sql-7e3d_1f15' to
> > './sakai212/SAM_ITEMGRADING_T' (errno: 150)
> >
> >
> > Any ideas?
> >
> > David
> >
> > --
> > "It remains that, from the same principles, I now demonstrate the frame
> > of the System of the World." - Newton "Pricipia Mathematica"
> >
> > [see attachment: "dhorwitz.vcf", size: 468 bytes]
> >
> >
> > Attachments:
> >
> > dhorwitz.vcf
> > http://collab.sakaiproject.org/access/content/attachment/4771c39d-a5d7-4
> > 0ae-009a-4c7d91020018/dhorwitz.vcf
> >
> > ----------------------
> > This automatic notification message was sent by Sakai Collab
> > (http://collab.sakaiproject.org/portal) from the DG: Development site.
> > You can modify how you receive notifications at My Workspace >
> > Preferences.
> >
>
> --
> "It remains that, from the same principles, I now demonstrate the frame
> of the System of the World." - Newton "Pricipia Mathematica"
>
> [see attachment: "dhorwitz.vcf", size: 468 bytes]
>
>
> Attachments:
>
> dhorwitz.vcf
>
> http://collab.sakaiproject.org/access/content/attachment/1fb115fc-1211-427b-0092-f296738783b3/dhorwitz.vcf
>
> ----------------------
> This automatic notification message was sent by Sakai Collab (
> http://collab.sakaiproject.org/portal) from the DG: Development site.
> You can modify how you receive notifications at My Workspace >
> Preferences.
>
>


--
Daisy Flemming
SUL / ACOMP @ Stanford University
daisyf@xxxxxxxxxxxx
tel#  617-253-4472 (Tues, Wed, Thur)
tel#  617-795-0890 (Mon, Fri)
cell# 617-480-9877
[see attachment: "message0.html", size: 6472 bytes]


Attachments:

message0.html
http://collab.sakaiproject.org/access/content/attachment/e7fff0ba-c05c-4179-8065-d44a9a6b7b91/message0.html

----------------------
This automatic notification message was sent by Sakai Collab 
(http://collab.sakaiproject.org/portal) from the DG: Development site.
You can modify how you receive notifications at My Workspace > Preferences.