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
sql.queries (15.8 KB)