• 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
  • Tim Cooke
  • Devaka Cooray
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
Bartenders:
  • Carey Brown
  • Roland Mueller

2 issues: migrating from phpbb

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I was trying these days to migrate a phpbb forum to jforum. (mysql)
I used the phpbb2jforum tool which worked fine (after altering one incorrent query in the config file) (btw: it would be nice if you weren't forced to have the phpbb und jforum tables in the same database for converting, copying the tables takes long time)

However after the convertion was finished I tried to access the forum but it didn't work anymore. To be exact it threw an ArrayIndexOutOfBoundsException (-1) in SecurityCommon#groupIdAsString()
that was issue #1

to fix that I downloaded the source code and fixed the groupIdAsString() method, configured all property files, compiled the forum by my own (thank you ant ) and deployed it to my tomcat 5.
But ater that I can't event connect to the database anymore (the connection times out:

tomcat wrote:net.jforum.exceptions.DatabaseException: Error while trying to start the database: net.jforum.exceptions.DatabaseException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:468)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:78)
net.jforum.JForum.init(JForum.java:98)


To make a long story short: if I compile and deploy jforum by myself I am not able to connect to my mysql database.

I hope someone here could help me on that issues, thanks a lot

-roar
[originally posted on jforum.net by roar]
 
BWA HA HA HA HA HA HA! Tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic