This has been bugging me for a while and I can't figure the solution. When a new user registers the whole forum locks up until I restart tomcat. I am sure this must be a MySQL issue. Any body else seen this?
That's a very old version of MySQL and even though there are some 323 version files in the distro, I doubt anyone has tested against that.
Some things to try:
Downgrade your MySQL JDBC driver in the lib directory. There may be issues using the new driver with an old DB.
In the /WEB-INF/config/database/mysql directory, rename the mysql.sql file to something and replace it with the mysql_323.sql file.
In the mysql.properties (same directory) and in your jforum_custom.conf file, make sure that the database.support.subqueries property is false.
I'm almost afraid to ask what what version of Java VM and app server you are running on.... the distro probably has at least some Java 1.4 dependencies, and there may be some Java 1.5 specific calls as well.
Only thing more I can think of is to make sure that there is a autoReconnect option on your JDBC url, e.g., autoReconnect=true. I seem to remember that older MySQL DB's needed this.
Then again, it could just be that the network imps sensed a lack of support aura and descended upon your server. Once the support aura was returned, they got chased off to another unprotected site. [originally posted on jforum.net by monroe]