d tbsky wrote: > hi: > maybe your version of DBD::mysql is too old? > you can try rt3.8.1rc2, the "make testdeps" will check DBD::mysql version. > i got errors before upgrade my DBD::mysql, but i forgot the error message.
Thanks, The problem of having an empty "RT at Glance" page is now fixed. But I have problems with accents not displayed correctly (see at the end). Here is the log of my actions : a) Starting MySQL for the first time and putting a root password : service mysqld start Initializing MySQL database: Installing MySQL system tables... OK /usr/bin/mysqladmin -u root password 'xxxxxxxx' b) Install the RT 3.8.0 initial database (I believe this has to be done to create users and rights for the rt3 database in mysql ) make initialize-database /usr/bin/perl sbin/rt-setup-database --action init --dba root --prompt-for-dba-password c) Install a newer DBD::mysql module than the one from distro (the installed version was perl-DBD-MySQL-3.0007-1.fc6). This is to make the script etc/upgrade/schema.mysql-4.0-4.1.pl work. perl -MCPAN -e shell install DBD:mysql d) dump the data from RT 3.2.1 and load them in the new RT 3.8.0 oldserver> mysqldump -u rt_user --password=xxxxxxx --single-transaction \ --databases rt3 > rt3-migrate.sql newserver> mysql -u root -p --default-character-set=binary < ~/rt3-migrate.sql Enter password: e) run mysql upgrade script. I had to modify the script because some tables do not exist in the DB from 3.2.1 : diff etc/upgrade/schema.mysql-4.0-4.1-new.pl \ etc/upgrade/schema.mysql-4.0-4.1.pl 47a48,49 > ObjectCustomFields > ObjectCustomFieldValues cd rt-3.8.0 perl etc/upgrade/schema.mysql-4.0-4.1-new.pl rt3 \ rt_user xxxxxx > etc/upgrade/upgrade-mysql-4-5.sql mysql -u root -p rt3 < etc/upgrade/upgrade-mysql-4-5.sql f) upgrade schemas etc from 3.2.1 to 3.8.0 : /opt/rt3/sbin/rt-setup-database --dba root \ --prompt-for-dba-password --action upgrade => Now I have another problem : ############################### In the ticket lists diplayed on the "RT at Glance" page, the french accentued characters are replaced by a comma. I could send a new request on the list for that but I suppose it is linked to this issue of character sets ! Moreover, in some elements, french accents are correctly displayed and in some not : Not Correct : - Titles of migrated tickets - Names of people acting on the tickets - Name of attachments if they have accents for newly created tickets - Body (template) of email message to the sender in reponse for a new ticket Correct : - Body of migrated tickets - Titles of newly created tickets If someone can help ... JM Jean-Michel. -- ------------------------------------------------------------------------ Jean-michel BARBET | Tel: +33 (0)2 51 85 84 86 Laboratoire SUBATECH Nantes France | Fax: +33 (0)2 51 85 84 79 CNRS-IN2P3/Ecole des Mines/Universite | E-Mail: [EMAIL PROTECTED] ------------------------------------------------------------------------ _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com