Ikonboard_SQL - Import Questions

[mayhemmike]

Howdy

Background: Importing from Ikonboard 3.1.2a. I currently have over 8000 users, total of 288836 posts (272350 replies to 16486 Topics) and over a Gig of attachments.

1) Passwords: Got the import to work. However, passwords did not come through. Is there a switch I need to implement in one of the php files in the ImPex folder? Only file I found denoting passwords was 004.php:


// Non Mandatory
$try->set_value('nonmandatory', 'membergroupids', '');
$try->set_value('nonmandatory', 'displaygroupid', '0');
$try->_password_md5_already = true;
$try->set_value('nonmandatory', 'password', $user_details['MEMBER_PASSWORD']);
$try->set_value('nonmandatory', 'passworddate', time());

2) Attachments: During the iport process, it asked for an upload folder directory : "Path to avatar upload folder"

I am not clear what folder path it is looking for and for which side? IB or vB?
Also, should something in the Admin Control panel be switched on or off before I proceed?

Thanx, and am looking for ward to contributing as well as using the new board.

Mike...
http://www.musclemayhem.com

[hjmaier]

Ikonboard Imported issues are now known for month. It turns slowly really urgent!

I really would like to know, when the bugs will be fixed! It need to be fixed soon!

hj

[hjmaier]

Well, slowly i really get upset becuase of the still open issues with the Ikonboard Konverter. How long do you want to make us wait till the long known bugs are fixed?

hj

[Zachery]

Jerry was away, and he has returned, are the bugs you are reporting in the bug tracker?

[hjmaier]

Since over a month.

hj

[PumpkinKing]

1) Passwords: Got the import to work. However, passwords did not come through. Is there a switch I need to implement in one of the php files in the ImPex folder? Only file I found denoting passwords was 004.php:


// Non Mandatory
$try->set_value('nonmandatory', 'membergroupids', '');
$try->set_value('nonmandatory', 'displaygroupid', '0');
$try->_password_md5_already = true;
$try->set_value('nonmandatory', 'password', $user_details['MEMBER_PASSWORD']);
$try->set_value('nonmandatory', 'passworddate', time());

I'm having this problem myself. None of the passwords carried over in the update. In fact the only way to access my AdminCP is to use the account "administrator" that I created when I set up the forums. Trying to log in with my PumpkinKing account tells me "Thanks for logging in..." and then directs me back to logging in. I had to change my PumpkinKing account's password in the Admin CP in order to be able to log into the regular forums. Please help. :)

[Zachery]

Did you make Pumpkining an admin?

[PumpkinKing]

:o I have now but when I log in to the AdminCP it doesn't show the same options as my Administrator account.

[Steve Machol]

You need to set those options from your other account:

Admin CP -> Usergroups -> Administrator Permissions

[PumpkinKing]

You need to set those options from your other account:

Admin CP -> Usergroups -> Administrator Permissions

Heh. I unfortunately misunderstood a section on the config and had to go in and make a superadministrator. Then I could edit the Administrator Permissions. Any word on a fix for the password situation or will everyone need to reset their passwords upon return?

Thanks for the help with the other problems I was experiencing by the way. :)

[Steve Machol]

No sorry. I have no idea how to fix the password issues. Hopefully Jerry will chime in soon.

[mayhemmike]

I have my upgrade on hold until I can get help resolving the password issue. I have over 8,000 members and I very much would hate to have them all request new passwords.

Mike...

[Jerry]

Here now, back from holiday !

Are the passwords in the target database completely blank ? i.e. they arn't being imported at all or there is something there and its not working, i.e. they are being imported incorrectly ?

[PumpkinKing]

Not exactly sure what I am looking for (still very new to MySQL) but it doesn't appear that the table is empty this is what I see in my SQL admin section:


password char(32) No Change Drop Primary Index Unique Fulltext

[Jerry]

The importer looks in the source database for:

ib_member_profiles.MEMBER_PASSWORD

Which is a varchar(32), which I belive to be an md5, then imports that as it does any other md5 source password.

I'll have to review it to see if it is manipulated in any other way by ikonboard.

[mayhemmike]

Thanx for jumping in.

Also, I still have not resolved my attachment issues.

None of the attachements come through.

Thanx,

Mike...



The importer looks in the source database for:

ib_member_profiles.MEMBER_PASSWORD

Which is a varchar(32), which I belive to be an md5, then imports that as it does any other md5 source password.

I'll have to review it to see if it is manipulated in any other way by ikonboard.

[PumpkinKing]

Hate to be a bother but have you made any inroads on the passwords not transferring?

[Jerry]

Hate to be a bother but have you made any inroads on the passwords not transferring?

Trying to replicate it at the moment.

[Jerry]

Have to confirm that the origional password is just an md5 and nothing else, if it is manipulated in any other way it probally won't be able to be imported.

[PumpkinKing]

Have to confirm that the origional password is just an md5 and nothing else, if it is manipulated in any other way it probally won't be able to be imported.

I'm sorry but what does this mean? I haven't done any manipulation with any of the data in the Ikonboard files.

[hjmaier]

I'm sorry but what does this mean? I haven't done any manipulation with any of the data in the Ikonboard files.
Jerry means, that he need to check if Ikonboard stores the password as pure md5.

hj

[Jerry]

Jerry means, that he need to check if Ikonboard stores the password as pure md5.

hj

Correct.

I have done yabb-gold which was waiting and now I'm bug fixing things like this and investigating why this isn't working correctly.

[Jerry]

http://www.vbulletin.com/forum/bugs.php?do=view&bugid=3064

It is not a MD5 of the password, it is a combination of the username and the original password. Therefore the password can not be imported or extrapolated.

Using the request password functionality in vBulletin 3 is the advised route.

[hjmaier]

http://www.vbulletin.com/forum/bugs.php?do=view&bugid=3064

It is not a MD5 of the password, it is a combination of the username and the original password. Therefore the password can not be imported or extrapolated.

Using the request password functionality in vBulletin 3 is the advised route.
Thats pity.

Well, lets see if my member updated their Email Adresses if they changed :D

But anyway, thank you Jerry for your investigation.

hj

[Jerry]

Thats pity.

Well, lets see if my member updated their Email Adresses if they changed :D

But anyway, thank you Jerry for your investigation.

hj

Its a good way of ensuring security as well, as the users will have to pro-actively get a new password and it will have to be via their email etc.

[PumpkinKing]

Ah. Thanks for looking into it. I'll let the folks know they need to reset their password.

[hjmaier]

Thanx for jumping in.

Also, I still have not resolved my attachment issues.

None of the attachements come through.

Thanx,

Mike...
There is still the attachment issue open. Unfortunatly, he did not open a ticket in the bug Tracker ... Do you look at it, Jerry, or do i need to make a test myself and put it in the tracker?

hj

[Jerry]

There is still the attachment issue open. Unfortunatly, he did not open a ticket in the bug Tracker ... Do you look at it, Jerry, or do i need to make a test myself and put it in the tracker?

hj

I'm going through all the bugs in the tracker at the moment, I've not come accross that one.

I would suggest posting a bug describing what is going on as I check the import bugs when I get to work first thing now.

[hjmaier]

I'm going through all the bugs in the tracker at the moment, I've not come accross that one.

I would suggest posting a bug describing what is going on as I check the import bugs when I get to work first thing now.
I just hat time to test the Attachment import. I reported a bug in the tracker.

hj