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

JForum database structure compatible with 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,

I have a phpbb-based website that I'm eager to move to Java. I wonder if it's possible to port it to JForum?

Thanks
JG
[originally posted on jforum.net by Anonymous]
 
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
Yes, it is possible to migrate your phpbb database to jforum. I have done a little program to make this task. You can take a look at http://jforum-tools.dev.java.net. If you know how to access a CVS repository, the files are there.

I"ll make a little Swing program to make easier to use the convertion program.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
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
Hello Rafael,

I love jforum, and love the idea of the phpbb2 to jforum export tool. However, when I downloaded the phpbb2jforum-1.0.zip tool, I did not find any of the Unix/Linux shell script files (ie phpbb2jforum.sh) Is there an updated version of the tool that includes these? I have tried to execute the script manually but to no avail.

Thanks,
Arthur.
[originally posted on jforum.net by aenright]
 
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
Here is what I get when I try to execute it manualy (using what I found in the .bat file)



I have tried running it form my workstation as well (that has the latest Sun JRE) and I get the same error...

Thanks,
Art.
[originally posted on jforum.net by aenright]
 
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
It appears to be a class path problem, but as I am not versed in the way java works, I am at a loss. When I run


I get Failed to load Main-Class manifest attribute from mysql-connector-java-3.1.2-alpha-bin.jar. When I run java with the -cp option, it just pukes all over my console :P

Any help would be greatly appreciated.

Thanks,
Art
[originally posted on jforum.net by aenright]
 
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
There is no Main class in mysql-connector-java-3.1.2-alpha-bin.jar, That's all

and from your previous post

you have to check permissions or just do an chmod 777 mysql-connector-java-3.1.2-alpha-bin.jar
[originally posted on jforum.net by redhand]
 
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
I tried chmoding mysql-connector-java-3.1.2-alpha-bin.jar, but I still get an error... Does anyone have the bash script for executing it? I am on CentOS4 w/ Java 1.4.2

Thx,
Art
[originally posted on jforum.net by aenright]
 
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
Have you chmoded the lib directory too ?
[originally posted on jforum.net by redhand]
 
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
Ok, I chmoded the entire directory tree to 777. This is what I get:



Any suggestions?
[originally posted on jforum.net by aenright]
 
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
I still havent had any luck with this tool. I cannot get it to execute. Is there a manual set of SQL queries that can be run on the DB? I would love to get the posts imported (and I wish I had gone with JForum in the first place...)

Thanks,
Art.
[originally posted on jforum.net by aenright]
 
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
Ok, so I have ran most of the SQL queries that are in:

phpbb2jforum/bin/phpbb2jforum/mysql_queries.sql

But I am still missing some things (like the queris that need input from the java program.

Thanks in advance to anybody who can shed some light.

Thanks,
Art.
[originally posted on jforum.net by aenright]
 
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
Maybe a conflict between 'bin' command and bin set in 'java -cp bin;....."
Try to set full pathname for bin and lib in your classpath .e.g :


or rename bin directory and change it accordingly in your command line
[originally posted on jforum.net by redhand]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic