vbjournal to vb blog import issue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Reeve of Shinra
    Senior Member
    • Sep 2001
    • 4325
    • 4.0.0

    vbjournal to vb blog import issue

    I uploaded impex.... selected vbjournal to vb blog 1.0.0 and hit next.

    I ran module 001 and received the following error. Now I am stuck on this screen whenever I hit the import link on the left hand navigation window.

    What did I screw up?

    -----

    Warning: main(/home/shinraon/domains/shinraonline.com/public_html/board/impex/ImpExDatabase_blog_001.php): failed to open stream: No such file or directory in /impex/index.php on line 199

    Fatal error: main(): Failed opening required '/home/shinraon/domains/shinraonline.com/public_html/board/impex/ImpExDatabase_blog_001.php' (include_path='.:/usr/local/lib/php') in /home/shinraon/domains/shinraonline.com/public_html/board/impex/index.php on line 199
    Plan, Do, Check, Act!
  • Lizard King
    Banned
    • Mar 2004
    • 1891
    • 3.6.x

    #2
    You did nothing wrong. The ImpExDatabase_blog_001.php file is missing inside impex. Jerry will probably correct the issue when he will get online

    Comment

    • Jerry
      Senior Member
      • Dec 2002
      • 9137
      • 1.1.x

      #3
      It's there now, I've just rebuilt the ImpEx download and tested it via my own members area account.
      I wrote ImpEx.

      Blog | Me

      Comment

      • Reeve of Shinra
        Senior Member
        • Sep 2001
        • 4325
        • 4.0.0

        #4
        Module 1:

        ImpEx Database errormysql error: Invalid SQL: DESCRIBE blog_subscribepost importblogsubscribepostid

        mysql error: Table 'shinraon_shinra.blog_subscribepost' doesn't exist

        mysql error number: 1146

        Date: Sunday 02nd of September 2007 06:13:15 PM
        Database: shinraon_shinra
        MySQL error:
        Plan, Do, Check, Act!

        Comment

        • Lizard King
          Banned
          • Mar 2004
          • 1891
          • 3.6.x

          #5
          There are bunch of errors inside the impex currently mainly within the missing file. I corrected all of them. I will do a test now on my board.

          Comment

          • Reeve of Shinra
            Senior Member
            • Sep 2001
            • 4325
            • 4.0.0

            #6
            Made the following changes to get through module 1.

            Step 1: Run mysql command:
            RENAME TABLE blog_subscribeentry TO blog_subscribepost;

            Step 2:
            ALTER TABLE `blog_category` ADD `postcount` VARCHAR( 100 ) DEFAULT '0' NOT NULL ;
            Plan, Do, Check, Act!

            Comment

            • Reeve of Shinra
              Senior Member
              • Sep 2001
              • 4325
              • 4.0.0

              #7
              Module 3 error:

              ImpEx Database errormysql error: Invalid SQL:
              INSERT INTO blog_user
              (
              bloguserid, importbloguserid, title, description, options,
              viewoption, comments, lastblog, lastblogid,
              lastblogtitle, lastcomment, lastcommenter, lastblogtextid,
              posts, allowsmilie, subscribeown, subscribeothers,
              moderation, deleted, draft, options_everyone,
              options_buddy, options_ignore, ratingnum, ratingtotal,
              rating, pending, uncatposts
              )
              VALUES
              (
              '17257',
              '2',
              '',
              '',
              '0',
              'all',
              '0',
              '0',
              '0',
              '',
              '0',
              '',
              '0',
              '0',
              '1',
              'none',
              'none',
              '0',
              '0',
              '0',
              '0',
              '0',
              '0',
              '0',
              '0',
              '0',
              '0',
              '0'
              )


              mysql error: Unknown column 'posts' in 'field list'

              mysql error number: 1054

              Date: Sunday 02nd of September 2007 06:49:09 PM
              Database: shinraon_shinra
              MySQL error:
              Ran Queries:

              ALTER TABLE `blog_user` ADD `posts` VARCHAR( 100 ) DEFAULT '0' NOT NULL ;

              ALTER TABLE `blog_user` ADD `uncatposts` VARCHAR( 100 ) DEFAULT '0' NOT NULL ;
              Success!
              Plan, Do, Check, Act!

              Comment

              • Lizard King
                Banned
                • Mar 2004
                • 1891
                • 3.6.x

                #8
                Originally posted by Reeve of Shinra
                Made the following changes to get through module 1.
                You are going all the wrong route. Let me paste the fixes

                Change all instances of subscribepost to subscribeentry

                These instances are located at
                ImpExModule.php line 101
                impex_language.php line 491
                vbfields.php line 598 - 600 - 601 - 602 - 603 - 604

                Comment

                • Reeve of Shinra
                  Senior Member
                  • Sep 2001
                  • 4325
                  • 4.0.0

                  #9
                  Module 4 is running okay but there are a lot of entries kicking back the following error.

                  "Invalid ImpExData object, skipping. Failed on : title"

                  The entries in question may be from the vb2 of the Journal or it could have been due to our own setup as we were running a slight fork of Ryangels script.
                  Plan, Do, Check, Act!

                  Comment

                  • Reeve of Shinra
                    Senior Member
                    • Sep 2001
                    • 4325
                    • 4.0.0

                    #10
                    Lizardking -- thanks, I didn't want to mess with the impex files, it was easier for me to change a few table names lol. If I run into any more issues, I'll retry it going your route.
                    Plan, Do, Check, Act!

                    Comment

                    • Lizard King
                      Banned
                      • Mar 2004
                      • 1891
                      • 3.6.x

                      #11
                      Originally posted by Reeve of Shinra
                      Lizardking -- thanks, I didn't want to mess with the impex files, it was easier for me to change a few table names lol. If I run into any more issues, I'll retry it going your route.
                      There are couple more fixes that needs to be done on ImpExDatabase_blog_001.php file. I informed all via support ticket and succesfully imported vblogetin but then i realized i forget to assosicate usernames Now redoing it all from start

                      Comment

                      • Reeve of Shinra
                        Senior Member
                        • Sep 2001
                        • 4325
                        • 4.0.0

                        #12
                        associating users seems to be an issue.... using the associate users module - it wants to manually type in the new users id's and thats not going to happen. The user id's shouldnt have changed so it should be doing this automatically. I'll have to check into that.
                        Plan, Do, Check, Act!

                        Comment

                        • Reeve of Shinra
                          Senior Member
                          • Sep 2001
                          • 4325
                          • 4.0.0

                          #13
                          just for fun, I tried merging a few users through the users-merge user option in the admin cp... it seems like the blogs aren't updated by this. I think thats a vb error, no? (goes to post)
                          Plan, Do, Check, Act!

                          Comment

                          • Jerry
                            Senior Member
                            • Dec 2002
                            • 9137
                            • 1.1.x

                            #14
                            I've covered most of this, will test and release 1.85 tomorrow.
                            I wrote ImpEx.

                            Blog | Me

                            Comment

                            • Reeve of Shinra
                              Senior Member
                              • Sep 2001
                              • 4325
                              • 4.0.0

                              #15
                              thank you
                              Plan, Do, Check, Act!

                              Comment

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