Importing stories from Drupal 6 does nothing

[Chris27]

I received the following error message when attempting to use the CMS import.

ImpEx Database error


mysql error: Invalid SQL:
SELECT node.nodeid
FROM cms_article AS article
INNER JOIN cms_node AS node ON (article.contentid = node.contentid AND node.contenttypeid = 24)
WHERE article.importcmscontentid <> 0



mysql error: Unknown column 'article.importcmscontentid' in 'where clause'


mysql error number: 1054


Date: Thursday 15th 2012f March 2012 12:00:23 AM
Database: computer_vB
MySQL error:

[Jake Bunce]

I received the following error message when attempting to use the CMS import.

ImpEx Database error


mysql error: Invalid SQL:
SELECT node.nodeid
FROM cms_article AS article
INNER JOIN cms_node AS node ON (article.contentid = node.contentid AND node.contenttypeid = 24)
WHERE article.importcmscontentid <> 0



mysql error: Unknown column 'article.importcmscontentid' in 'where clause'


mysql error number: 1054


Date: Thursday 15th 2012f March 2012 12:00:23 AM
Database: computer_vB
MySQL error:

I encountered similar errors with the Wordpress CMS importer. ImpEx is failing to creating the import columns in the vB database. I fixed it by manually creating the columns. Here are the queries I had to run to create all of the CMS import columns:

ALTER TABLE cms_article ADD importcmscontentid INT UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE cms_node ADD importcmsnodeid INT UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE cms_nodeinfo ADD importid INT UNSIGNED NOT NULL DEFAULT '0';

[Chris27]

Importing stories from Drupal 6 does nothing

Excellent. I'll give it a shot. Thanks Jake.

[Trevor Hannant]

I've raised a bug for this here:

http://tracker.vbulletin.com/browse/IMPX-412

Something is stopping an option from displaying within Impex which then causes the article import to fail - I've referred it up the line to see if we can get Developer time allocated to this

[aaziz]

I've raised a bug for this here:

http://tracker.vbulletin.com/browse/IMPX-412

Something is stopping an option from displaying within Impex which then causes the article import to fail - I've referred it up the line to see if we can get Developer time allocated to this

Sorry to bring this up again, but I've similar bug (though not the same as this one), and also found a fix.

impex\systems\drupal_6_cms\004.php:

            // Start up the table
            $displayobject->update_basic('title', $displayobject->phrases['import_cms_article']);
            $displayobject->update_html($displayobject->do_form_header('index',substr(get_class($this) , -3)));
            $displayobject->update_html($displayobject->make_hidden_code(substr(get_class($this) , -3),'WORKING'));
            $displayobject->update_html($displayobject->make_table_header($displayobject->phrases['import_cms_article']));

            // Ask some questions
            $displayobject->update_html($displayobject->make_input_code($displayobject->phrases['units_per_page'], 2000));  // <-- THIS LINE IS MISSING A PARAMETER... NAMELY THE "name" OF THE INPUT ELEMENT
            $displayobject->update_html($displayobject->make_select_input_code('Enter the node type you want to import as an article', 'node_type',
                               $this->drupal6_cms_get_node_types(
                                    $Db_source,
                                    $sessionobject->get_session_var('sourcedatabasetype'),
                                    $sessionobject->get_session_var('sourcetableprefix')
                               )
                        )
                ); 

Should become:

            // Start up the table
             $displayobject->update_basic('title', $displayobject->phrases['import_cms_article']);
             $displayobject->update_html($displayobject->do_form_header('index',substr(get_class($this) , -3)));
             $displayobject->update_html($displayobject->make_hidden_code(substr(get_class($this) , -3),'WORKING'));
             $displayobject->update_html($displayobject->make_table_header($displayobject->phrases['import_cms_article']));
 
             // Ask some questions
             $displayobject->update_html($displayobject->make_input_code($displayobject->phrases['units_per_page'],  'perpage', 2000)); // <-- ADD THE 'perpage' INPUT ELEMENT NAME HERE
             $displayobject->update_html($displayobject->make_select_input_code('Enter the node type you want to import as an article', 'node_type',
                                $this->drupal6_cms_get_node_types(
                                     $Db_source,
                                     $sessionobject->get_session_var('sourcedatabasetype'),
                                     $sessionobject->get_session_var('sourcetableprefix')
                                )
                         )
                 ); 

I'm going to create an issue and suggest that as the patch, but though everyone should know This post led me to check the output code since the "units per page" wasn't actually displaying at all with a value.

EDIT: Issue created here: http://tracker.vbulletin.com/browse/IMPX-415