[opencms-dev] MySQL Serialization Error

Mekonnen, Daniel daniel.mekonnen at progeny.net
Mon Jun 5 21:56:01 CEST 2006


Greetings, 
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.
Any help is much appreciated. 
Thanks! 
Daniel 
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing
the following query: com.mysql.jdbc.PreparedStatement at 18346a3: UPDATE
CMS_USERS SET USER_DESCRIPTION='The admin
user',USER_FIRSTNAME='',USER_LASTNAME='',USER_EMAIL='',USER_LASTLOGIN=11
49533119007,USER_FLAGS=0,USER_INFO=x'ACED0005737200136A6176612E7574696C2
E486173687461626C6513BB0F25214AE4B803000246000A6C6F6164466163746F7249000
97468726573686F6C6478703F4000000000000877080000000B0000000274002D5553455
2505245464552454E4345535F776F726B706C6163652D7374617274757073657474696E6
773736974657400012F74002F55534552505245464552454E4345535F776F726B706C616
3652D7374617274757073657474696E6773666F6C6465727400132F73697465732F4F706
56E546F6F6C6B69742F78',USER_ADDRESS='',USER_TYPE=0 WHERE
USER_ID='c300ba5c-01e8-3727-b305-5dcc9ccae1ee'. 
at org.opencms.db.mysql.CmsUserDriver.writeUser(CmsUserDriver.java:166) 
at org.opencms.db.CmsDriverManager.loginUser(CmsDriverManager.java:4121)

at
org.opencms.db.CmsSecurityManager.loginUser(CmsSecurityManager.java:2787
) 
at org.opencms.file.CmsObject.loginUser(CmsObject.java:1836) 
at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:189) 
at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:169) 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060605/59b1edc0/attachment.htm>


More information about the opencms-dev mailing list