[rt-users] RT3 woes still.

[Glenn E. Sieb]

Hey Phil.. Thanks for the reply :)

I found one post that had the following info in it, but it allows me only to seemingly create a ticket.. But when I try to view said ticket I get an error saying "RT Error: Could not load ticket 75 (in this case). 

I'm not much of a DB guru :-/ (obviously), but if someone has a script or can expound on this fix, I'd be grateful.. :) I couldn't find anything else other than the stuff from rt1-to-rt2 importer which said to do: select setval('tickets_id_seq', (select max(id) from tickets)); (which also didn't fix the above error)...

Thanks in advance! If someone can help me fix this, I'll gladly send them pizza come payday! :)

Glenn

(from: http://lists.fsck.com/pipermail/rt-users/2003-April/013103.html)

>This one time, at band camp, Jesse Vincent wrote:
>>Ack. that needs to get into the upgrade notes. See the RT1 to RT2
>>importer for the explanation of what postgres is losing on.
>>you need to manually increment the sequence counters.
>
>Okay, for reference I've done the following (within psql)
>
>rt3=# select max(id) from tickets;
> max
>-----
> 365
>(1 row)
>     
>rt3=# select setval('tickets_id_seq', 366);
> setval
>--------
>    366
>(1 row)
>
>rt3=# select max(id) from transactions;
> max
>------
> 2024
>(1 row)
> 
>rt3=# select setval('transactions_id_seq', 2025);
> setval
>--------
>   2025
>(1 row)
>
>and that's fixed the immediate problem.  I guess I'll have to go through the other sequence >types and fix them up too.
>
>I think that the migration script could do this though. 

-- 
Glenn E. Sieb
System Administrator
Lumeta Corporation
+1 732 357-3514 (V)
+1 732 564-0731 (Fax) 

> -----Original Message-----
> From: rt-users-bounces at lists.fsck.com 
> [mailto:rt-users-bounces at lists.fsck.com] On Behalf Of Phil Homewood
> Sent: Thursday, November 27, 2003 10:13 PM
> To: rt-users at lists.fsck.com
> Subject: Re: [rt-users] RT3 woes still.
> 
> 
> Glenn E. Sieb wrote:
> > Nov 26 12:15:05 caduceus RT: DBD::Pg::st execute failed: ERROR:  
> > Cannot insert a  duplicate key into unique index users1 at 
> > /usr/local/lib/perl5/site_perl/5.8.0/
> > DBIx/SearchBuilder/Handle.pm line 410.  (/sw/rt/lib/RT.pm:247)
> 
> You need to update Postgres's autoincrement counters. Info on 
> this can be found in the rt-users archives; it comes up every 
> now and then.
> -- 
> Phil Homewood, Systems Janitor, http://www.SnapGear.com 
> pdh at snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630 
> SnapGear - A CyberGuard Company 
> _______________________________________________
> 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
>