Blog Documentation Book a Demo
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.

Exporting Vbulletin 3.x Problem

tandjenttandjent New
in Vanilla 2.0 - 2.8

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.

Tagged:

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.

  • tandjenttandjent New 
    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
  • x00x00 MVP
    edited September 2013

    can you

    DESCRIBE tbl_post;
DESCRIBE tbl_thread;
DESCRIBE tbl_deletionlog;

    grep is your friend.

  • tandjenttandjent New

    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
  • x00x00 MVP 
    SHOW tbl_thread STATUS;
SHOW tbl_deletionlog STATUS;

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

    grep is your friend.

  • 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.

  • tandjenttandjent New

    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
  • tandjenttandjent New

    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?

  • x00x00 MVP

    sorry that should be

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

    grep is your friend.

  • 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.

  • tandjenttandjent New

    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 -
  • UnderDogUnderDog MVP

    Exported Table: Comment (0 rows)

    This is what we're focusing on, right?
    I'll leave x00 to it then. Great guy on the case :-)

    There was an error rendering this rich post.

  • tandjenttandjent New

    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.