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