Announcement

Collapse
No announcement yet.

Importing xsorbit data to vbulletin?

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

  • Importing xsorbit data to vbulletin?

    Hello all. I'm trying to move a board from xsorbit to vbulletin. I've set up vbulletin on the new domain and installed ImpEx, but it seems that I don't have any sort of database settings for xsorbit - just the option to export the board data. Is there a way to get the data moved without ImpEx connecting directly to the xsorbit database?

  • #2
    The database setting for xsorbit will be the source details in ImpExConfig.

    ImpEx will need read access to that database to be able to import the data.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Thanks, Jerry. I found where to enter the source database settings in the ImpEx config file - the problem is that I can't get those settings from xsorbit. All I can get is a dump of the MySQL data in a single file. Is there any way to import from that since I can't connect directly to the source database?

      Comment


      • #4
        That file is a mysqldump, it will be a back up of the source database.

        What you do is you restore that file to your server into another database, the same server that vBulletin is on. Then what ever username/password you use for the database you restored it to will be the username/pass for the source.

        http://www.vbulletin.com/docs/html/m...tabase_restore
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          Thanks again, Jerry. There were some errors in the data dump that prevented it from importing correctly, but I managed to fix everything and get the data into a "backup" database I can import from. Impex connects to the host database successfully and has no trouble with certain modules, but when I get to importing the users - it fails after importing one or two users. I looked at the import code for xsorbit, and it looks like Impex is looking for table columns that don't exist. Any ideas?

          Comment


          • #6
            Here's the error I get:

            Code:
            ImpEx Database errormysql error: Invalid SQL: 
                                        INSERT INTO    ppusernote
                                        (
                                            userid, posterid, username, dateline, message, title, allowsmilies, importusernoteid
                                        )
                                        VALUES
                                        (
                                            14, 0, '', 1208097746, 'Imported user', 'Imported Note', 0, 1
                                        )
                                        
            
            mysql error: Unknown column 'importusernoteid' in 'field list'
            
            mysql error number: 1054
            
            Date: Sunday 13th 2008f April 2008 07:42:26 AM

            Comment


            • #7
              Have you done a previous import with an older version of ImpEx ?

              As that missing field importusernoteid should be added to the database when running module 001.
              I wrote ImpEx.

              Blog | Me

              Comment


              • #8
                Nope, no previous import.

                Here's the results of the first module (which seems to run fine).

                Code:
                moderator - importmoderatorid OK 
                usergroup - importusergroupid OK 
                ranks - importrankid OK 
                poll - importpollid OK 
                forum - importforumid OK 
                forum - importcategoryid OK 
                user - importuserid OK 
                style - importstyleid OK 
                thread - importthreadid OK 
                post - importthreadid OK 
                thread - importforumid OK 
                smilie - importsmilieid OK 
                pmtext - importpmid OK 
                avatar - importavatarid OK 
                customavatar - importcustomavatarid OK 
                customprofilepic - importcustomprofilepicid OK 
                post - importpostid OK 
                attachment - importattachmentid OK
                
                Valid found tables :
                  	
                inspirationboard_attachments found. 	
                inspirationboard_banned found. 	
                inspirationboard_board_permissions found. 	
                inspirationboard_boards found. 	
                inspirationboard_calendar found. 	
                inspirationboard_calendar_holidays found. 	
                inspirationboard_categories found. 	
                inspirationboard_collapsed_categories found. 	
                inspirationboard_im_recipients found. 	
                inspirationboard_instant_messages found. 	
                inspirationboard_log_actions found. 	
                inspirationboard_log_activity found. 	
                inspirationboard_log_banned found. 	
                inspirationboard_log_boards found. 	
                inspirationboard_log_errors found. 	
                inspirationboard_log_floodcontrol found. 	
                inspirationboard_log_karma found. 	
                inspirationboard_log_mark_read found. 	
                inspirationboard_log_notify found. 	
                inspirationboard_log_online found. 	
                inspirationboard_log_polls found. 	
                inspirationboard_log_topics found. 	
                inspirationboard_membergroups found. 	
                inspirationboard_members found. 	
                inspirationboard_messages found. 	
                inspirationboard_moderators found. 	
                inspirationboard_permissions found. 	
                inspirationboard_poll_choices found. 	
                inspirationboard_polls found. 	
                inspirationboard_settings found. 	
                inspirationboard_smileys found. 	
                inspirationboard_themes found. 	
                inspirationboard_topics found.

                Comment


                • #9
                  You're missing 5 import ids, there should be these as well:

                  Code:
                  importpmid
                  importusernoteid
                  importphraseid
                  importsubscriptionid
                  importsubscriptionlogid
                  Can you download ImpEx again and upload and overwrite ImpExModule.php to ensure you have the latest.
                  I wrote ImpEx.

                  Blog | Me

                  Comment


                  • #10
                    I'm sorry I'm such a pain, Jerry.

                    Still getting the same import ids, with the same ones missing (except importpmid that was in the original list). The revision date on the ImpExModule.php that I downloaded was Tue, 04 Sep 2007.

                    Comment


                    • #11
                      No pain, it's what I'm here for

                      Which is the same file I have here, and that should be in ImpEx ! ...

                      Curious.

                      Can you start a support ticket and ask for me so I can have a look at it.
                      I wrote ImpEx.

                      Blog | Me

                      Comment


                      • #12
                        I'm experiencing the same problem here. Was this resolved?

                        Comment


                        • #13
                          Originally posted by davidkv View Post
                          I'm experiencing the same problem here. Was this resolved?
                          I ended up reinstalling the database and comparing with an earlier (working) version. This is what I did to make the databases identical, might help someone else (although I wouldn't recommend it, I'm also running everything in utf8, so beware):

                          Code:
                          alter table `Forum`.`phrase` 
                              add column `importphraseid` bigint(20)   NOT NULL DEFAULT '0' after `version`, COMMENT='', DEFAULT CHARSET='utf8';
                          
                          alter table `Forum`.`pm` 
                              add column `importpmid` bigint(20)   NOT NULL DEFAULT '0' after `messageread`, COMMENT='', DEFAULT CHARSET='utf8';
                          
                          alter table `Forum`.`subscription` 
                              add column `importsubscriptionid` bigint(20)   NOT NULL DEFAULT '0' after `adminoptions`, COMMENT='', DEFAULT CHARSET='utf8';
                          
                          alter table `Forum`.`subscriptionlog` 
                              add column `importsubscriptionlogid` bigint(20)   NOT NULL DEFAULT '0' after `expirydate`, COMMENT='', DEFAULT CHARSET='utf8';
                          
                          alter table `Forum`.`thread` 
                              add KEY `importthread_index`(`importthreadid`), COMMENT='', DEFAULT CHARSET='utf8';
                          
                          alter table `Forum`.`usernote` 
                              add column `importusernoteid` bigint(20)   NOT NULL DEFAULT '0' after `allowsmilies`, COMMENT='', DEFAULT CHARSET='utf8';

                          Comment


                          • #14
                            This is going to be from running an older version of ImpEx where the import id's that were added to xsorbit were hard coded into the module opposed to using the ImpEx core ones.

                            It's been updated and will be fixed in the next ImpEx build.
                            I wrote ImpEx.

                            Blog | Me

                            Comment

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