Impex version number?

[ray8888888]

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.

[Jerry]

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.

[ray8888888]

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

[ray8888888]

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.

[Jerry]

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.

[ray8888888]

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.

[Jerry]

Not sure, what to say, the message is the answer, you'll have to put the target database details in ImpExConfig.php.

[ray8888888]

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.

[Jerry]

ImpEx does yes, though if help.php can't parse the config file, it uses the ImpExConfig.php file.

[ray8888888]

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.

[Jerry]

Only if there is an issues with the version you have.