Announcement

Collapse
No announcement yet.

vbjournal to vb blog import issue

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

  • 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!

  • #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


    • #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


      • #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


        • #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


          • #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


            • #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


              • #8
                Originally posted by Reeve of Shinra View Post
                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


                • #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


                  • #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


                    • #11
                      Originally posted by Reeve of Shinra View Post
                      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


                      • #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


                        • #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


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

                            Blog | Me

                            Comment


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

                              Comment

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