Need Modules for Blogs, Social Groups, Albums and SUbscriptions

[Big-K]

Hello,

I'm having to re-build my 3.7 forum from scratch due to database issues.

I've successfully imported the posts, threads and all the available modules, but BLOGS, SOCIAL groups, ALBUMS, thread subscriptions have not moved. Do you have modules for these or custom queries.

I've attached a file to show the differences in records.

Thanks

[peterska2]

For Blogs you will need to do another import for Blog to Blog.

Social Groups, Albums, Thread subscriptions are not imported.

Make sure you follow the multiple import instructions:
http://www.vbulletin.com/docs/html/impex_multi_import

[Big-K]

Hi Kerry-Anne,
The downside to your solution is that BlogUserIds may not match forum User IDs. Here are the queries I ran to export and update current data from VB3 to VB4 and I hope your team will package some of these into an impex module to save others from this stress

Note
1. Current forum has VB3 prefix, and new forum has vb4 prefix
2. Blog must be installed first on new forum

DB Queries



-- Pictures and Albums
insert into vb4_album select * from vb3_album ;
insert into vb4_albumpicture select * from vb3_albumpicture ;
insert into vb4_picture select * from vb3_picture ;
insert into vb4_picturecomment select * from vb3_picturecomment ;
insert into vb4_picturecomment_hash select * from vb3_picturecomment_hash ;
update vb4_album, vb4_user set vb4_album.userid = vb4_user.userid where vb4_album.userid = vb4_user.importuserid;

