Announcement

Collapse
No announcement yet.

Importing stories from Drupal 6 does nothing

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    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:
    Chris Connaker

    Founder
    Computer Audiophile

    Comment


    • #17
      Originally posted by Chris27 View Post
      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:

      Code:
      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';

      Comment


      • #18
        Importing stories from Drupal 6 does nothing

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

        Founder
        Computer Audiophile

        Comment


        • #19
          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
          Vote for:

          - *Admin Settable Paid Subscription Reminder Timeframe*
          -
          *PM - Add ability to reply to originator only*
          - Add Admin ability to auto-subscribe users to specific channel(s)
          - Highlight the correct navigation tab when you are on a custom page
          - "Quick Route" Interface...
          - Allow to use custom icons for individual forums

          Comment


          • #20
            Originally posted by Trevor Hannant View Post
            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:

            PHP Code:
                        // 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:

            PHP Code:
                        // 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
            Last edited by aaziz; Thu 9th Aug '12, 3:53am.

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X