• 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
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven

Issue 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
I tired to install jforum-2.1.8 and the installation fails. I have already opened a Bug. Can someone encouter similar issue or aware of fix for the same. Pls let me know.

Here is the link

http://www.jforum.net/jira/browse/JF-845

Thx.

[originally posted on jforum.net by adsmantra]
 
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
Most likely this is not a jForum bug since the error is occurring on a fairly simple prepared insert statement.

Judging from the error info, it looks like your JDBC driver is not properly translating the date into SQL that your MySQL server understands.

Since you have an old version of Java and MySQL, you may need to find a matching older JDBC driver who's setTimestamp method will set the value to match your's MySQL's expectation of a DateTime field.

FWIW, MySQL is infamous for changing the way it deals with Dates and other "specialty" fields... mostly to move from it's non-standard methods to more standards based.
[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
Thx for the reply. Will try to see whether I can downgrade the jdbc driver or upgrade the JVM.
[originally posted on jforum.net by adsmantra]
 
This tiny ad will self destruct in five seconds.
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic