<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hey guys,<br>
<br>
Im working upgrading a test installation of 3.8.0 to 3.8.1 and am
getting an error while running the mysql upgrade script. We have been
running mysql 4.1 for a while now and I didn't realize until yesterday
by reading through the list that I needed to upgrade the RT schema. I
figured that upgrading from 3.8.0 to 3.8.1 would be a good time to do
this.<br>
<br>
Upgrading the schema, I get the following error:<br>
<br>
<blockquote>ERROR 1064 (42000) at line 131: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'CHARACTER SET utf8 NULL
DEFAULT NULL' at line 1<br>
</blockquote>
The line in question is:<br>
<br>
<blockquote>ALTER TABLE Templates MODIFY Content BLOB CHARACTER SET
utf8 NULL DEFAULT NULL;<br>
</blockquote>
I read up on this error and it looks like people suggested BLOB should
be TEXT instead. Can anyone confirm this before I go and wreck the
database by accident?<br>
<br>
Thanks!<br>
<br>
-Adam<br>
<blockquote><br>
<br>
<br>
<br>
</blockquote>
</body>
</html>