Multiple forum import from UBB

[webspinner]

I am having problems importing a second forum from UBB. I use the database cleanup and restart, then "Remove importids". It does not clear the history of the imported users/posts etc... and deletes them if I try importing the second board. I have done this on v3.5 so is there a problem with 3.6?

Any advice appreciated

[Jerry]

Does the help.php page run at all ?

it should set all the import{table}id's to 0 and remove the session.

[webspinner]

It seems to run ok, no errors but the fields are still populated, nothing is zeroed. I select clean database, then remove ids, then it just returns

[webspinner]

Impex Help page
Deleteing Impex Session.

Session deleted
Setting importmoderatorid in table moderator to 0.......Completed
Setting importusergroupid in table usergroup to 0.......Completed
Setting importrankid in table ranks to 0.......Completed
Setting importpollid in table poll to 0.......Completed
Setting importforumid in table forum to 0.......Completed
Setting importcategoryid in table forum to 0.......Completed
Setting importuserid in table user to 0.......Completed
Setting importstyleid in table style to 0.......Completed
Setting importthreadid in table thread to 0.......Completed
Setting importthreadid in table post to 0.......Completed
Setting importforumid in table thread to 0.......Completed
Setting importsmilieid in table smilie to 0.......Completed
Setting importpmid in table pmtext to 0.......Completed
Setting importavatarid in table avatar to 0.......Completed
Setting importcustomavatarid in table customavatar to 0.......Completed
Setting importcustomprofilepicid in table customprofilepic to 0.......Completed
Setting importpostid in table post to 0.......Completed
Setting importattachmentid in table attachment to 0.......Completed
Click here to return to the import page.

But afterwards there are still numbers in the import screen

[Jerry]

This is what it runs, can you try it manually ?

UPDATE moderator SET importmoderatorid=0 WHERE importmoderatorid <> 0;
UPDATE usergroup SET importusergroupid=0 WHERE importusergroupid <> 0;
UPDATE ranks SET importrankid=0 WHERE importrankid <> 0;
UPDATE poll SET importpollid=0 WHERE importpollid <> 0;
UPDATE forum SET importforumid=0 WHERE importforumid <> 0;
UPDATE forum SET importcategoryid=0 WHERE importcategoryid <> 0;
UPDATE user SET importuserid=0 WHERE importuserid <> 0;
UPDATE style SET importstyleid=0 WHERE importstyleid <> 0;
UPDATE thread SET importthreadid=0 WHERE importthreadid <> 0;
UPDATE post SET importthreadid=0 WHERE importthreadid <> 0;
UPDATE thread SET importforumid=0 WHERE importforumid <> 0;
UPDATE smilie SET importsmilieid=0 WHERE importsmilieid <> 0;
UPDATE pmtext SET importpmid=0 WHERE importpmid <> 0;
UPDATE avatar SET importavatarid=0 WHERE importavatarid <> 0;
UPDATE customavatar SET importcustomavatarid=0 WHERE importcustomavatarid <> 0;
UPDATE customprofilepic SET importcustomprofilepicid=0 WHERE importcustomprofilepicid <> 0;
UPDATE post SET importpostid=0 WHERE importpostid <> 0;
UPDATE attachment SET importattachmentid=0 WHERE importattachmentid <> 0;

[webspinner]

Tried again and it is not clearing the successful or time taken fields, I am running 1.66 and vb 3.6

I did run your code in native MySQL, and I added my vb table prefix, all looked good until I returned to the import page

[Jerry]

Thats the session not the import id's.

Run this :

DELETE FROM datastore WHERE title='ImpExSession';

[webspinner]

Hi Jerry

Thanks for that tip, it seems to have done the trick, importing the second forum now. I will let you know how it goes.

Cheers

webspinner

[webspinner]

I have found another problem with the import, all the users are coming in as "Imported registered users" with this version. Previous versions identified users who did not have access to the old forums as they hadn't completed the registration process, or were in the moderation queue into separate groups. Unfortunately as there are so many users this is a serious flaw.

A less serious problem is that the import only seems to bring in a small percentage of PMs.

Any help appreciated, I hope it doesn't involve re-importing the database as the entire process takes over 24 hours.

Regards

webspinner

[Jerry]

What system are you importing from, and you can always just set up the ImpEx usergroup accordingly.

[webspinner]

Hi Jerry

I am importing the entire user base of a UBB classic 6.3.1.1 forum. There are around 26,000 active users and approx 4,000 who have not completed registration correctly hence cannot access the forum. Using previous versions of Impex it put users without write access into a separate group, this version does not seem to have done that.

Any suggestions?

[webspinner]

Basically I need a way of identifying users that have write post access in UBB, any suggestions welcome

[Steve Machol]

Which usergroup are these members in?

[webspinner]

Hi Steve,

That is the problem. older versions of Impex divided the users into several groups, the version I used today dumped everyone into the imported registered users group. So without going thru several thousand accounts by hand I cannot tell

[Steve Machol]

Did you follow follow the 'After the Import' instructions here:

http://www.vbulletin.com/docs/html/impex_cleanup