Ok I've subscribed and am attempting to import the data but have a problem. In jXComments the comment and thread data are stored in separate tables but the manual migration tool only provides a single table to get this information.
CREATE TABLE `vpo_jxcomments_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`thread_id` int(11) unsigned NOT NULL COMMENT 'The comments thread id - Foreign Key',
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Map to the user id',
`context` varchar(50) NOT NULL COMMENT 'The context of the comment',
`context_id` int(11) NOT NULL DEFAULT '0' COMMENT 'The id of the item in context',
`trackback` int(2) NOT NULL DEFAULT '0' COMMENT 'Is the comment a trackback',
`notify` int(2) NOT NULL DEFAULT '0' COMMENT 'Notify the user on further comments',
`score` int(2) NOT NULL DEFAULT '0' COMMENT 'The rating score of the commentor',
`referer` varchar(255) NOT NULL COMMENT 'The referring URL',
`page` varchar(255) NOT NULL COMMENT 'Custom page field',
`name` varchar(255) NOT NULL COMMENT 'Name of the commentor',
`url` varchar(255) NOT NULL COMMENT 'Website for the commentor',
`email` varchar(255) NOT NULL COMMENT 'Email address for the commentor',
`subject` varchar(255) NOT NULL COMMENT 'The subject of the comment',
`body` text NOT NULL COMMENT 'Body of the comment',
`created_date` datetime NOT NULL COMMENT 'When the comment was created',
`published` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Published state, allows for moderation',
`address` varchar(50) NOT NULL COMMENT 'Address of the commentor (IP, Mac, etc)',
`link` varchar(255) NOT NULL COMMENT 'The link to the page the comment was made on',
PRIMARY KEY (`id`),
KEY `idx_context` (`context`,`context_id`,`published`),
KEY `idx_user_id` (`user_id`),
KEY `pub` (`published`),
KEY `pubidx` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE `vpo_jxcomments_threads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`context` varchar(50) NOT NULL COMMENT 'The context of the comment thread',
`context_id` int(11) NOT NULL DEFAULT '0' COMMENT 'The id of the item in context',
`page_url` varchar(255) NOT NULL COMMENT 'The URL of the page for which the thread is attached',
`page_route` varchar(255) NOT NULL COMMENT 'The route of the page for which the thread is attached',
`page_title` varchar(255) NOT NULL COMMENT 'The title of the page for which the thread is attached',
`created_date` datetime NOT NULL COMMENT 'The created date for the comment thread',
`status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Thread status',
`pings` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_context` (`context`,`context_id`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
The context (comopent name e.g. content or jevents) and context_id are both blank in the comments table and are picked up from the JOIN on thread id.
I therefore did ,y own raw SQL import (which appears to work) but have a question
What does the 'usertype' field represent?
