[rt-users] EffectiveId

[Walter Marchuk]

I am upgrading from RT 2.0.4 to RT 2.0.14.  I too believe it is an SQL 
issue, because if I install from scratch everything then works.  
The problem is that I need to retain the old data otherwise there is 
no upgrade.  

RT works except for new ticket creation.  Looking through mysql logs
here is what I see:
mysql> INSERT INTO Tickets (Creator, Due, Status, LastUpdatedBy, Resolved, 
Type, TimeWorked, LastUpdated, Subject, FinalPriority, Queue, Created, 
TimeLeft, InitialPriority, Owner, Priority, Starts) VALUES ('5', 
'1970-01-01 00:00:00', 'new', '5', NULL, 'ticket', '', '2002-08-01 
18:10:56', 'test', '0', '8', '2002-08-01 18:10:56', '', '0', '5', '0', 
'1970-01-01 00:00:00');
ERROR 1062: Duplicate entry '4485' for key 1


I only see one insert in the logs and then it quits..probably because of 
the error?
I've ran insertdata 2.0.4 and it doesnt seem to do much.

Thank You,
Walter. 

On Thu, 1 Aug 2002, Bruce Campbell wrote:

> On Thu, 1 Aug 2002, Walter Marchuk wrote:
> 
> > What does this mean?
> > Create couldn't set EffectiveId: No value sent to _Set!
> 
> Firstly, I don't believe that you have stated which version of RT you are
> using, nor which version of (presumably) MySQL.
> 
> Secondly, the error text comes from RT::Ticket->Create(), which seems to
> indicate that RT didn't get an id value back from SQL (ie, its a SQL
> problem, not immediately RT).
> 
> I'd look through the query log on your SQL server to see what the insert
> command supplied was, and any other debug information supplied by your SQL
> server concerning this.
> 
> > *******************************************************************************
> > Walter Marchuk				             Senior Computer Specialist
> 
> Might want to fix that line wrapping there.
> 
> Regards,
> 
> -- 
>                              Bruce Campbell                            RIPE
>                    Systems/Network Engineer                             NCC
>                  www.ripe.net - PGP562C8B1B             Operations/Security
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>