• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Exception during installation

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I'm getting the following exception when installing JForum 2.1.8 via the web installer:



This is happening on a Vista Ultimate x86 machine + JDK 6 + Tomcat 6 + MySQL 5.0.45. Any ideas how to fix it?
[originally posted on jforum.net by Ree]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A quick guess is that there is a missmatch between your MySQL database encoding and your Java encoding settings. Make sure that your tables/database is set to at least UTF-8.
[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MySQL server and database charsets are set to utf8.

I also ran

on an empty database I created for JForum.
[originally posted on jforum.net by Ree]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A google for this error showed that it's a common issue with some recent 5.0 MySQL JDBC driver versions. Try updating your JDBC driver jar to the latest from MySQL.

Here's a good thread talking about the problem.

http://forums.mysql.com/read.php?39,139534,139534#msg-139534
[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you, ugrading to the latest MySQL connector fixed the problem.

I'm wondering why JForum developers are still using mysql-connector-java-5.0.3-bin.jar which is over a year old?
[originally posted on jforum.net by Ree]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Helping support guys have job security... wait.. nobody gets paid for this... :lol:

Just simply being human and having other jobs to work at and it works fine on the developer/testers boxes.

But, fwiw, put a Jira issue in on it so that it is less likely to fall thru the cracks during the next release.
[originally posted on jforum.net by monroe]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!