[rt-users] Database upgrade issue from RT 3.6.3 to RT 3.8.4

[Varun]

Hello Joop

 

Well its okay . But still thanks a ton for guiding me for this. I was just
thinking that I might have not been upgraded database correctly. But thanks
for letting me know about real problem.

 

Regards

Varun Vyas

 

  _____  

From: Joop [mailto:JoopvandeWege at mococo.nl] 
Sent: Wednesday, November 04, 2009 1:01 PM
To: Varun
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Database upgrade issue from RT 3.6.3 to RT 3.8.4

 

Varun wrote: 

Hello Joop

 

As per your guessing you are right I am facing problem of corruption in sql
query when I upgraded from 3.6.3 to 3.8.6 application is working fine but
when I want to look at page where custom fields are or want to see the page
where tickets basics are there. I am not able to go that page and RT doesn't
seem too returned with that page and goes in unending loop of query firing
and also I get the query which I posted to you which is not firing as per
your suggestion. So can you can help me in how to fix this problem I am not
been able to find any solution for it.

 

Any help is highly appreciated.

I'm sorry but that is something that changed in RT and I'm not able to help
you there. Basically what I wrote to rt-devel is that probably there is a
mix up in column names and the query should read:



SELECT   main.*
  FROM   Attributes main
 WHERE       (main.OBJECTID = '221')
         AND (main.Name = 'BasedOn')
         AND (main.ObjectType = 'RT::CustomField')



instead of:





SELECT   main.*
  FROM   Attributes main
 WHERE       (main.Content = '221')
         AND (main.Name = 'BasedOn')
 
Regards,
 
Joop
 
         AND (main.ObjectType = 'RT::CustomField')
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20091104/d7d616d0/attachment.htm>