Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Sticky Migration from JoomlaBoard to Kunena

dies3l
Topic Author
Offline
New Member

16 years 5 months ago #33243 by dies3l

Migration from JoomlaBoard to Kunena was created by dies3l

Hello everybody!

I've the problem in subject, and really don't know how to solve it.
I have to migrate a Joomla 1.0 site with 1500 users to a new Joomla 1.5 platform, but I also have to save the forum.
I read around the web that the roadmap is

JoomlaBoard -> Fireboard 1.0.3 -> Kunena 1.0 -> Kunena 1.5

but I'm blocked on the first step, 'cos I haven't undesrtood yet how to convert sql tables, once Fireboard is installed.

I've installed Fireboard, but there's no wizard to migrate from JoomlabBoard.

Is there anybody that wants to help me (and all people like me) to migrate from JoomlaBoard to Kunena?

I know that I'm not the only person that need it, maybe an official script to make this can help the project. In my honest opinion forums with many users and threads can't migrate starting from 0, so migrate all data is the only way to migrate to Kunena!

PLEASE Help me.. I'll be glade of you, and offer a beer, I promise!

PS: Sorry for my scolar english, hope it's all understandable

Please Log in or Create an account to join the conversation.

Matias
Offline
Administrator

16 years 5 months ago - 16 years 5 months ago #33247 by Matias

Replied by Matias on topic Re: Migration from JoomlaBoard to Kunena

You just need to convert tables to FireBoard and copy all the avatars and attachments to /media/kunena/attachments/legacy

After that you're ready to install latest Kunena and you're ready.

Just unpack FB 1.0.3 and look at the PDF file for help:

3.1. JoomlaBoard
1. First, unpack the archive on your local computer. First, unpack the archive on your local
computer.
2. Go to your Joomla! Administration > Installer > Componenets
3. Select the “component_Fireboard_Forum_1.0.3.zip” package and click on “Install”.
4. After a successful installation, go to Components > Fireboard Forum
5. Once you enter the control panel, at top of the page you will notice a dialogue is asking you
weather you want to upgrade from “Joomlaboard” or a “Clean Install”. Click on “Import from
Joomlaboard” and Fireboard will automatically import your database and file structure.

Last edit: 16 years 5 months ago by Matias.

Please Log in or Create an account to join the conversation.

dies3l
Topic Author
Offline
New Member

16 years 5 months ago #33736 by dies3l

Replied by dies3l on topic Re:Migration from JoomlaBoard to Kunena

I know this procedure, but it stops at the first step.
Fireboard don't give me the choice to upgrade from jb, in the control panel, and of course, in all pages of fb admin section, nothing appears.

I discovered the query that make the conversion from line 2208 in the admin.fireboard.php (I attached a copy of it).

This function is called by line 99, that I think is the line I'd like to see..
Maybe the if condition (that I can't understand) is not satisfy, and fireboard don't show me this option. :angry:

Please help me.. :blush:

Please Log in or Create an account to join the conversation.

dies3l
Topic Author
Offline
New Member

16 years 5 months ago #33737 by dies3l

Replied by dies3l on topic Re:Migration from JoomlaBoard to Kunena

The idea is to transform the code from line 2208 into a sql query to send directly to phpmyadmin and transform all tables in Fireboard-friendly ones.. does it appear possible?

Please Log in or Create an account to join the conversation.

Matias
Offline
Administrator

16 years 5 months ago #33760 by Matias

Replied by Matias on topic Re:Migration from JoomlaBoard to Kunena

I just looked at FB 1.0.3 code and it seems that migration does not work..

This is how you should get JoomlaBoard converted to Kunena:

1) Create directories for avatars and attachments (relative to Joomla root):
* images/fbfiles/avatars
* images/fbfiles/files
* images/fbfiles/images

2) Copy avatars and attachments from JoomlaBoard to Kunena:
* components/com_joomlaboard/avatars -> images/fbfiles/avatars
* components/com_joomlaboard/uploaded/files -> images/fbfiles/files
* components/com_joomlaboard/uploaded/images -> images/fbfiles/images

3) Set directory and file permissions if needed..

4) Run SQL queries, which can be found below

5) Install Kunena 1.5.6 (K1.5.7 has a bug which prevents migration)

6) Install Kunena 1.5.7

7) Optional: export all jos_fb table definitions and send them to me (I want to see if they are OK)

Kunena should be working by now, if I didn't miss anything..

Good luck! If there are any issues, I'd like to solve them to get these instructions complete.

These are the queries (import tables to FB 1.0.0 data model).. Just remember to replace #__ with your joomla database prefix (jos_):

Click here:

Warning: Spoiler!

Code:

CREATE TABLE #__fb_messages SELECT * FROM #__sb_messages;

CREATE TABLE #__fb_attachments SELECT * FROM #__sb_attachments;

CREATE TABLE #__fb_categories SELECT * FROM #__sb_categories;

CREATE TABLE #__fb_messages_text SELECT * FROM #__sb_messages_text;

CREATE TABLE #__fb_moderation SELECT * FROM #__sb_moderation;

CREATE TABLE #__fb_sessions SELECT * FROM #__sb_sessions;

CREATE TABLE #__fb_smileys SELECT * FROM #__sb_smileys;

CREATE TABLE #__fb_subscriptions SELECT * FROM #__sb_subscriptions;

CREATE TABLE #__fb_users SELECT * FROM #__sb_users;

ALTER TABLE #__fb_categories ADD COLUMN `image` varchar(255) NOT NULL AFTER description, COMMENT='';

ALTER TABLE #__fb_messages CHANGE `id` `id` int (11)  NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (`id`);

ALTER TABLE #__fb_categories CHANGE `id` `id` int (11)  NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (`id`);

ALTER TABLE #__fb_smileys CHANGE `id` `id` int (4)  NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (`id`);

CREATE TABLE IF NOT EXISTS `#__fb_announcement` (
  `id` int(3) NOT NULL auto_increment,
  `title` tinytext,
  `sdescription` text NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  `ordering` tinyint(4) NOT NULL default '0',
  `showdate` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
);

CREATE TABLE IF NOT EXISTS `#__fb_favorites` (
  `thread` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  KEY `thread` (`thread`),
  KEY `userid` (`userid`)
);


CREATE TABLE IF NOT EXISTS `#__fb_subscriptions` (
  `thread` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `future1` int(11) default '0',
  KEY `thread` (`thread`),
  KEY `userid` (`userid`)
);


CREATE TABLE IF NOT EXISTS `#__fb_whoisonline` (
  `id` int(6) NOT NULL auto_increment,
  `userid` int(7) NOT NULL default '0',
  `time` varchar(14) NOT NULL default '0',
  `item` int(6) default '0',
  `what` varchar(255) default '0',
  `func` varchar(50) default NULL,
  `do` varchar(50) default NULL,
  `task` varchar(50) default NULL,
  `link` text,
  `userip` varchar(20) NOT NULL default '',
  `user` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

REPLACE INTO #__fb_smileys (`id`,`code`,`location`,`greylocation`,`emoticonbar`) values 
(1,'B)','cool.png','cool-grey.png',1),
(2,':(','sad.png','sad-grey.png',1),
(3,':)','smile.png','smile-grey.png',1),
(4,':-)','smile.png','smile-grey.png',0),
(5,':-(','sad.png','sad-grey.png',0),
(6,':laugh:','laughing.png','laughing-grey.png',1),
(7,':cheer:','cheerful.png','cheerful-grey.png',1),
(8,';)','wink.png','wink-grey.png',1),
(9,';-)','wink.png','wink-grey.png',0),
(10,':P','tongue.png','tongue-grey.png',1),
(12,':X','sick.png','sick-grey.png',0),
(13,':x','sick.png','sick-grey.png',0),
(14,':angry:','angry.png','angry-grey.png',1),
(15,':mad:','angry.png','angry-grey.png',0),
(16,':unsure:','unsure.png','unsure-grey.png',1),
(17,':ohmy:','shocked.png','shocked-grey.png',1),
(18,':huh:','wassat.png','wassat-grey.png',1),
(19,':dry:','ermm.png','ermm-grey.png',1),
(20,':ermm:','ermm.png','ermm-grey.png',0),
(21,':lol:','grin.png','grin-grey.png',1),
(22,':sick:','sick.png','sick-grey.png',1),
(23,':silly:','silly.png','silly-grey.png',1),
(24,':y32b4:','silly.png','silly-grey.png',0),
(25,':blink:','blink.png','blink-grey.png',1),
(26,':blush:','blush.png','blush-grey.png',1),
(27,':kiss:','kissing.png','kissing-grey.png',1),
(28,':rolleyes:','blink.png','blink-grey.png',0),
(29,':woohoo:','w00t.png','w00t-grey.png',1),
(30,':side:','sideways.png','sideways-grey.png',1),
(31,':S','dizzy.png','dizzy-grey.png',1),
(32,':s','dizzy.png','dizzy-grey.png',0),
(33,':evil:','devil.png','devil-grey.png',1),
(34,':whistle:','whistling.png','whistling-grey.png',1),
(35,':pinch:','pinch.png','pinch-grey.png',1),
(36,':p','tongue.png','tongue-grey.png',0),
(37,':D','laughing.png','laughing-grey.png',0);

UPDATE #__fb_attachments SET filelocation = replace(filelocation,'com_joomlaboard','com_fireboard');

The following user(s) said Thank You: dirkovision

Please Log in or Create an account to join the conversation.

Time to create page: 0.236 seconds