Announcement

Collapse
No announcement yet.

Stuck with Impex

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

  • Stuck with Impex

    Im currently on a free forum, I bought the database and its sitting on my PC. The Free Forum sent me a tar.gz file.

    Code:
    ####
    #
    # SOURCE - The source is the old forum database (where the  data is coming from)
    #
    ####
    
    # mysql / mssql
    $impexconfig['source']['databasetype']    = 'mysql';  // mysql OR mssql
    $impexconfig['source']['server']        = 'localhost';
    $impexconfig['source']['user']            = '***************';
    $impexconfig['source']['password']        = '********************';
    $impexconfig['source']['database']        = 'source';
    $impexconfig['source']['tableprefix']   = '';

    Im not sure what to type here as the files are sitting on my desktop
    Ringnews24's KO Boxing Forum
    www.koboxingforum.com

    I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

  • #2
    You need to import the database file into a real database on your server.

    If it's not too big you may be able to import directly from phpmyadmin. If it's too big to upload via PHP however you would need to use a utility like bigdump (google it) to import the data.

    Comment


    • #3
      zip file 27.7 mb
      Uzipped 88.5 mb


      What should I use Joe, BigDump or Phpmyadmin?

      Thanks

      - - - Updated - - -

      I tried to install via myphpadmin and got the following error

      MySQL said:
      #1064 - 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 'budweiserboxing_attachments_config.sql' at line 1
      Ringnews24's KO Boxing Forum
      www.koboxingforum.com

      I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

      Comment


      • #4
        I would try via bigdump at that size.

        You may need to create a specific database or possibly edit the SQL file before importing if the database name you are trying to import to can't be created on your host.

        Comment


        • #5
          Im trying Big Dump but after a few seconds the page says

          "The connection to the server was reset while the page was loading."

          - - - Updated - - -

          After it not working via the web browser, I decided to do it via the bigdump FTP option and got the following error

          Error at the line 22: DROP TABLE IF EXISTS `budweiserboxing_attachments_config`;
          Query: budweiserboxing_attachments_config.sql0000644000000000000000000000552312044053165017422 0ustar rootroot-- MySQL dump 10.11
          --
          --
          --
          DROP TABLE IF EXISTS `budweiserboxing_attachments_config`
          MySQL: 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 'budweiserboxing_attachments_config.sql' at line 1
          Ringnews24's KO Boxing Forum
          www.koboxingforum.com

          I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

          Comment


          • #6
            It seems like the .SQL file is not formatted correctly to be uploaded to your server. We could go back and forth on this a dozen times with little changes but if you can PM me FTP access so I can download the .SQL file I can take a look and see if I see the real problem.

            Comment


            • #7
              Thanks Joe, Ill pm you the FTP info just now
              Ringnews24's KO Boxing Forum
              www.koboxingforum.com

              I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

              Comment


              • #8
                OK, I had to combine the SQL files and clean them up a little- responded back- you should be set now.

                Comment


                • #9
                  Replied, Thanks Joe.

                  Ill give it a bash :-)

                  - - - Updated - - -

                  Internal Server Error

                  The server encountered an internal error or misconfiguration and was unable to complete your request.
                  Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
                  More information about this error may be available in the server error log.

                  Apache Server at www.ringnews24.com Port 80

                  I tried to import the database via the online url option. It came up with that error within seconds.

                  - - - Updated - - -

                  -------------------------------------------------------------------------------------------------------------------------------------------------

                  I then tried to upload it via Myphpadmin and it said

                  Error

                  SQL query:
                  --
                  -- Table structure for table `budweiserboxing_attachments`
                  --
                  DROP TABLE IF EXISTS `budweiserboxing_attachments` ;


                  MySQL said:
                  #1046 - No database selected
                  Ringnews24's KO Boxing Forum
                  www.koboxingforum.com

                  I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

                  Comment


                  • #10
                    Originally posted by Joe D. View Post
                    OK, I had to combine the SQL files and clean them up a little- responded back- you should be set now.
                    The Server did the import for me Joe, thanks for your advice.

                    However when I log into my Admin CP, and run Impex i get the following error.


                    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
                    filedata - importfiledataid Completed
                    Testing source against : phpBB2 ::2.0.22


                    Valid found tables :


                    Possibly custom tables or incorrect prefix :

                    attachments NOT found.
                    attachments_desc NOT found.
                    auth_access NOT found.
                    banlist NOT found.
                    categories NOT found.
                    config NOT found.
                    confirm NOT found.
                    disallow NOT found.
                    forum_prune NOT found.
                    forums NOT found.
                    groups NOT found.
                    posts NOT found.
                    posts_text NOT found.
                    privmsgs NOT found.
                    privmsgs_text NOT found.
                    ranks NOT found.
                    search_results NOT found.
                    search_wordlist NOT found.
                    search_wordmatch NOT found.
                    sessions NOT found.
                    smilies NOT found.
                    themes NOT found.
                    themes_name NOT found.
                    topics NOT found.
                    topics_watch NOT found.
                    user_group NOT found.
                    users NOT found.
                    vote_desc NOT found.
                    vote_results NOT found.
                    vote_voters NOT found.
                    words NOT found.

                    If you have all red tables, i.e. none correct this could possible be your table prefix :

                    budweiserboxing_
                    Failed Check database permissions and connection, or table prefix to ensure its correct
                    Ringnews24's KO Boxing Forum
                    www.koboxingforum.com

                    I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

                    Comment


                    • #11
                      Sounds like you missed to enter the prefix 'budweiserboxing_' in your config file?
                      No private support, only PM me when I ask for it. Support in the forums only.

                      Comment


                      • #12
                        How do i sort that? I named the db budweiserboxing not budweiserboxing_
                        Ringnews24's KO Boxing Forum
                        www.koboxingforum.com

                        I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

                        Comment


                        • #13
                          In the ImpExConfig.php file for impex, for the source data there is a line for the table prefix. Put budweiserboxing_ as the table prefix.

                          Comment


                          • #14
                            I changed the source - $impexconfig['source']['tableprefix'] = 'budweiserboxing_';

                            Do I also change the target file $impexconfig['target']['tableprefix'] = 'Boxing_Forum_'; ??
                            Ringnews24's KO Boxing Forum
                            www.koboxingforum.com

                            I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

                            Comment


                            • #15
                              If you used that prefix in the database for that: yes.
                              No private support, only PM me when I ask for it. Support in the forums only.

                              Comment

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