Hi folks, yet another one on the slab of SMF-FB...

I have tried at least 8 times now to convert my current forum over to FB, I am using IPB at the moment so have done IPB->SMF->FB 1.02

So I have added the following sql queries to prep the db for the conversion
--
-- Table structure for table `mos_fb_announcement`
--

CREATE TABLE `mos_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`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_attachments`
--

CREATE TABLE `mos_fb_attachments` (
`id` int(5) NOT NULL auto_increment,
`mesid` int(7) NOT NULL default '0',
`filelocation` text NOT NULL,
`userid` int(7) default NULL,
`size` int(8) default NULL,
`width` int(4) default NULL,
`height` int(4) default NULL,
`downloads` int(7) default NULL,
PRIMARY KEY (`id`),
KEY `mesid` (`mesid`),
KEY `userid` (`userid`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_categories`
--

CREATE TABLE `mos_fb_categories` (
`id` int(11) NOT NULL auto_increment,
`parent` int(11) default '0',
`name` tinytext,
`cat_emoticon` tinyint(4) NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
`alert_admin` tinyint(4) NOT NULL default '0',
`moderated` tinyint(4) NOT NULL default '0',
`moderators` varchar(15) default NULL,
`pub_access` tinyint(4) default '1',
`pub_recurse` tinyint(4) default '1',
`admin_access` tinyint(4) default '0',
`admin_recurse` tinyint(4) default '1',
`ordering` tinyint(4) NOT NULL default '0',
`future2` int(11) default '0',
`published` tinyint(4) NOT NULL default '0',
`checked_out` tinyint(4) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`review` tinyint(4) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`description` text NOT NULL,
`id_last_msg` int(10) NOT NULL default '0',
`time_last_msg` int(11) NOT NULL default '0',
`numTopics` mediumint(8) NOT NULL default '0',
`numPosts` mediumint(8) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `parent` (`parent`),
KEY `published_pubaccess_id` (`published`,`pub_access`,`id`),
KEY `msgid` (`id_last_msg`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_favorites`
--

CREATE TABLE `mos_fb_favorites` (
`thread` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
KEY `thread` (`thread`),
KEY `userid` (`userid`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_groups`
--

CREATE TABLE `mos_fb_groups` (
`id` int(4) NOT NULL auto_increment,
`title` varchar(255) default NULL,
PRIMARY KEY (`id`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_messages`
--

CREATE TABLE `mos_fb_messages` (
`id` int(11) NOT NULL auto_increment,
`parent` int(11) default '0',
`thread` int(11) default '0',
`catid` int(11) NOT NULL default '0',
`name` tinytext,
`userid` int(11) NOT NULL default '0',
`email` tinytext,
`subject` tinytext,
`time` int(11) NOT NULL default '0',
`ip` varchar(15) default NULL,
`topic_emoticon` int(11) NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
`hold` tinyint(4) NOT NULL default '0',
`ordering` int(11) default '0',
`hits` int(11) default '0',
`moved` tinyint(4) default '0',
`ID_MSG` int(7) default NULL,
`modified_by` int(7) default NULL,
`modified_time` int(11) default NULL,
`modified_reason` tinytext,
PRIMARY KEY (`id`),
KEY `thread` (`thread`),
KEY `parent` (`parent`),
KEY `catid` (`catid`),
KEY `ip` (`ip`),
KEY `userid` (`userid`),
KEY `time` (`time`),
KEY `locked` (`locked`),
KEY `hold_time` (`hold`,`time`),
KEY `modified_by` (`modified_by`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_messages_text`
--

CREATE TABLE `mos_fb_messages_text` (
`mesid` int(11) NOT NULL default '0',
`message` text NOT NULL,
PRIMARY KEY (`mesid`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_moderation`
--

CREATE TABLE `mos_fb_moderation` (
`catid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`future1` tinyint(4) default '0',
`future2` int(11) default '0',
PRIMARY KEY (`catid`,`userid`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_sessions`
--

CREATE TABLE `mos_fb_sessions` (
`userid` int(11) NOT NULL default '0',
`allowed` text,
`lasttime` int(11) NOT NULL default '0',
`readtopics` text,
PRIMARY KEY (`userid`),
KEY `id` (`userid`),
KEY `time` (`lasttime`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_smileys`
--

CREATE TABLE `mos_fb_smileys` (
`id` int(4) NOT NULL auto_increment,
`code` varchar(12) NOT NULL default '',
`location` varchar(50) NOT NULL default '',
`greylocation` varchar(60) NOT NULL default '',
`emoticonbar` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_subscriptions`
--

CREATE TABLE `mos_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`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_users`
--

CREATE TABLE `mos_fb_users` (
`userid` int(11) NOT NULL default '0',
`view` varchar(8) NOT NULL default 'flat',
`signature` text,
`moderator` int(11) default '0',
`ordering` int(11) default '0',
`posts` int(11) default '0',
`avatar` varchar(50) default NULL,
`karma` int(11) default '0',
`karma_time` int(11) default '0',
`group_id` int(4) default '1',
`uhits` int(11) default '0',
`personalText` tinytext,
`gender` tinyint(4) NOT NULL default '0',
`birthdate` date NOT NULL default '0001-01-01',
`location` varchar(50) default NULL,
`ICQ` varchar(50) default NULL,
`AIM` varchar(50) default NULL,
`YIM` varchar(50) default NULL,
`MSN` varchar(50) default NULL,
`SKYPE` varchar(50) default NULL,
`hideEmail` tinyint(1) NOT NULL default '1',
`showOnline` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`userid`),
KEY `group_id` (`group_id`)
);

-- --------------------------------------------------------

--
-- Table structure for table `mos_fb_whoisonline`
--

CREATE TABLE `mos_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`),
KEY `userid` (`userid`),
KEY `time` (`time`)
);

-- --------------------------------------------------------

INSERT INTO `mos_fb_groups` VALUES (1, 'Registered';

INSERT INTO `mos_fb_smileys` VALUES (1, '', 'cool.png', 'cool-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (2, '', 'sad.png', 'sad-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (3, '', 'smile.png', 'smile-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (4, '', 'smile.png', 'smile-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (5, '', 'sad.png', 'sad-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (6, '', 'laughing.png', 'laughing-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (7, '', 'cheerful.png', 'cheerful-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (8, '', 'wink.png', 'wink-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (9, '', 'wink.png', 'wink-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (10, '', 'tongue.png', 'tongue-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (12, '', 'sick.png', 'sick-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (13, '', 'sick.png', 'sick-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (14, '', 'angry.png', 'angry-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (15, '', 'angry.png', 'angry-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (16, '', 'unsure.png', 'unsure-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (17, '', 'shocked.png', 'shocked-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (18, '', 'wassat.png', 'wassat-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (19, '', 'ermm.png', 'ermm-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (20, '', 'ermm.png', 'ermm-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (21, '', 'grin.png', 'grin-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (22, '', 'sick.png', 'sick-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (23, '', 'silly.png', 'silly-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (24, '', 'silly.png', 'silly-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (25, '', 'blink.png', 'blink-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (26, '', 'blush.png', 'blush-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (27, '', 'kissing.png', 'kissing-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (28, '', 'blink.png', 'blink-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (29, '', 'w00t.png', 'w00t-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (30, '', 'sideways.png', 'sideways-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (31, '', 'dizzy.png', 'dizzy-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (32, '', 'dizzy.png', 'dizzy-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (33, '', 'devil.png', 'devil-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (34, '', 'whistling.png', 'whistling-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (35, '', 'pinch.png', 'pinch-grey.png', 1);
INSERT INTO `mos_fb_smileys` VALUES (36, '', 'tongue.png', 'tongue-grey.png', 0);
INSERT INTO `mos_fb_smileys` VALUES (37, '', 'laughing.png', 'laughing-grey.png', 0);

And pretty much everything seems to work fine... Apart from the attachment conversion!

For some reason despite FB having its fbfiles directory in the right place (and in a few other choice places to be sure) it wants to upload to /components/com_fireboard/uploaded/images, naturally to aoid confusing FB I have created the directory and set chmod to 777 for all directories and recursive.

So back to the drawing board with the conversion again, everything appears to go to plan again, no error messages during the process but when I go back to the image directory there is nothing there... in the db for each item I have the following which lets me know FB *thinks* it has converted the file but the material file has not been moved across... very strange - anyhoo the csv line from the db is as follows:

"1";"5164";"/var/www/vhosts/phishybusiness.co.uk/httpdocs...";"4"

Now I know I can manually go back in and try and rename and transfer the files but I have 2200 of them and I would rather try and figure out why the images are not converting properly - it also helps the rest of the community who I am sure are equally as frustrated.

Anyhoo, apart from the images which is my last real bugbear I converted a previous attempt to 1.03 and had no real issues I could see so with any luck we can get this smf converter nailed and working for all to use at some point.


**** Added ****

I have now reconverted the site again, I noticed in the com_smftofb php file that the path to smf was set as (livesite) /forum/......

My smf directory was set as (livesite) /smf/... So I have changed this, unfortunately it was still unsuccessful though and I am without images still. I have manually added an image file but it is way too large and breaks the layout, by adding the width and height dimensions it also does nothing so back to the drawing board.

Anyone got any suggestions? My forum has been offline now since the 5th while I reconverted it all over to 1.03 and I cannot afford to switch it back on and lose any new posts made while I have this fixed (or in my case potentially have to go back and re-convert the smf forum again)

cheers

leigh