Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product
Vanilla 2.6 is here! It includes security fixes and requires PHP 7.0. We have therefore ALSO released Vanilla 2.5.2 with security patches if you are still on PHP 5.6 to give you additional time to upgrade.
Please upgrade to 2.3 here. The 2.2 and earlier branches are no longer being updated.

Exporting Vbulletin 3.x Problem

This discussion is related to the Vanilla Porter addon.

I have a fresh install of Vanilla 2 on my server and I'm trying to import a rather large database from vbulletin 3.x. The porter finishes the export from vbulletin successfully but it seems to be missing a lot of posts. I completed the import into Vanilla and all of the threads are there but no comments. Strangely enough it shows the number of comments in the discussion but there is nothing beyond the original post. Here's the output from the porter:

Export Started: 2013-09-15 01:48:50
Exported Table: User (13128 rows, 00:05.61)
Exported Table: Role (11 rows, 00:00.01)
Exported Table: UserRole (13152 rows, 00:00.36)
Exported Table: UserMeta (16352 rows, 00:01.16)
Exported Table: Category (19 rows, 00:00.01)
Exported Table: Discussion (20796 rows, 00:31.98)
Exported Table: Comment (0 rows, 00:16.21)
Exported Table: UserDiscussion (0 rows, 00:00.00)
Exported Table: Activity (971 rows, 00:00.21)
Exported Table: Media (74 rows, 00:05.46)
Export Completed: 2013-09-15 01:49:52
Elapsed Time: 01:01.58

Any help is appreciated.

Comments

  • x00x00 MVP
    edited September 2013

    do

    SHOW TABLES;

    In vb database.

    you can post the result between three tildes like so

    ~~~
    [result goes here]
    ~~~
    

    grep is your friend.

    UnderDoghgtonight
  • tbl_access
    tbl_adminhelp
    tbl_administrator
    tbl_adminlog
    tbl_adminmessage
    tbl_adminutil
    tbl_album
    tbl_albumpicture
    tbl_albumupdate
    tbl_announcement
    tbl_announcementread
    tbl_attachment
    tbl_attachmentpermission
    tbl_attachmenttype
    tbl_attachmentviews
    tbl_avatar
    tbl_bbcode
    tbl_bookmarksite
    tbl_calendar
    tbl_calendarcustomfield
    tbl_calendarmoderator
    tbl_calendarpermission
    tbl_cpsession
    tbl_cron
    tbl_cronlog
    tbl_customavatar
    tbl_customprofilepic
    tbl_datastore
    tbl_deletionlog
    tbl_discussion
    tbl_discussionread
    tbl_editlog
    tbl_event
    tbl_externalcache
    tbl_faq
    tbl_forum
    tbl_forumpermission
    tbl_forumprefixset
    tbl_forumread
    tbl_groupmessage
    tbl_groupmessage_hash
    tbl_groupread
    tbl_holiday
    tbl_humanverify
    tbl_hvanswer
    tbl_hvquestion
    tbl_icon
    tbl_imagecategory
    tbl_imagecategorypermission
    tbl_impexerror
    tbl_infernoshout
    tbl_infernoshoutsessions
    tbl_infernoshoutusers
    tbl_infraction
    tbl_infractionban
    tbl_infractiongroup
    tbl_infractionlevel
    tbl_language
    tbl_mailqueue
    tbl_moderation
    tbl_moderator
    tbl_moderatorlog
    tbl_notice
    tbl_noticecriteria
    tbl_noticedismissed
    tbl_passwordhistory
    tbl_paymentapi
    tbl_paymentinfo
    tbl_paymenttransaction
    tbl_phrase
    tbl_phrasetype
    tbl_picture
    tbl_picturecomment
    tbl_picturecomment_hash
    tbl_plugin
    tbl_pm
    tbl_pmreceipt
    tbl_pmtext
    tbl_pmthrottle
    tbl_podcast
    tbl_podcastitem
    tbl_poll
    tbl_pollvote
    tbl_post
    tbl_postedithistory
    tbl_posthash
    tbl_postindex
    tbl_postlog
    tbl_postparsed
    tbl_prefix
    tbl_prefixpermission
    tbl_prefixset
    tbl_product
    tbl_productcode
    tbl_productdependency
    tbl_profileblockprivacy
    tbl_profilefield
    tbl_profilefieldcategory
    tbl_profilevisitor
    tbl_ranks
    tbl_reminder
    tbl_reputation
    tbl_reputationlevel
    tbl_rssfeed
    tbl_rsslog
    tbl_search
    tbl_session
    tbl_setting
    tbl_settinggroup
    tbl_sigparsed
    tbl_sigpic
    tbl_smilie
    tbl_socialgroup
    tbl_socialgroupcategory
    tbl_socialgroupicon
    tbl_socialgroupmember
    tbl_socialgrouppicture
    tbl_spamlog
    tbl_stats
    tbl_strikes
    tbl_style
    tbl_subscribediscussion
    tbl_subscribeevent
    tbl_subscribeforum
    tbl_subscribegroup
    tbl_subscribethread
    tbl_subscription
    tbl_subscriptionlog
    tbl_subscriptionpermission
    tbl_tachyforumcounter
    tbl_tachyforumpost
    tbl_tachythreadcounter
    tbl_tachythreadpost
    tbl_tag
    tbl_tagsearch
    tbl_tagthread
    tbl_template
    tbl_templatehistory
    tbl_thread
    tbl_threadrate
    tbl_threadread
    tbl_threadredirect
    tbl_threadviews
    tbl_upgradelog
    tbl_user
    tbl_useractivation
    tbl_userban
    tbl_userchangelog
    tbl_usercss
    tbl_usercsscache
    tbl_userfield
    tbl_usergroup
    tbl_usergroupleader
    tbl_usergrouprequest
    tbl_userlist
    tbl_usernote
    tbl_userpromotion
    tbl_usertextfield
    tbl_usertitle
    tbl_vbfields
    tbl_visitormessage
    tbl_visitormessage_hash
    tbl_word
    
    UnderDoghgtonight
  • x00x00 MVP
    edited September 2013

    can you

    DESCRIBE tbl_post;
    DESCRIBE tbl_thread;
    DESCRIBE tbl_deletionlog;
    

    grep is your friend.

    hgtonight
  • tbl_post

    postid  int(10) unsigned    NO  PRI NULL    auto_increment
    threadid    int(10) unsigned    NO  MUL 0    
    parentid    int(10) unsigned    NO      0    
    username    varchar(100)    NO           
    userid  int(10) unsigned    NO  MUL 0    
    title   varchar(250)    NO  MUL      
    dateline    int(10) unsigned    NO      0    
    pagetext    mediumtext  YES     NULL     
    allowsmilie smallint(6) NO      0    
    showsignature   smallint(6) NO      0    
    ipaddress   varchar(15) NO           
    iconid  smallint(5) unsigned    NO      0    
    visible smallint(6) NO      0    
    attach  smallint(5) unsigned    NO      0    
    infraction  smallint(5) unsigned    NO      0    
    reportthreadid  int(10) unsigned    NO      0    
    importthreadid  bigint(20)  NO      0    
    importpostid    bigint(20)  NO  MUL 0    
    

    tbl_thread

    threadid    int(10) unsigned    NO  PRI NULL    auto_increment
    title   varchar(250)    NO  MUL      
    firstpostid int(10) unsigned    NO      0    
    lastpostid  int(10) unsigned    NO      0    
    lastpost    int(10) unsigned    NO  MUL 0    
    forumid smallint(5) unsigned    NO  MUL 0    
    pollid  int(10) unsigned    NO  MUL 0    
    open    smallint(6) NO      0    
    replycount  int(10) unsigned    NO      0    
    hiddencount int(10) unsigned    NO      0    
    deletedcount    int(10) unsigned    NO      0    
    postusername    varchar(100)    NO           
    postuserid  int(10) unsigned    NO  MUL 0    
    lastposter  varchar(100)    NO           
    dateline    int(10) unsigned    NO  MUL 0    
    views   int(10) unsigned    NO      0    
    iconid  smallint(5) unsigned    NO      0    
    notes   varchar(250)    NO           
    visible smallint(6) NO      0    
    sticky  smallint(6) NO      0    
    votenum smallint(5) unsigned    NO      0    
    votetotal   smallint(5) unsigned    NO      0    
    attach  smallint(5) unsigned    NO      0    
    similar varchar(55) NO           
    importthreadid  bigint(20)  NO  MUL 0    
    importforumid   bigint(20)  NO      0    
    prefixid    varchar(25) NO  MUL      
    taglist mediumtext  YES     NULL     
    

    tbl_deletionlog

    primaryid   int(10) unsigned    NO  PRI 0    
    type    enum('post','thread','visitormessage','groupmessage','picturecomment')  NO  PRI post     
    userid  int(10) unsigned    NO      0    
    username    varchar(100)    NO           
    reason  varchar(125)    NO           
    dateline    int(10) unsigned    NO      0     
    
    hgtonight
  • SHOW tbl_thread STATUS;
    SHOW tbl_deletionlog STATUS;
    

    Btw how long is the process taking to complete about a minute?

    grep is your friend.

    hgtonight
  • x00x00 MVP
    edited September 2013

    Can you do this?

    SELECT 
        p.*, 'BBCode' as Format,
        p.userid as InsertUserID,
        p.userid as UpdateUserID,
        FROM_UNIXTIME(p.dateline) as DateInserted,
        FROM_UNIXTIME(p.dateline) as DateUpdate
    FROM tbl_post p 
    INNER JOIN tbl_thread t 
        ON p.threadid = t.threadid 
    LEFT JOIN tbl_deletionlog  d 
        ON (d.type='post' AND d.primaryid=p.postid) 
    WHERE
        p.postid <> t.firstpostid 
        AND d.primaryid IS NULL 
        AND p.visible = 1 
    LIMIT 20
    

    grep is your friend.

    UnderDoghgtonightperegrine
  • I can do this. It returns 20 rows. I'm assuming you don't want the results.

    @x00 said:
    Can you do this?

    SELECT 
        p.*, 'BBCode' as Format,
        p.userid as InsertUserID,
        p.userid as UpdateUserID,
        FROM_UNIXTIME(p.dateline) as DateInserted,
        FROM_UNIXTIME(p.dateline) as DateUpdate
    FROM tbl_post p 
    INNER JOIN tbl_thread t 
        ON p.threadid = t.threadid 
    LEFT JOIN tbl_deletionlog  d 
        ON (d.type='post' AND d.primaryid=p.postid) 
    WHERE
        p.postid <> t.firstpostid 
        AND d.primaryid IS NULL 
        AND p.visible = 1 
    LIMIT 20
    
    hgtonightUnderDog
  • I'm getting an error when I run these queries. The process takes 1-2 minutes, yes.

    @x00 said:

    SHOW tbl_thread STATUS;
    SHOW tbl_deletionlog STATUS;
    

    Btw how long is the process taking to complete about a minute?

    hgtonight
  • sorry that should be

    SHOW TABLE STATUS LIKE 'tbl_thread';
    SHOW TABLE STATUS LIKE 'tbl_deletionlog';
    

    grep is your friend.

    hgtonightUnderDog
  • x00x00 MVP
    edited September 2013

    Either the full query is not returned which is looking more doubtful or the filtering/mapping is failing.

    grep is your friend.

  • tbl_thread

    Name - tbl_thread
    Engine - MyISAM 
    Version - 10    
    Row_format - Dynamic    
    Rows     - 20797    
    Avg_row_length - 123
    Data_length - 2564628   
    Max_data_length - 281474976710655   
    Index_length - 3377152  
    Data_free - 0
    Auto_increment - 21385  
    Create_time - 2013-09-14 21:52:14
    Update_time - 2013-09-14 21:52:22
    Check_time - NULL   
    Collation - latin1_swedish_ci   
    Checksum - NULL      
    Create_options  -
    Comment -
    

    tbl_deletionlog

    Name - tbl_deletionlog
    Engine - MyISAM 
    Version - 10
    Row_format - Dynamic
    Rows     - 4335
    Avg_row_length - 29
    Data_length - 127384
    Max_data_length - 281474976710655
    Index_length - 136192   
    Data_free - 0
    Auto_increment - NULL   
    Create_time - 2013-09-14 21:41:31
    Update_time - 2013-09-14 21:41:32
    Check_time - NULL   
    Collation - latin1_swedish_ci
    Checksum - NULL
    Create_options  -
    Comment -
    
    UnderDog
  • Just a heads up. I've decided not to import my old discussions for now @x00. Only users. But I'm still willing to help provide info to fix the problem if you feel it is worth it. Thanks for taking the time to help!

Sign In or Register to comment.