• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Migration problem

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi I want to migrate my prior board DB to jforum but i got a problem.

I made forum named 'prior_board' and it's forum_id is 16

What I want to do is migrate all my prior DB to this forum using SQL and want to see it.

However, when i do test, it doesn,t work. It doesn,t appear in jforum. Is there anything I must do more?

I did following step.


(1) insert into jforum_posts(forum_id, topic_id, post_id) values ('16','9','1
1');

(2) insert into jforum_posts_text(post_id, post_text, post_subject) values ('
11','test3','subject3');



How can migrate my old DB using only SQL and can see it??

Please answer me.

Thank you~!!
[originally posted on jforum.net by honghoekim]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you will also have to update the jforum_topics table. This is the top level grouping of forums and is what the forum list page uses.

Also, you will need to restart jforum after making any manual changes to the DB. JForum uses a lot of memory cache objects to speed up information display. Manual updates don't update the memory caches.
[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for your reply but, it still doesn't work.

I updated jforum_topics table and restarted tomcat but I can not see in my forum board.

I did following steps.

insert into jforum_posts(post_id, topic_id, forum_id, user_id) values ('14','12','16','2');
insert into jforum_posts_text(post_id, post_subject, post_text) values('14','Websphere5','Websphere5');
insert into jforum_topics(topic_id, forum_id, topic_title, user_id ) values('12','16','Websphere5','2');

mysql> select post_id, topic_id, forum_id, user_id from jforum_posts;
+---------+----------+----------+---------+
| post_id | topic_id | forum_id | user_id |
+---------+----------+----------+---------+
| 1 | 1 | 1 | 2 |
| 2 | 2 | 2 | 2 |
| 3 | 3 | 2 | 2 |
| 4 | 4 | 14 | 2 |
| 5 | 5 | 15 | 2 |
| 6 | 4 | 14 | 2 |
| 7 | 6 | 14 | 2 |
| 9 | 7 | 16 | 1 |
| 10 | 8 | 16 | 1 |
| 11 | 9 | 16 | 0 |
| 12 | 10 | 16 | 2 |
| 13 | 11 | 16 | 2 |
| 14 | 12 | 16 | 2 |
+---------+----------+----------+---------+
13 rows in set (0.00 sec)

mysql> select post_id, post_subject from jforum_posts_text;
+---------+-------------------+
| post_id | post_subject |
+---------+-------------------+
| 1 | Welcome to JForum |
| 2 | noticing |
| 3 | test |
| 4 | test |
| 5 | test1 |
| 6 | Re:test |
| 7 | test test |
| 9 | WebSphere test |
| 10 | web topic2 |
| 11 | subject3 |
| 12 | WebSphere3 |
| 13 | Websphere4 |
| 14 | Websphere5 |
+---------+-------------------+
13 rows in set (0.00 sec)

mysql> select topic_id, forum_id, topic_title, user_id from jforum_topics;
+----------+----------+-------------------+---------+
| topic_id | forum_id | topic_title | user_id |
+----------+----------+-------------------+---------+
| 1 | 1 | Welcome to JForum | 2 |
| 2 | 2 | noticing | 2 |
| 3 | 2 | test | 2 |
| 4 | 14 | test | 2 |
| 5 | 15 | test1 | 2 |
| 6 | 14 | test test | 2 |
| 7 | 16 | WebSphere test | 1 |
| 8 | 16 | web topic2 | 1 |
| 9 | 16 | subject3 | 2 |
| 10 | 16 | WebSphere3 | 2 |
| 11 | 16 | Websphere4 | 2 |
| 12 | 16 | Websphere5 | 2 |
+----------+----------+-------------------+---------+
12 rows in set (0.00 sec)



What I must do more???


[originally posted on jforum.net by honghoekim]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I walking thru the PostAction insertSave code and don't see any other important tables.

Did you set all the other fields in the Forum table and the topic table properly? E.g. forum_last_post_id, forum_topics, topic_time, topic_first_post_id, topic_last_post_id, and the like?

I assume you didn't miss the "restart your app server" bit...


[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you! I solved it.

I remained other columns in jforum_topics.

It works~

Thank you
[originally posted on jforum.net by honghoekim]
 
If you believe you can tell me what to think, I believe I can tell you where to go. Go read this tiny ad!
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic