• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Tim Cooke
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • paul wheaton
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
  • Piet Souris
Bartenders:
  • Stephan van Hulst

Exception during installation

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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]
 
The City calls upon her steadfast protectors. Now for a tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic