Announcement

Collapse
No announcement yet.

yaf import issue - please help!

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

  • yaf import issue - please help!

    Clean import
    Source - yaf - 1.9.1.7 (NET v2.0)
    Target - vBulletin 3.8.3
    Module - 001

    It seems like the importer is not finding my tables. I have checked and double checked the config and see no issues. The table prefix is correct, I just can't seem to get this first step working!

    Here is the output from the first module... Any ideas?

    Code:
    ImpEx build version : 1.92
      
    Altering tables
    
    ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining references between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the original vB userid. 
    moderator - importmoderatorid Completed 
    usergroup - importusergroupid Completed 
    ranks - importrankid Completed 
    poll - importpollid Completed 
    forum - importforumid Completed 
    forum - importcategoryid Completed 
    user - importuserid Completed 
    style - importstyleid Completed 
    thread - importthreadid Completed 
    post - importthreadid Completed 
    thread - importforumid Completed 
    smilie - importsmilieid Completed 
    pmtext - importpmid Completed 
    avatar - importavatarid Completed 
    customavatar - importcustomavatarid Completed 
    customprofilepic - importcustomprofilepicid Completed 
    post - importpostid Completed 
    attachment - importattachmentid Completed 
    pm - importpmid Completed 
    usernote - importusernoteid Completed 
    phrase - importphraseid Completed 
    subscription - importsubscriptionid Completed 
    subscriptionlog - importsubscriptionlogid Completed
    yaf_accessmask NOT found.
    yaf_active NOT found.
    yaf_attachment NOT found.
    yaf_bannedip NOT found.
    yaf_board NOT found.
    yaf_category NOT found.
    yaf_checkemail NOT found.
    yaf_choice NOT found.
    yaf_forum NOT found.
    yaf_forumaccess NOT found.
    yaf_group NOT found.
    yaf_mail NOT found.
    yaf_message NOT found.
    yaf_nntpforum NOT found.
    yaf_nntpserver NOT found.
    yaf_nntptopic NOT found.
    yaf_pmessage NOT found.
    yaf_poll NOT found.
    yaf_rank NOT found.
    yaf_registry NOT found.
    yaf_replace_words NOT found.
    yaf_smiley NOT found.
    yaf_topic NOT found.
    yaf_user NOT found.
    yaf_userforum NOT found.
    yaf_usergroup NOT found.
    yaf_userpmessage NOT found.
    yaf_watchforum NOT found.
    yaf_watchtopic NOT found.

  • #2
    please?
    anyone?
    vbullentin people?
    i paid for this software?
    help?

    Comment


    • #3
      Check the YAF database. What are the names of the tables there?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        Originally posted by Steve Machol View Post
        Check the YAF database. What are the names of the tables there?
        the names of the tables are the same as the ones i've shown in red in my original post

        Comment


        • #5
          They can't be, otherwise you would not get an error stating those tables don't exist. So either the tables names are different, you are looking at the wrong database, or you have a different error now.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment


          • #6
            Originally posted by Steve Machol View Post
            Check the YAF database. What are the names of the tables there?

            here are some screenshots....


            my source database (yaf):



            my destination db:




            the impex config file:




            the source db tables:

            Comment


            • #7
              Assuming that is the correct database, the table names have capital letters. Try renaming them to all lowercase.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                not sure why but this is the output of the impex module now: i renamed the first table to be "yaf_accessmask"

                Code:
                Altering tables
                
                ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining references between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the original vB userid. 
                moderator - importmoderatorid Completed 
                usergroup - importusergroupid Completed 
                ranks - importrankid Completed 
                poll - importpollid Completed 
                forum - importforumid Completed 
                forum - importcategoryid Completed 
                user - importuserid Completed 
                style - importstyleid Completed 
                thread - importthreadid Completed 
                post - importthreadid Completed 
                thread - importforumid Completed 
                smilie - importsmilieid Completed 
                pmtext - importpmid Completed 
                avatar - importavatarid Completed 
                customavatar - importcustomavatarid Completed 
                customprofilepic - importcustomprofilepicid Completed 
                post - importpostid Completed 
                attachment - importattachmentid Completed 
                pm - importpmid Completed 
                usernote - importusernoteid Completed 
                phrase - importphraseid Completed 
                subscription - importsubscriptionid Completed 
                subscriptionlog - importsubscriptionlogid Completed
                yaf_AccessMask NOT found.
                yaf_Active NOT found.
                yaf_Attachment NOT found.
                yaf_BannedIP NOT found.
                yaf_Board NOT found.
                yaf_Category NOT found.
                yaf_CheckEmail NOT found.
                yaf_Choice NOT found.
                yaf_Forum NOT found.
                yaf_ForumAccess NOT found.
                yaf_Group NOT found.
                yaf_Mail NOT found.
                yaf_Message NOT found.
                yaf_NntpForum NOT found.
                yaf_NntpServer NOT found.
                yaf_NntpTopic NOT found.
                yaf_PMessage NOT found.
                yaf_Poll NOT found.
                yaf_Rank NOT found.
                yaf_Registry NOT found.
                yaf_Replace_Words NOT found.
                yaf_Smiley NOT found.
                yaf_Topic NOT found.
                yaf_User NOT found.
                yaf_UserForum NOT found.
                yaf_UserGroup NOT found.
                yaf_UserPMessage NOT found.
                yaf_WatchForum NOT found.
                yaf_WatchTopic NOT found
                

                Comment


                • #9
                  So this is an SQL Server database? If so that is not supported by Impex:

                  Yet Another Forum
                  Tier = 3
                  Source version support in ImpEx = 1.9.0
                  • Import usergroup
                  • Import user
                  • Import forum
                  • Import thread
                  • Import post
                  • Import Private messages
                  • Import attachment

                  Also since this is a Tier 3 imported I'm afraid it's no longer supported and will not be updated. I wish I had a fix for this but it's entirely likely that your version of YAF is not compatible with Impex. Sorry.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment


                  • #10
                    Ensure you have this set :

                    define('lowercase_table_names', false);

                    in ImpExConfig.php
                    I wrote ImpEx.

                    Blog | Me

                    Comment


                    • #11
                      yep, that's set.
                      we are going to upgrade the yaf to the lastest version and try it again.

                      Comment

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