<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>MySQL Serialization Error</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Greetings,</FONT><FONT FACE="Times New Roman"> </FONT>
<BR><FONT SIZE=2 FACE="Arial">Last Friday we applied the 6.2.1 upgrad wizard to our 6.0.0 installation. It went without error but when trying to login to the admin page it rejects all usernames. There error logs show that that a stray "x" is appearing after the "=" sign as in: USER_INFO=x'A……'. I poked through the web CVS interface but couldn't find where the extra "x" is coming from. Likewise webusers to the site can no longer get it. Below is the error message for the Admin user, the error is identical in form for other users.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Any help is much appreciated.</FONT><FONT FACE="Times New Roman"> </FONT>
<BR><FONT SIZE=2 FACE="Arial">Thanks!</FONT><FONT FACE="Times New Roman"> </FONT>
<BR><FONT SIZE=2 FACE="Arial">Daniel</FONT><FONT FACE="Times New Roman"> </FONT>
<BR><FONT SIZE=2 FACE="Arial">org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: com.mysql.jdbc.PreparedStatement@18346a3: UPDATE CMS_USERS SET USER_DESCRIPTION='The admin user',USER_FIRSTNAME='',USER_LASTNAME='',USER_EMAIL='',USER_LASTLOGIN=1149533119007,USER_FLAGS=0,USER_INFO=x'ACED0005737200136A6176612E7574696C2E486173687461626C6513BB0F25214AE4B803000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000877080000000B0000000274002D55534552505245464552454E4345535F776F726B706C6163652D7374617274757073657474696E6773736974657400012F74002F55534552505245464552454E4345535F776F726B706C6163652D7374617274757073657474696E6773666F6C6465727400132F73697465732F4F70656E546F6F6C6B69742F78',USER_ADDRESS='',USER_TYPE=0 WHERE USER_ID='c300ba5c-01e8-3727-b305-5dcc9ccae1ee'.</FONT> </P>
<P><FONT SIZE=2 FACE="Arial">at org.opencms.db.mysql.CmsUserDriver.writeUser(CmsUserDriver.java:166)</FONT><FONT FACE="Times New Roman"><BR>
</FONT><FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsDriverManager.loginUser(CmsDriverManager.java:4121)</FONT><FONT FACE="Times New Roman"><BR>
</FONT><FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsSecurityManager.loginUser(CmsSecurityManager.java:2787)</FONT><FONT FACE="Times New Roman"><BR>
</FONT><FONT SIZE=2 FACE="Arial">at org.opencms.file.CmsObject.loginUser(CmsObject.java:1836)</FONT><FONT FACE="Times New Roman"><BR>
</FONT><FONT SIZE=2 FACE="Arial">at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:189)</FONT><FONT FACE="Times New Roman"><BR>
</FONT><FONT SIZE=2 FACE="Arial">at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:169)</FONT><FONT FACE="Times New Roman"> </FONT>
</P>
</BODY>
</HTML>