Degree Symbol=Fatal Error, Couldn't see session
Hello everyone, I hope I didn't completely mess up the system with this one, lol.
I was editing the abstract description for a session that was still in the Admin Review queue (http://www.renderfarm.fi/session.php?id=3499) and I wanted to add a degree symbol for "360 degrees"; I did so and saved. When I looked, it had this other messed up symbol next to it that I can't describe (not a Unicode guru, here). I tried changing it again, but when I saved it gave the error that reads below:
Fatal error: Uncaught [[o:Exception]:"java.lang.Exception: Invoke failed: [[o:Session]]->setShortDescription((o:String)[o:String]). Cause: java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBD\xC3\x82\xC2...' for column 'short_description' at row 1 VM: 1.6.0_26@http://java.sun.com/" at: #-22 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) #-21 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) #-20 com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) #-19 com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) #-18 com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) #-17 com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) #-16 com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) #-15 com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) #-14 com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019) #-13 com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937) #-12 com.mysql.jdbc.PreparedStatement.execut in/mnt/rf-data-uusi/boincadm/ore_public/burp3/libraries/php-java-bridge/Java.inc on line 123
At first it didn't let me see the page for the session at all with refreshing nor with linking in from Server Status and it just gave me this error. I was able to press the back button to go back and re-edit the definition which removed the problem. However, if someone did this as well (inserted a symbol like the Degree symbol) which would cause this error and they didn't think about going back, the page would be stuck with this error until an admin could help.
This seems to be a bug that I think should be fixed to prevent such a problem.
-Onny
Actually, you can edit these things while it's still in queue.
Interesting. I closed the other bug report as "developer mistakes feature for a bug". The actual issue though is that the description table seems to be latin1 encoded. Maybe it needs to be UTF-8 then. I'll change that at some point.
Hmm, yes, that might be something that isn't quite accepted by the database. I still don't understand how you managed to edit a session that has already been put in the session queue though. I thought that once the user submits the animation via Blender / presses the upload in the webform the animation enters the queue and is out of the user's reach except for canceling via Blender.
- Jesse Kaukonen, www.jessekaukonen.net