[rt-devel] Encoding error after dump import

mixo mixo at coza.net.za
Tue Aug 19 09:32:00 EDT 2003


I have just imported data from RT 2.0.13 into two instances of RT 3.0.4.
The one instance has Mysql and the other Pg. When I trying to view ticket
with id 8000, I got "System error " as detailed in the attachement
"rt3-enc-error.html". But, when viewing the ticket in the old rt (2.0.13),
the attachement as displayed as expected. Another thing, is there a reason
Mysql and Pg have different content encodings, with Pg being empty and Mysql
"NULL"?


++++++++++++++++Pg++++++++++++++++++++++++++++++
rt3=# select Attachments.ContentEncoding, 
Attachments.ContentType,Attachments.Created,Attachments.TransactionId 
from Attachments where Attachments.TransactionId=36688;
 contentencoding |      contenttype      |       created       | 
transactionid
-----------------+-----------------------+---------------------+---------------
 none            | text/plain            | 2002-01-08 13:20:21 |         
36688
 none            | text/html             | 2002-01-08 13:20:21 |         
36688
 none            | text/plain            | 2002-01-08 13:20:21 |         
36688
                 | multipart/alternative | 2002-01-08 13:20:20 |         
36688
                 | multipart/mixed       | 2002-01-08 13:20:20 |         
36688
(5 rows)
++++++++++++++++++++++++++++++++++++++++++++++++

++++++++++++++MySQL++++++++++++++++++++++++++++
mysql> select Attachments.ContentEncoding, 
Attachments.ContentType,Attachments.Created from Attachments where 
Attachments.TransactionId=36688;
+-----------------+-----------------------+---------------------+
| ContentEncoding | ContentType           | Created             |
+-----------------+-----------------------+---------------------+
| NULL            | multipart/mixed       | 2002-01-08 13:20:20 |
| NULL            | multipart/alternative | 2002-01-08 13:20:20 |
| none            | text/plain            | 2002-01-08 13:20:21 |
| none            | text/html             | 2002-01-08 13:20:21 |
| none            | text/plain            | 2002-01-08 13:20:21 |
+-----------------+-----------------------+---------------------+
5 rows in set (0.00 sec)

mysql> select Transactions.id,Transactions.Type from Transactions where 
Transactions.Ticket=8000;
+-------+---------+
| id    | Type    |
+-------+---------+
| 36688 | Create  |
| 36749 | Take    |
| 36750 | Comment |
| 36751 | Status  |
+-------+---------+
4 rows in set (0.00 sec)
(this is the same for Pg)
++++++++++++++++++++++++++++++++++++++++++++++
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20030819/36a6df4c/rt3-enc-error.html


More information about the Rt-devel mailing list