Can I get some direction here!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • juanporro
    Member
    • Mar 2009
    • 41

    Can I get some direction here!!

    I started to do my import.

    First of all this is an SMF 2.0RC1 import that I am trying to do.

    I think I got all the setup right except when I try to do the first module this message comes along:


    ImpEx Database errormysql error: Invalid SQL: SHOW TABLES

    mysql error: No database selected

    mysql error number: 1046

    Date: Saturday 28th 2009f March 2009 03:09:26 PM
    Database: armyride_smf01
    MySQL error: No database selected



    What can I do? Any ideas?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    That error means that you have not edited the db info in ImpExConfig.php correctly. make sure the target info is the vB database and the source info is SMF.
    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

    • juanporro
      Member
      • Mar 2009
      • 41

      #3
      $impexconfig['target']['server'] = 'localhost';
      $impexconfig['target']['user'] = 'armyride_crank';
      $impexconfig['target']['password'] = '********';
      $impexconfig['target']['database'] = 'armyride_import';
      $impexconfig['target']['tableprefix'] = '';

      # If the system that is being imported from uses a database,
      # enter the details for it here and set 'sourceexists' to true.
      # If the source data is NOT stored in a database, set 'sourceexists' to false

      $impexconfig['sourceexists'] = true;

      ####
      #
      # 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'] = 'armyride_crank';
      $impexconfig['source']['password'] = '*******';
      $impexconfig['source']['database'] = 'armyride_smf01';
      $impexconfig['source']['tableprefix'] = '';




      Please point to me where my mistake is. Everything is correct and I have checked this more than 10 times before I posted for help and checked again after your message.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        First we have no way of know what your db info should be so asking us to correct it is not in the cards.

        One thing to check - is your SMF database using a table prefix such as: smf_

        [I removed your password.]
        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

        • juanporro
          Member
          • Mar 2009
          • 41

          #5
          Originally posted by Steve Machol
          First we have no way of know what your db info should be so asking us to correct it is not in the cards.

          One thing to check - is your SMF database using a table prefix such as: smf_

          [I removed your password.]
          Nope that was not it. I am stuck now. I cannot even do a practice run at this.

          What else?
          Last edited by juanporro; Sat 28 Mar '09, 1:42pm.

          Comment

          • juanporro
            Member
            • Mar 2009
            • 41

            #6
            I am really stuck here. I cannot get it to pass that point.

            Any other help will be appreciated.

            Comment

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

              #7
              99.999% that this is permissions, as there are different table prefixes I would try putting all the tables in the same database with a username and password that you know works.
              I wrote ImpEx.

              Blog | Me

              Comment

              • juanporro
                Member
                • Mar 2009
                • 41

                #8
                Originally posted by Jerry
                99.999% that this is permissions, as there are different table prefixes I would try putting all the tables in the same database with a username and password that you know works.
                You just talked all chinese to me. Dumb it down a bit and I will get off your hair.

                Thanks

                Comment

                • juanporro
                  Member
                  • Mar 2009
                  • 41

                  #9
                  Asking for help here is like pulling teeth. An enjoyable experience. Close this thread please. Its fixed now.

                  Comment

                  • Steve Machol
                    Former Customer Support Manager
                    • Jul 2000
                    • 154488

                    #10
                    In fact we did try to help. Perhaps you could be kind enough to share the solution with us so we can provide better info the next time.
                    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

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