-- Blogs
insert into vb4_blog select * from vb3_blog;
insert into vb4_blog_attachment select * from vb3_blog_attachment;
insert into vb4_blog_attachmentviews select * from vb3_blog_attachmentviews;
insert into vb4_blog_category select * from vb3_blog_category;
insert into vb4_blog_categoryuser select * from vb3_blog_categoryuser;
insert into vb4_blog_deletionlog select * from vb3_blog_deletionlog;
insert into vb4_blog_editlog select * from vb3_blog_editlog;
insert into vb4_blog_hash select * from vb3_blog_hash;
insert into vb4_blog_moderation select * from vb3_blog_moderation;
insert into vb4_blog_moderator select * from vb3_blog_moderator;
insert into vb4_blog_pinghistory select * from vb3_blog_pinghistory;
insert into vb4_blog_rate select * from vb3_blog_rate;
insert into vb4_blog_read select * from vb3_blog_read;
insert into vb4_blog_relationship select * from vb3_blog_relationship;
insert into vb4_blog_search select * from vb3_blog_search;
insert into vb4_blog_searchresult select * from vb3_blog_searchresult;
insert into vb4_blog_subscribeentry select * from vb3_blog_subscribeentry;
insert into vb4_blog_subscribeuser select * from vb3_blog_subscribeuser;
insert into vb4_blog_tachyentry select * from vb3_blog_tachyentry;
insert into vb4_blog_text select * from vb3_blog_text;
insert into vb4_blog_textparsed select * from vb3_blog_textparsed;
insert into vb4_blog_trackback select * from vb3_blog_trackback;
insert into vb4_blog_trackbacklog select * from vb3_blog_trackbacklog;
insert into vb4_blog_user select * from vb3_blog_user;
insert into vb4_blog_userread select * from vb3_blog_userread;
insert into vb4_blog_views select * from vb3_blog_views;
update vb4_blog, vb4_user set vb4_blog.userid = vb4_user.userid where vb4_blog.userid = vb4_user.importuserid;
update vb4_blog_attachment, vb4_user set vb4_blog_attachment.userid = vb4_user.userid where vb4_blog_attachment.userid = vb4_user.importuserid;
update vb4_blog_category, vb4_user set vb4_blog_category.userid = vb4_user.userid where vb4_blog_category.userid = vb4_user.importuserid;
update vb4_blog_categoryuser, vb4_user set vb4_blog_categoryuser.userid = vb4_user.userid where vb4_blog_categoryuser.userid = vb4_user.importuserid;
update vb4_blog_deletionlog, vb4_user set vb4_blog_deletionlog.userid = vb4_user.userid where vb4_blog_deletionlog.userid = vb4_user.importuserid;
update vb4_blog_editlog, vb4_user set vb4_blog_editlog.userid = vb4_user.userid where vb4_blog_editlog.userid = vb4_user.importuserid;
update vb4_blog_hash, vb4_user set vb4_blog_hash.userid = vb4_user.userid where vb4_blog_hash.userid = vb4_user.importuserid;
update vb4_blog_moderator, vb4_user set vb4_blog_moderator.userid = vb4_user.userid where vb4_blog_moderator.userid = vb4_user.importuserid;
update vb4_blog_rate, vb4_user set vb4_blog_rate.userid = vb4_user.userid where vb4_blog_rate.userid = vb4_user.importuserid;
update vb4_blog_read, vb4_user set vb4_blog_read.userid = vb4_user.userid where vb4_blog_read.userid = vb4_user.importuserid;
update vb4_blog_relationship, vb4_user set vb4_blog_relationship.userid = vb4_user.userid where vb4_blog_relationship.userid = vb4_user.importuserid;
update vb4_blog_search, vb4_user set vb4_blog_search.userid = vb4_user.userid where vb4_blog_search.userid = vb4_user.importuserid;
update vb4_blog_search, vb4_user set vb4_blog_search.searchuserid = vb4_user.userid where vb4_blog_search.searchuserid = vb4_user.importuserid;
update vb4_blog_subscribeentry, vb4_user set vb4_blog_subscribeentry.userid = vb4_user.userid where vb4_blog_subscribeentry.userid = vb4_user.importuserid;
update vb4_blog_subscribeuser, vb4_user set vb4_blog_subscribeuser.blogsubscribeuserid = vb4_user.userid where vb4_blog_subscribeuser.blogsubscribeuserid = vb4_user.importuserid;
update vb4_blog_subscribeuser, vb4_user set vb4_blog_subscribeuser.bloguserid = vb4_user.userid where vb4_blog_subscribeuser.bloguserid = vb4_user.importuserid;
update vb4_blog_subscribeuser, vb4_user set vb4_blog_subscribeuser.userid = vb4_user.userid where vb4_blog_subscribeuser.userid = vb4_user.importuserid;
update vb4_blog_tachyentry, vb4_user set vb4_blog_tachyentry.userid = vb4_user.userid where vb4_blog_tachyentry.userid = vb4_user.importuserid;
update vb4_blog_text, vb4_user set vb4_blog_text.userid = vb4_user.userid where vb4_blog_text.userid = vb4_user.importuserid;
update vb4_blog_text, vb4_user set vb4_blog_text.bloguserid = vb4_user.userid where vb4_blog_text.bloguserid = vb4_user.importuserid;
update vb4_blog_trackback, vb4_user set vb4_blog_trackback.userid = vb4_user.userid where vb4_blog_trackback.userid = vb4_user.importuserid;
update vb4_blog_trackbacklog, vb4_user set vb4_blog_trackbacklog.userid = vb4_user.userid where vb4_blog_trackbacklog.userid = vb4_user.importuserid;
update vb4_blog_user, vb4_user set vb4_blog_user.bloguserid = vb4_user.userid where vb4_blog_user.bloguserid = vb4_user.importuserid;
update vb4_blog_userread, vb4_user set vb4_blog_userread.userid = vb4_user.userid where vb4_blog_userread.userid = vb4_user.importuserid;
update vb4_blog_userread, vb4_user set vb4_blog_userread.bloguserid = vb4_user.userid where vb4_blog_userread.bloguserid = vb4_user.importuserid;

-- Social Groups
insert into vb4_groupmessage select * from vb3_groupmessage ;
insert into vb4_groupmessage_hash select * from vb3_groupmessage_hash ;
insert into vb3_socialgroup select * from vb3_socialgroup ;
insert into vb4_socialgroupmember select * from vb3_socialgroupmember ;
insert into vb4_socialgrouppicture select * from vb3_socialgrouppicture ;
update vb4_groupmessage, vb4_user set vb4_groupmessage.postuserid = vb4_user.userid where vb4_groupmessage.postuserid = vb4_user.importuserid;
update vb4_groupmessage_hash, vb4_user set vb4_groupmessage_hash.postuserid = vb4_user.userid where vb4_groupmessage_hash.postuserid = vb4_user.importuserid;
update vb4_socialgroup, vb4_user set vb4_socialgroup.creatoruserid = vb4_user.userid where vb4_socialgroup.creatoruserid = vb4_user.importuserid;
update vb4_socialgroup, vb4_user set vb4_socialgroup.lastposterid = vb4_user.userid where vb4_socialgroup.lastposterid = vb4_user.importuserid;
update vb4_socialgroupmember, vb4_user set vb4_socialgroupmember.userid = vb4_user.userid where vb4_socialgroupmember.userid = vb4_user.importuserid;
Subscriptions
insert into vb4_subscribeforum select * from vb3_subscribeforum;
insert into vb4_subscribethread select * from vb3_subscribethread;
update vb4_subscribeforum, vb4_user set vb4_subscribeforum.userid = vb4_user.userid where vb4_subscribeforum.userid = vb4_user.importuserid;
update vb4_subscribeforum, vb4_forum set vb4_subscribeforum.forumid = vb4_forum.forumid where vb4_subscribeforum.forumid = vb4_forum.importforumid;
update vb4_subscribethread, vb4_user set vb4_subscribethread.userid = vb4_user.userid where vb4_subscribethread.userid = vb4_user.importuserid;
update vb4_subscribethread, vb4_thread set vb4_subscribethread.threadid = vb4_thread.threadid where vb4_subscribethread.threadid = vb4_thread.importthreadid;
update vb4_picture, vb4_user set vb4_picture.userid = vb4_user.userid where vb4_picture.userid = vb4_user.importuserid;
update vb4_picturecomment, vb4_user set vb4_picturecomment.postuserid = vb4_user.userid where vb4_picturecomment.postuserid = vb4_user.importuserid;
update vb4_picturecomment_hash, vb4_user set vb4_picturecomment_hash.postuserid = vb4_user.userid where vb4_picturecomment_hash.postuserid = vb4_user.importuserid;

-- Profiles
insert into vb4_profilevisitor select * from vb3_profilevisitor ;
insert into vb4_userlist select * from vb3_userlist ;
insert into vb4_visitormessage select * from vb3_visitormessage ;
update vb4_visitormessage, vb4_user set vb4_visitormessage.userid = vb4_user.userid where vb4_visitormessage.userid = vb4_user.importuserid;
update vb4_visitormessage, vb4_user set vb4_visitormessage.postuserid = vb4_user.userid where vb4_visitormessage.postuserid = vb4_user.importuserid;
update vb4_profilevisitor, vb4_user set vb4_profilevisitor.userid = vb4_user.userid where vb4_profilevisitor.userid = vb4_user.importuserid;
update vb4_userlist, vb4_user set vb4_userlist.userid = vb4_user.userid where vb4_userlist.userid = vb4_user.importuserid;

-- Others (Password History, Polls, tags, stats, signatures..)
insert into vb4_passwordhistory select * from vb3_passwordhistory ;
insert into vb4_pollvote select * from vb3_pollvote ;
insert into vb3_rssfeed select * from vb3_rssfeed ;
insert into vb3_sigparsed select * from vb3_sigparsed ;
insert into vb4_sigpic select * from vb3_sigpic ;
insert into vb4_stats select * from vb3_stats ;
insert into vb4_tag select * from vb3_tag ;
insert into vb4_threadrate select * from vb3_threadrate;
update vb4_passwordhistory, vb4_user set vb4_passwordhistory.userid = vb4_user.userid where vb4_passwordhistory.userid = vb4_user.importuserid;
update vb4_pollvote, vb4_user set vb4_pollvote.userid = vb4_user.userid where vb4_pollvote.userid = vb4_user.importuserid;
update vb4_pollvote, vb4_poll set vb4_pollvote.pollid = vb4_poll.pollid where vb4_pollvote.pollid = vb4_poll.importpollid;
update vb4_rssfeed, vb4_forum set vb4_rssfeed.forumid = vb4_forum.forumid where vb4_rssfeed.forumid = vb4_forum.importforumid;
update vb4_rssfeed, vb4_user set vb4_rssfeed.userid = vb4_user.userid where vb4_rssfeed.userid = vb4_user.importuserid;
update vb4_sigparsed, vb4_user set vb4_sigparsed.userid = vb4_user.userid where vb4_sigparsed.userid = vb4_user.importuserid;
update vb4_sigpic, vb4_user set vb4_sigpic.userid = vb4_user.userid where vb4_sigpic.userid = vb4_user.importuserid;
update vb4_threadrate, vb4_user set vb4_threadrate.userid = vb4_user.userid where vb4_threadrate.userid = vb4_user.importuserid;
update vb4_threadrate, vb4_thread set vb4_threadrate.threadid = vb4_thread.threadid where vb4_threadrate.threadid = vb4_thread.importthreadid;

[Jerry]

ImpEx ties the userid's together on the import, though more importantly ImpEx is not a database repair tool, this is not what it is for.