new user registration locks up forum

[Migrated From Jforum.net]

Hi,

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?

Cheers

Tony
[originally posted on jforum.net by kiwi]

[Migrated From Jforum.net]

This is the first time ever. Which JForum and mysql version it is?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

I updated JForum to 2.1.7

MySQL is 3.23.58

It is still doing this... I am lost here I hoped the upgrade would fix it

Tony
[originally posted on jforum.net by kiwi]

[Migrated From Jforum.net]

MySQL is 3.23.58

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.




[originally posted on jforum.net by monroe]

[Migrated From Jforum.net]

jdk1.5.0_04 and tomcat 1.5

I am not a MySQL person and the server isn't mine so I just left things as is when I installed JForum. I wish I was running PostgreSQL...

I will try your ideas and report back. Thanks

Tony
[originally posted on jforum.net by kiwi]

[Migrated From Jforum.net]

It seems to run better with those changes but it did lock up again last week. I was on vacation so not sure which day or why.

Tony
[originally posted on jforum.net by kiwi]

[Migrated From Jforum.net]

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]

[Migrated From Jforum.net]

Yes I have the autoconnect=true in my mysql.properties

The forum is very slow - partly because I haven't been animating it and partly because of the lockup issue. So it is hard to tell if I have got this sorted or not.

cheers

Tony
[originally posted on jforum.net by kiwi]