[rt-users] Corrupted attachment issue - RT 3.8.1

Timothy Butkiewicz tbutkiewicz at cybermind.biz
Thu Oct 9 12:27:22 EDT 2008


I am having the problem with corrupted attachments after upgrading to
3.8/3.8.1

I am using mysql 4.1.18

Here are my char_set variables:

mysql> show variables like 'c%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | utf8                       |
| character_set_results    | latin1                     |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
| collation_connection     | latin1_swedish_ci          |
| collation_database       | utf8_general_ci            |
| collation_server         | utf8_general_ci            |
| concurrent_insert        | ON                         |
| connect_timeout          | 5                          |
+--------------------------+----------------------------+
12 rows in set (0.00 sec)


I have run 

perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries with
the output attached as sql.queries

I have then run

mysql -u root -p rt3 < sql.queries
with the output of :

rt3.Groups.Instance has type VARCHAR however mapping is missing.
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt (>) at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.



Thank you
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql.queries
Type: application/octet-stream
Size: 16227 bytes
Desc: sql.queries
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081009/af4f0ffd/attachment.obj>


More information about the rt-users mailing list