• 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
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

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]
 
Can you really tell me that we aren't dealing with suspicious baked goods? And then there is this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic