Announcement

Collapse
No announcement yet.

Problem importing a WoWBB 1.7 forum

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Jerry
    replied
    When you get your ssh access to the linux host, get into the old forum dir or folder you copied the avatars to and type :

    Code:
    pwd
    That will give you the path to give to ImpEx, minus the images/ as per one of the earlier posts.

    Leave a comment:


  • Tigratrus
    replied
    Heh. Pretty telling response Jerry .

    We've decided to bite the bullet and provision a Linux VPS over at servint since php/mysql is really the 800lb gorrilla of our site. I've been pretty unhappy with the generally sluggish response of vBulletin on the Windows/IIS server, even with minimal data ported and 700 Meg of Ram free. I'll give the import another try on the Linux host now that I have some idea what I'm doing, and let you know if avatars keep being the problem child. Thanks again for all your feedback!

    James

    Leave a comment:


  • Jerry
    replied
    Ahhh windows ........

    Open a support ticket and ask for me.

    Leave a comment:


  • Tigratrus
    replied
    Avatars still not importing

    Total abject failure on importing the avatars. They just don't do anything at all. No files are imported, no entries are made in the database.

    I thought perhaps I could work around it by setting the system to store them in the Filesystem, copying them in and then updating the table(s) via SQL, but the customavatar table has way too much unique info about each avatar. AARRRRGH!

    ::sigh::

    This is my LAST stumbling block... And it seems like the problem is either being caused by DB changes in WoWBB 1.7 from 1.65 OR I'm still putting the path in wrong. I've TRIED a LOT of possible paths (at 15-20 min an import each). I'm just going to have to ask for a flat out answer if possible:

    I'm on an Windows/IIS server, the path to the WoWBB avatars is:

    C:\Inetpub\vhosts\ikeafans.biz\httpdocs\forums\images\avatars

    For relative pathing concerns, vbulletin is installed in:

    C:\Inetpub\vhosts\ikeafans.biz\httpdocs\vbulletin

    What should I be putting in? I feel like an idiot that I just can't get the Avatars to import, it takes so long to try it each time, and there's no real error message, just a lack of anything coming in. What part of the ImpEx process would be doing the actual importing of the avatars? The Import User? If I re-run the User Import will it try to bring in the avatars again or will it completely skip over users that already have an entry in the User Table based on importuserid?

    Leave a comment:


  • Tigratrus
    replied
    Excellent. I'll give the import another try as soon as I can get my partner to stop playing with adding a left hand column

    Thanks for the responses!

    Leave a comment:


  • Jerry
    replied
    1)

    If it can't find the files, yes that will be 0 as the avatar import will fail.

    2)
    Its looking for the full local path to the source forum as the avatar information in the database is stored thus :

    images/avatars/2.jpg

    So if the full path to one of the images is :

    /home/jerry/www/sourceforum/images/avatars/2.jpg

    Then enter:

    /home/jerry/www/sourceforum/

    Leave a comment:


  • Tigratrus
    replied
    1. I can put them in a local folder no problem... Is the avatarid not getting set if it can't find the files?

    2. Can you give me an example path as it should be entered if the avatars are in:

    httpdocs/forum/images/avatars

    Would that be a full system path like:

    c:\Inetpub\vhosts\Ikeafans.biz\httpdocs\forum\images\avatars

    The verbiage in the tool is vague on whether it's looking for the "forum" or the avatars directory?
    Last edited by Tigratrus; Mon 30 Oct '06, 12:18pm.

    Leave a comment:


  • Jerry
    replied
    It's a local path to the avatars, PHP on the server that ImpEx is running on needs read access to them.

    Leave a comment:


  • Tigratrus
    replied
    Thanks for the SQL fix for the post title, that should solve that one.

    What about the avatars? They aren't importing... I looked in the User table and avatarid is set to 0?

    I understand from a few other pots on here that it's looking for the path to the WoWBB avatar folder? Are we talking URL here? Or does it need to be locally installed? I'm having problems getting a good backup/restore of the live WoWBB DB, but I ran a test import after shutting down the live forum and that seemed to work fine with the exception of the avatars...

    Leave a comment:


  • Jerry
    replied
    If you have removed the import id's you have finalised the import and ImpEx will not be able to clear anything out, you will have to redo the import.

    The "imported post" is a title added by ImpEx, to remove that you can run this SQL :

    Code:
    UPDATE post SET title='' WHERE title='imported post'
    Nothing custom is imported only default values.

    Leave a comment:


  • Tigratrus
    replied
    Jerry,

    I've been playing around with the import some more, and getting all the users out of the groups that were imported from the WoWBB forum did indeed fix the Banned user issue. I certainly understand vBulletin user groups much better now .

    Remaining issues:

    1. I still have all posts showing up as "imported post" even after I ran the Clean-up and selected "Remove importids".

    2. Avatars still are not importing. In the database the avatarid is set to 0 even for users that SHOULD have an avatar? When asked for the full path (where images/avatars is located); if given an install path of httpdocs/vbulletin/images/avatars, what should be entered?

    3. Custom user fields are not being imported.

    In reflection, I think the custom user fields were a new feature in WoWBB 1.7? Perhaps issues #2 & #3 are related and are being caused by the DB changes to support custom user fields?

    Leave a comment:


  • Tigratrus
    replied
    There were no users listed in the banned group. When I looked at each of the WoWBB groups that were created they all had the value for "This Usergroup is not a 'Banned' Group" set to "No", I changed all the groups so that they had "yes" instead, but the user I was using as a test account was still unable to access posts "Banned for life" Do we need to move all users out of the groups created from WoWBB and into new groups?

    Is there a way to remove the "Imported Post" lable on all posts? I ran the Clean-up and selected "Remove importids", but it's still there?

    For the avatars is the path that I need to put in the path to the WoWBB forum? If so what should I put in if I have WoWBB avatars in httpdocs/forums/images/avatars. And (if it matters) vBulletin is in httpdocs/vbulletin/images/avatars?

    James

    Leave a comment:


  • Jerry
    replied
    When I say the groups are created, I mean the wowBB ones that are created in vBulletin by ImpEx.

    You don't have to copy the avatars to any where as long as ImpEx can read from the source.

    Is you browse a user in the admincp does it say they are in the banned group ?

    Leave a comment:


  • Tigratrus
    replied
    Ok... I rolled everything back and re-ran the import. Polls ran just fine THAT one appears to be fixed with the new file.

    Everyone is still banned however. I did find a reference to changing the usergroup properties to let them be listed on the memberlist and now everyone shows up... But everyone is also still banned for life , even after I went into the usergroup manager and changed the group so that "Not a member of a banned group" is Yes. Also all posts are still listed as "Imported Post" in the threads, even after I ran the Clean-up and selected "Remove importids".

    There was no group created to hold all imported users, they are all just in the original groups they were in on WoWBB.

    Avatars are also not associated with their users, I DID copy them over manually, so I know the files are there.
    Last edited by Tigratrus; Thu 26 Oct '06, 7:04pm. Reason: additional info

    Leave a comment:


  • Jerry
    replied
    Well the importer was written for 1.63 so I can't see the schema changing that much that the usergroups would fail, I take it in module 003 that the usergroups all imported fine or not?

    ImpEx should import and create the wowBB usergroups in vBulletin, then import the users into those groups, as they were in the source board.

    I found the poll issue, download ImpEx again and upload and overwrite:

    impex/systems/wowBB/008.php

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X