Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Drupal 6 to Vanilla, error on Drupal Export

I'm getting an error when exporting from Drupal 6 using Vanilla porter. I use the advanced forum module in D6 so I'm wondering if that's causing problems?
7. The error I am getting is:

   select n.*, nullif(n.changed, n.created) as DateUpdated, f.tid, r.body
     from nodeforum f
     left join node n
        on f.nid = n.nid
     left join node_revisions r
        on r.nid = n.nid;Table 'databasenamegoeshere.nodeforum' doesn't exist

Error: (1024) Table 'databasenamegoeshere.nodeforum' doesn't exist

Any idea what I've done wrong? thanks!


  • Options
    R_JR_J Ex-Fanboy Munich Admin

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

  • Options
    ukcukc New
    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(
             '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(
          $Ex->ExportTable('Category', "SELECT t.tid,
            IF(h.parent = 0, -1, h.parent) AS parent,
            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(
             'body' => 'Body',
             'created' => array('Column' => 'DateInserted', 'Filter' => 'TimestampToDate'),
             'DateUpdated' => array('Column' => 'DateUpdated', 'Filter' => 'TimestampToDate'),
             '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'",
          // 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.*,
                'Html' as Format
             from comments c
             join node n
                on c.nid = n.nid", $Comment_Map);
  • Options
    LincLinc Detroit Admin

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

  • Options
    ukcukc New
    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.

Sign In or Register to comment.