Announcement

Collapse
No announcement yet.

Can't import

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

  • Can't import

    Hello,
    I have just got my new forum up and running, so I was going to import from my old phpbb2 forum.
    I followed the impex manual, and tried to import, but something went wrong. This is what comes up when I press "Check and update database"


    ImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences 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 origional 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

    There seems to have been a slight problem with the database.
    Please try again by pressing the
    refresh button in your browser.
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
    We apologise for any inconvenience.



    Then nothing happens. What have I done wrong?

    J€bu.


    Wicked :)

  • #2
    Right click the page and select 'view source', the full database error will be in there.

    Comment


    • #3
      This is what I got when right-clicking:

      <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
      <html dir="ltr" lang="en">
      <head>
      <title>Import / Export - Source o Potatis Forums - vBulletin Admin Control Panel</title>
      <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
      <link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />

      <script language="JavaScript">
      <!--
      function SymError()
      {
      return true;
      }
      window.onerror = SymError;
      var SymRealWinOpen = window.open;
      function SymWinOpen(url, name, attributes)
      {
      return (new Object());
      }
      window.open = SymWinOpen;
      //-->
      </script>
      I don't have a clue.
      But if you could help me you would save me a lot of time and work.

      J€bu.
      Wicked :)

      Comment


      • #4
        That's the top part of the source, but not the bottom part.

        Below There seems to have been a slight problem with the database

        Comment


        • #5
          Oups..sorry.
          Heres everything...

          <head>
          <title>Import / Export - Source o Potatis Forums - vBulletin Admin Control Panel</title>
          <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
          <link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />

          <script language="JavaScript">
          <!--
          function SymError()
          {
          return true;
          }
          window.onerror = SymError;
          var SymRealWinOpen = window.open;
          function SymWinOpen(url, name, attributes)
          {
          return (new Object());
          }
          window.open = SymWinOpen;
          //-->
          </script>
          <script type="text/javascript">
          <!--
          var SESSIONHASH = "";
          function set_cp_title()
          {
          if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown' && typeof(parent.document.title) == 'string')
          {
          parent.document.title = (document.title != '' ? document.title : 'vBulletin');
          }
          }
          //-->
          </script>
          <script type="text/javascript" src="../clientscript/vbulletin_global.js"></script>
          </head>
          <body style="margin:0px" onload="set_cp_title();">
          <div class="pagetitle">Import / Export</div>
          <div style="margin:10px">
          <!-- END CONTROL PANEL HEADER -->
          <style type="text/css">.isucc { color: green; } .ifail { color: red; }</style><br> <div align="center"><a href="help.php">Database cleanup &amp; restart</a> ||| <a href="http://www.vbulletin.com/docs/html/impex" target="blank_"> Online manual</a></div><div align="center"> <p>Using includes/config.php for target config.</p></div><br>

          <!-- form started:6 queries executed -->
          <form action="index.php" name="cpform" method="post">
          <input type="hidden" name="do" value="001" />
          <br />
          <table cellpadding="4" cellspacing="0" border="0" align="center" width="90%" class="tborder">
          <h4>Altering tables</h4>ImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences 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 origional vB userid.
          <br /><b>moderator</b> - importmoderatorid <i>Completed</i>
          <br /><b>usergroup</b> - importusergroupid <i>Completed</i>
          <br /><b>ranks</b> - importrankid <i>Completed</i>
          <br /><b>poll</b> - importpollid <i>Completed</i>
          <br /><b>forum</b> - importforumid <i>Completed</i>
          <br /><b>forum</b> - importcategoryid <i>Completed</i>
          <br /><b>user</b> - importuserid <i>Completed</i>
          <br /><b>style</b> - importstyleid <i>Completed</i>
          <br /><b>thread</b> - importthreadid <i>Completed</i>
          <br /><b>post</b> - importthreadid <i>Completed</i>
          <br /><b>thread</b> - importforumid <i>Completed</i>
          <br /><b>smilie</b> - importsmilieid <i>Completed</i>
          <br /><b>pmtext</b> - importpmid <i>Completed</i>
          <br /><b>avatar</b> - importavatarid <i>Completed</i>
          <br /><b>customavatar</b> - importcustomavatarid <i>Completed</i>
          <br /><b>customprofilepic</b> - importcustomprofilepicid <i>Completed</i>
          <br /><b>post</b> - importpostid <i>Completed</i>
          <br /><b>attachment</b> - importattachmentid <i>Completed</i>
          <br /><b>pm</b> - importpmid <i>Completed</i><html><head><title> Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
          <body></table></td></tr></table></form>
          <blockquote><p class="error">&nbsp;</p><p class="error"><b>There seems to have been a slight problem with the database.</b><br />
          Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="<A href="mailto:">Technical">mailto:">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>
          <!--
          Database error in vBulletin:ImpEx Source :
          Invalid SQL: SHOW TABLES
          mysql error: No database selected
          mysql error number: 1046
          Date: Saturday 01st of October 2005 08:48:52 AM
          Script: http://sop.nu/forums/impex/index.php
          Referer:
          IP Address: 83.248.203.183
          -->
          </body></html>
          <script language="JavaScript">
          <!--
          var SymRealOnLoad;
          var SymRealOnUnload;
          function SymOnUnload()
          {
          window.open = SymWinOpen;
          if(SymRealOnUnload != null)
          SymRealOnUnload();
          }
          function SymOnLoad()
          {
          if(SymRealOnLoad != null)
          SymRealOnLoad();
          window.open = SymRealWinOpen;
          SymRealOnUnload = window.onunload;
          window.onunload = SymOnUnload;
          }
          SymRealOnLoad = window.onload;
          window.onload = SymOnLoad;
          //-->
          </script>
          J€bu.
          Wicked :)

          Comment


          • #6
            Invalid SQL: SHOW TABLES
            mysql error: No database selected
            mysql error number: 1046


            That gives me the impression that it can not select the right tablers, either those tables are not in the database, or the info for the source database is incorrect.

            Comment


            • #7
              Well, the php forum's db is called sourceo_phpbb1 and I have put this in ImpExConfig.php:

              $impexconfig['sourceexists'] = true;
              # mysql / mssql
              $impexconfig['source']['databasetype'] = 'mysql';
              $impexconfig['source']['server'] = 'localhost';
              $impexconfig['source']['user'] = '*******';
              $impexconfig['source']['password'] = '*******';
              $impexconfig['source']['database'] = 'phpbb1';
              $impexconfig['source']['tableprefix'] = 'sourceo_';

              Is that correct?

              J€bu.
              Wicked :)

              Comment


              • #8
                That would be the database name, not the table prefix. Look at the DB data, and see if there's anything in front of each table name, like phpbb_ or similar. It's that you need, not the one you have now.
                The database in the "['source']['database']" field gets the entire name: "sourceo_phpbb1"...same for username "sourceo_username".

                Comment


                • #9
                  Here is some of the content in that database:

                  sourceo_phpbb1.phpbb_auth_access
                  sourceo_phpbb1.phpbb_banlist
                  sourceo_phpbb1.phpbb_categories
                  sourceo_phpbb1.phpbb_config
                  sourceo_phpbb1.phpbb_confirm
                  sourceo_phpbb1.phpbb_disallow

                  Do you mean I should put phpbb_ as prefix instead of sourceo_?


                  J€bu.
                  Wicked :)

                  Comment


                  • #10
                    Yes, you need to use phpbb_ for the table prefix.
                    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


                    • #11
                      Thanks,
                      Now it worked. I also had to change the db-name from:
                      $impexconfig['source']['database'] = 'phpbb1';
                      to:
                      $impexconfig['source']['database'] = 'sourceo_phpbb1';

                      So I started to import stuff, and it seams it worked, here's what came up:

                      001Check and update database 19 01 sec(s)
                      002Associate Users 0 00 sec(s)
                      003Import usergroup 00 1 sec(s)
                      004Import user 11 01 sec(s)
                      005Import banlist 0 00 sec(s)
                      006Import forum 29 02 sec(s)
                      007Import thread 125 01 sec(s)
                      008Import smilie 0 00 sec(s)
                      009Import post 312 01 sec(s)
                      010Import poll 4 01 sec(s)
                      011Import Private messages 46 01 sec(s)
                      012Import rank 0 00 sec(s)
                      013Import attachment 0 01 sec(s)
                      Totals:546 010 sec(s)


                      But where can I find the threads and posts?? I cannot see them in the forum. Do you have to do something else after the import for them to show?

                      J€bu.
                      Wicked :)

                      Comment


                      • #12
                        As per the documention you need to update the thread and forum counters.

                        http://www.vbulletin.com/docs/html/impex_cleanup
                        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


                        • #13
                          OK, sorry, I forgot that.
                          But I'm sorry to say, my forum crashed with an database error. I cannot log in as user or in the adminCP. I dont know if it can be fixed, or if I have to reinstall the forum. Here's what I got:

                          Database error in vBulletin 3.5.0:

                          Invalid SQL:

                          SELECT * FROM cpsession
                          WHERE userid =
                          AND hash = 'e8157edddd5d6495a5ac728bb29ceefb'
                          AND dateline > 1128286739;

                          MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND hash = 'e8157edddd5d6495a5ac728bb29ceefb'
                          AND dateline > 1128286739' at line 3
                          Error Number : 1064
                          Date : Sunday, October 2nd 2005 @ 11:59:00 PM
                          Script : http://sop.nu/forums/admincp/index.php
                          Referrer :
                          IP Address : 83.248.203.183
                          Username :
                          Classname : vb_database
                          I have a database repairbutton in my serverCP and I tried that, but it didn't work. Do you know if it can be fixed?

                          J€bu.
                          Wicked :)

                          Comment


                          • #14
                            Run this query:

                            DELETE FROM cpsession;
                            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


                            • #15
                              Sounds like you associated yourself or cleaned out the importer ids after doing so.. which means you removed the default admin...

                              Comment

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