[rt-users] Content broken on latest RTFM

David Gubler dg at doodle.com
Thu Feb 12 06:18:55 EST 2009


Hi all

I'm trying to migrate from an old server to a fresh installation on a 
new server.

Old server:
Debian etch
Package request-tracker3.4     Version 3.4.5
Package rtfm                   Version 2.0.3
MySQL 5.0

New Server:
Debian etch
Package request-tracker3.6     Version 3.6.1
RTFM installed from source     Version 2.4.1
MySQL 5.0

Problem:
The articles have no content, and when I try to create a new article I 
cannot enter any content because I just see the title "Content" without 
any input fields (?!?). It all works fine on the old installation.

I have read the mailing list archives, where I found several posts 
regarding a similar problem (database not properly migrated). However, I 
think I did it correctly...

What I did:
- Run migration tool (sbin/migrate-2.0-to-2.1) on old (!) server, which 
seemed to work fine and did a bunch of stuff.
- Dump the RT database, import it on new server
- Install RT 3.6, run RT 3.6 database migration script 
(/usr/sbin/rt-setup-database-3.6 |--action init --dba root 
--prompt|-for-dba-password)
- Now RT 3.6 itself seems to work fine
- Download RTFM 2.4.1, install it over the debian package 
(/usr/local/share/request-tracker3.6/)
- Migrate the RTFM database as described in the RTFM manual 
(rt-setup-database --action schema/acl/insert for version 2.1.0, 2.1.30, 
2.2RC2)

Now I have the following tables:
+-------------------------+
| Tables_in_rtdb          |
+-------------------------+
| ACL                     |
| Attachments             |
| Attributes              |
| CachedGroupMembers      |
| CustomFieldValues       |
| CustomFields            |
| FM_ArticleCFValues      |
| FM_Articles             |
| FM_ClassCustomFields    |
| FM_Classes              |
| FM_CustomFieldValues    |
| FM_CustomFields         |
| FM_ObjectTopics         |
| FM_Topics               |
| FM_Transactions         |
| GroupMembers            |
| Groups                  |
| Links                   |
| ObjectCustomFieldValues |
| ObjectCustomFields      |
| Principals              |
| Queues                  |
| ScripActions            |
| ScripConditions         |
| Scrips                  |
| Templates               |
| Tickets                 |
| Transactions            |
| Users                   |
| sessions                |
+-------------------------+

which is two more FM_-tables than before the migration, so I guess it 
has worked.

I also tried:
RTFM-2.2.1
RTFM-2.0.1
installing request-tracker 3.6.7 from source instead of the debian package

All with the same result: No "Content" for articles and no "Content" 
input fields for new articles.

Any ideas?

Can I fix this, manually if necessary?

Thanks & best regards,

David Gubler



More information about the rt-users mailing list