Drupal 6 to Vanilla, error on Drupal Export

Comments

• R_J Admin

  November 2014

  Just a wild guess: you either have to do a search and replace for "databasenamegoeshere" or specify anywhere the name of your database

  0
• ukc New

  December 2014 edited December 2014

  The Drupal section of the Vanilla Porter script is not functional. Here's what I have so far, and it seems to work mostly. Still needs quite a bit of testing, so take it with a pinch of salt. You need to replace the whole Drupal class in the script, starting at line 3590.

  (Don't know why the first few lines are not formatting properly. Make sure you don't include the "`" which is in front of the first class statement. That is supposed to be the forum delimiter for text formatted as code.)

  class Drupal extends ExportController {
  
     /** @var array Required tables => columns */  
     protected $_SourceTables = array();
     
     /**
      * @param ExportModel $Ex
      */
     
     protected function ForumExport($Ex) {
        $this->Ex = $Ex;
  
        // Get the characterset for the comments.
        $CharacterSet = $Ex->GetCharacterSet('comment');
        if ($CharacterSet)
           $Ex->CharacterSet = $CharacterSet;
  
        // Begin
        $Ex->BeginExport('', 'Drupal');
        
        // Users
        $User_Map = array(
           'uid'=>'UserID',
           'name'=>'Name',
           'Password'=>'Password',
           'mail'=>'Email',
           'photo'=>'Photo',
           'created'=>array('Column' => 'DateInserted', 'Filter' => 'TimestampToDate'),
           'login'=>array('Column' => 'DateLastActive', 'Filter' => 'TimestampToDate')
        );   
        $Ex->ExportTable('User', "
           select u.*,
              nullif(concat('drupal/', u.picture), 'drupal/') as photo,
              concat('md5$$', u.pass) as Password,
              'Django' as HashMethod
           from :_users u
           where uid > 0", $User_Map);
        
        // Signatures.
        $UserMeta_Map = array(
            'uid' => 'UserID',
            'Name' => 'Name',
            'signature' => 'Value');
        $Ex->ExportTable('UserMeta', "
           select u.*, 'Plugins.Signatures.Sig' as Name
           from :_users u
           where uid > 0", $UserMeta_Map);
        
        // Roles.
        $Role_Map = array(
            'rid' => 'RoleID',
            'name' => 'Name');
        $Ex->ExportTable('Role', "select r.* from :_role r", $Role_Map);
        
        // User Role.
        $UserRole_Map = array(
            'uid' => 'UserID',
            'rid' => 'RoleID');
        $Ex->ExportTable('UserRole', "
           select * from :_users_roles", $UserRole_Map);
  
        // Categories
        $Category_Map = array(
           'tid'=>'CategoryID',
           'parent'=>'ParentCategoryID',
           'name'=>'Name',
           'description'=>'Description',
           'Depth'=>'Depth'
        );
        $Ex->ExportTable('Category', "SELECT t.tid,
          IF(h.parent = 0, -1, h.parent) AS parent,
          t.name,
          t.description,
          IF(h.parent = 0, 1, 2) AS Depth
          FROM :_term_data t
          JOIN :_vocabulary v ON t.vid = v.vid
          JOIN :_term_hierarchy h ON t.tid = h.tid
          WHERE v.module = 'forum'", $Category_Map);
  
        // Discussions
        $Discussion_Map = array(
           'nid'=>'DiscussionID',
           'tid'=>'CategoryID',
           'uid'=>'InsertUserID',
           'title'=>'Name',
           'body' => 'Body',
           'created' => array('Column' => 'DateInserted', 'Filter' => 'TimestampToDate'),
           'DateUpdated' => array('Column' => 'DateUpdated', 'Filter' => 'TimestampToDate'),
           'Format'=>'Format',
           'sticky' => 'Announce'
        );
        $Ex->ExportTable('Discussion', "SELECT n.*, nullif(n.changed, n.created) as DateUpdated, t.tid, r.body,
          'Html' AS Format,
          0 AS Closed,
          FROM_UNIXTIME(n.created) AS DateInserted
          FROM :_node n
          JOIN :_node_revisions r ON n.nid = r.nid AND n.vid = r.vid
          JOIN :_term_node t ON n.nid = t.nid
          WHERE n.type = 'forum'",
          $Discussion_Map);
              
        // Comments.
        $Comment_Map = array(
            'cid' => 'CommentID',
            'nid' => 'DiscussionID',
            'uid' => 'InsertUserID',
            'comment' => array('Column' => 'Body'),
            'hostname' => 'InsertIPAddress',
            'timestamp' => array('Column' => 'DateInserted', 'Filter' => 'TimestampToDate')
        );
        $Ex->ExportTable('Comment', "
           select c.*,
              n.title,
              'Html' as Format
           from comments c
           join node n
              on c.nid = n.nid", $Comment_Map);
        
        $Ex->EndExport();
     }
  

  0
• Linc Admin

  December 2014

  @ukc Can you point out what needed to be changed?

  0
• ukc New

  December 2014 edited December 2014

  If you look at the first post, the error that was being thrown was "Error: (1024) Table 'databasenamegoeshere.nodeforum' doesn't exist", and that is as expected - there is no "nodeforum" table in a Drupal 6 database, so the query in the Discussion section can't work.

  Similarly, there is no node_comments table in a Drupal 6 database.

  Also, the category import wasn't working correctly in my case because it was sucking all the taxonomy terms out, rather than just forum names.

  I want to point out that the credit for this need to go to the Plantary Ponderings blog for a post, I think from 2011, discussing migrations from Drupal to Vanilla.

  Did you fix the code formatting on my post, by the way? If so, thanks.

  0