[rt-users] Upgrading from RT 3.6.5 to 3.8.0

2009-01-10 Thread Aaron Guise 
Hi,

Was following instructions re: upgrading. upon running the upgrade script I
get the below error when hitting the 3.7.82 update.  Anyone have any ideas
where I should look in order to resolve this one?

Working with:
Type:   mysql
Host:
Name:   rt3
User:   rt_user
DBA:root
Enter RT version you're upgrading from: 3.6.5
Going to apply following upgrades:
* 3.7.1
* 3.7.3
* 3.7.10
* 3.7.15
* 3.7.19
* 3.7.81
* 3.7.82
* 3.7.85
* 3.7.86
* 3.7.87
* 3.8.0
HI THERE IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 3.7.1
Processing 3.7.3
Now populating database schema.
Processing 3.7.10
Processing 3.7.15
Processing 3.7.19
Processing 3.7.81
Now populating database schema.
[Sun Jan 11 02:29:24 2009] [crit]: DBD::mysql::st execute failed: Duplicate
key name 'CachedGroupMembers3' at /opt/rt3/sbin/../lib/RT/Handle.pm line
463. (/opt/rt3/sbin/../lib/RT.pm:375)
DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at
/opt/rt3/sbin/../lib/RT/Handle.pm line 463.

*Regards,*

*Aaron Guise
  07 854 7824
027 212 6638
aa...@guise.net.nz
 *
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Consistency check script?

2009-01-10 Thread Micah Gersten 
We lost a DB and had an old backup.  We reran all the binlogs that we
had, but there was some missing data that's causing problems now when
trying to use RT.  Mainly missing users and groups.  Does someone have a
script that can check the DB and purge anything that's not consistent
such as Watchers and requestors on tickets?

-- 


Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com