Announcement

Collapse
No announcement yet.

Impex version number?

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

  • Impex version number?

    Hello, I just downloaded Impex from my members area.

    impex_[licensenumberremoved].zip

    I put it in the main forum folder and logged in to the admincp. There was a new Impex button. all looked well. When I clicked on it to open it, it says 1.59. Did I get the file from the wrong place? Where should I go to get the 1.60?

    Also, being the curious person I am, I tried to do an import from a txt file to see if i could add a couple users. An error came up and now i seem to be stuck in a loop at database clean up and restart.

    How do I kill whatever impex is doing and start over? I thought the database cleanup link would do that, but it looks like I muddled things up real good.

    I was using VB 3.6 and firefox 1.5.0.6 when this happened. VB is hosted on windows 2003 standard server.

    Thanks for any help.
    Last edited by Zachery; Mon 21 Aug '06, 2:21pm.

  • #2
    Whats the error being displayed in the loop ?

    browse directly to help.php in the impex folder and you can delete the impex session and start again.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      This is the first screen i got when i started the import.

      ImpEx build version : 1.59

      Database cleanup & restart ||| Online manual
      Using includes/config.php for target config.


      Altering tables

      ImpEx will now Alter the tables in the vB database to include import id numbers.
      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 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
      pm - importpmid OK
      usernote - importusernoteid OK

      There seems to have been a problem with the database.

      ImpEx Database errormysql error: Invalid SQL:
      INSERT INTO usergroup
      (
      importusergroupid, title, description,
      usertitle, passwordexpires, passwordhistory,
      pmquota, pmsendmax,
      opentag, closetag, canoverride,
      ispublicgroup, forumpermissions, pmpermissions,
      calendarpermissions, wolpermissions, adminpermissions,
      genericpermissions, genericoptions, attachlimit,
      avatarmaxwidth, avatarmaxheight, avatarmaxsize,
      profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize
      )
      VALUES
      (
      '69',
      'Imported Users',
      '',
      '',
      0,
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      '',
      ''
      )

      mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
      mysql error number: 1366
      Date: Friday 18th 2006f August 2006 03:25:47 PM
      Database: forum
      MySQL error: Incorrect integer value: '' for column 'passwordhistory' at row 1

      Comment


      • #4
        then if i hit database cleanup i get this

        Impex Help page

        ImpEx can not read the target database details from impex/ImpExConfig.php OR ../includes/config.php.
        Please enter the target database details in ImpExConfig, or run ImpEx installed opposed to standalone.

        I hit impex on the left and it will return me to the post above.

        Comment


        • #5
          You are running MySQL in STRICT mode, you'll have to set ImpEx to force the SQL mode :

          define('forcesqlmode', true);

          It's at the bottom of the config file.
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            Ok, i changed the forcesqlmode to true and the import went thru. I put people into the groups and places they needed to be. If I understand the directions correctly, the next step is to go up to the top of the page under the import section and hit Database cleanup & restart to remove the id's generated for the import. when I do that I get the following message.

            Impex Help page

            ImpEx can not read the target database details from impex/ImpExConfig.php OR ../includes/config.php.
            Please enter the target database details in ImpExConfig, or run ImpEx installed opposed to standalone.

            Comment


            • #7
              Not sure, what to say, the message is the answer, you'll have to put the target database details in ImpExConfig.php.
              I wrote ImpEx.

              Blog | Me

              Comment


              • #8
                hmm, I thought by default impex will read the details from includes/config.php so you don't need to set the target database details.

                Since it was able to import the names it means it is talking to the database, correct?

                Maybe I didn't configure the includes/config.php correctly? the boards seem to be working ok.

                Comment


                • #9
                  ImpEx does yes, though if help.php can't parse the config file, it uses the ImpExConfig.php file.
                  I wrote ImpEx.

                  Blog | Me

                  Comment


                  • #10
                    Ok. I updated the impex config file and everything seems to be happy. Now the only other thing was I see the version 1.59 at the top of each page. Where would I find a more current version of the impex software? I downloaded the one from my members area. I see on your signature that you are up to 1.62. Should I working about keeping up to the newer version or will the 1.59 work fine?

                    ImpEx build version : 1.59

                    Database cleanup & restart ||| Online manual
                    Using includes/config.php for target config.

                    Comment


                    • #11
                      Only if there is an issues with the version you have.
                      I wrote ImpEx.

                      Blog | Me

                      Comment

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