Simple Machines Community Forum

Software: AEF "Advanced Electron Forum"
Version: 1.0.x

This is the official support topic for AEF converter.  Use this topic to ask for support for this converter.

Note: This was tested on AEF 1.0.6, but should in theory work on other versions of AEF if the database changes have not been to great.

Changelog
! Forgot AEF Login Fix

How to convert
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.

Great Work Sleepy!

Hello

Sorry, but i didnt get, how do i suppose to use this converter?

Ive got the files but what sould i do now? 

Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)

Thanks, ThorstenE, worked for me!

Unbelievable! Great work!!   

• I am having a little trouble converting my board to SMF. :-\ My install of AEF is located at http://www.vfkboard.com/index.php? and my SMF convert install is located at http://www.vfkboard.com/smf/
  I have not deleted the .sql file or the http://www.vfkboard.com/smf/convert.php file, so you can go there and check it out. (If you are a tech, please PM me and I will give you my DB password so you can try it out)
  
  
  Please help me if you can.  >:(
  
  The error I always get is
  

  QuoteConverting...
  Converting members... Successful.
  Converting categories... Successful.
  Converting boards... Successful.
  Converting topics... Successful.
  Converting posts (this may take some time)... Successful.
  Converting polls... Successful.
  Converting poll options... Successful.
  Converting poll votes... Successful.
  Converting personal messages (step 1)... Successful.
  Converting personal messages (step 2)... Successful.
  Converting topic notifications... Successful.
  Converting board notifications... Unsuccessful!
  This query:
  INSERT INTO `vfkboard_smf`.smf_log_notify
  (ID_MEMBER, ID_TOPIC, sent)
  VALUES ('1', '5', '1'),
  ('44', '32', '1');
  Caused the error:
  
  Duplicate entry '1-5-0' for key 1
  

  Anyone know what could be causing this or how to help please? I really need to convert to SMF from AEF for users..

Open the .sql file

Find:
---* {$to_prefix}log_notify


Replace:
---* {$to_prefix}log_notify
---{
$ignore = true;
---}

This will tell it to ignore duplicate entry errors for that log.

Thanks! Now I will redo the whole install and install.

But, are members support to appear like this? -->  http://vfkboard.com/smf/index.php

Is that how the names where or registered?
It pulls that data from the AEF members database, so that info had to exist like that at one time.

Yes, it must be pulling the wrong stuff, then. I don't understand why though since Users Text was added in AEF a few version ago, around when this creator was made I would expect. It seems to be pulling the Users Text, not the Username. Is there anyway to alter this?

kab012345,

Would you if you still have your AEF database dump to me so I can test this locally?
This way I can find the issue and get it resolved as it makes testing easier :)

An email you can email me at is on our team page in About -> The Team

Quote from: SleePy on July 15, 2008, 01:16:40 AM
kab012345,

Would you if you still have your AEF database dump to me so I can test this locally?
This way I can find the issue and get it resolved as it makes testing easier :)

An email you can email me at is on our team page in About -> The Team

OK, I am assuming you want a copy of the DB? I will upload it to my site and email you the link at that email on that page. Please tell me when you have downloaded it so I can remove it.

Yes that will work :)
I won't get to my email until this afternoon or tonight after work though. Depends on college homework.

Great, thanks for the willingness.

Hi. :)

I just used this converter and for the most part, it looks OK, but some thing are a bit weird.

All of the user names are gone on the posts.

Everyone's password is wrong.  I see you have a login fix in your OP, but I don't see how to use it.

EDIT: clicking around, I see you can install it as a package. I uploaded it, installed it and it says it's running, but that's about it.  I don't see it taking immediate effect and I haven't found any extra admin sections added by it.  :o

Any help with this would be great, thanks!

Once you upload and the package was installed, then users who try to login should be able to.
It may be possible that Package Manager was unable to edit the files to make the changes but still said it installed. In this case you may need to manually install the mod (It only adds 1 line of code to 1 file, so it isn't to bad to get it done :) )

Hi, SleePy!

How do I go about doing that?

Also, I just noticed something going on with the polls.  The first letter in all the poll options is missing.

For example, it says:

lue is nice.
IGS IN SPACE!

When it's supposed to be "Blue is nice" and and "PIGS IN SPACE!".

(btw, I fixed the poll, so fixing it isn't a problem, but I'm bringing it up in case it's any insight in to other things that might arise, such as other tables that have missing stuff :) )

I think thats a bug in the polls :P

Open the .sql up
Find:
    poo_poid AS ID_POLL, pooid AS ID_CHOICE, SUBSTRING(poo_option, 2, 255) AS label, poo_votes AS votes

Replace:
    poo_poid AS ID_POLL, pooid AS ID_CHOICE, SUBSTRING(poo_option, 1, 255) AS label, poo_votes AS votes

The converter would need to be reran :(

Haha.  Thanks.  Polls are fixed. :)

For the user name stuff I just went ahead and retyped them, as there aren't a lot of users on the board yet.

As for the password thing, the password reset works, so I'm just gonna tell people to do that.

If I run in to anything else I'll let you know.  Thanks again for your converter, it saved me a lot of hassle. :)

-

Hello,


Just wondering, but is there any progress on what the issue might be with my DB?

I don't see why it would be failing.
Looking at the database It should be doing its job right.

Which memebers ids where it again that had this issue?

The issue it had was thinking the usernames of my members was the private text that they can set in their profile.

The one that was displayed right?

If that is the one.
Then open the .sql file
Find:
    SUBSTRING(IFNULL(realname, username), 1, 255) AS realName,

replace:
    SUBSTRING(username, 1, 255) AS realName,

That should fix it if the one that is displayed is containing this text.

The converter is great, all went ok :)

you need to install the  aef_login_fix.tgz  via package manager to get the old passwords working.. you can reset your admin password with the forgotten passwords link from SMF, then install the  aef_login_fix.tgz  (attached on the first post of this topic)

only one question...i noticed after the conversion, that usernames are not displayed anymore

http://www.ingegneria.medusaworks.it/smf/index.php

why????

Quote from: SleePy on August 22, 2008, 11:05:09 PM
The one that was displayed right?

If that is the one.
Then open the .sql file
Find:

Code Select Expand

    SUBSTRING(IFNULL(realname, username), 1, 255) AS realName,

replace:

Code Select Expand

    SUBSTRING(username, 1, 255) AS realName,

That should fix it if the one that is displayed is containing this text.

This is what I had to do.

tnx a lot kab!

Mine is failing REALLY BADDLY?
I'm getting nothing over at all but it says it was sucessfull?

Here is what I'm putting in

Path to SMF: E:\Backup\wwwroot\Marsforums\Beta
Path to AEF: E:\Backup\wwwroot\Marsforums
My DB password
ISO-8859-1

I'm using the same user name for SMF as AEF and giving that user access to both databases.
So I have two diffrent databases one for AEF and one new one for SMF

My SMF installation is working great, and my AEF is working but I hate their buggy software which is why we are moving...

Anyways when I run convert I get this....
(http://www.steveries.com/temp/convert.jpg)


And NOTHING has changed in the SMF forums or it's database???
Help?

Thanks in advance, I'm really looking forward to getting all 130 of my board members over to this software. We have had it with AEF to dang buggy!!!!

Nevermind!!!
I found the problem in a stickey!

php.ini needs access to the session dir...

So then I would sugest someone put that as an error rather than saying it was sucessful??

Another stupid question.
Trying to install SMF 2.0 and convert from AEF

I get this error
Converting members... Unsuccessful!
This query:
INSERT INTO `MarsForums`.smf_members
(ID_MEMBER, memberName, dateRegistered, posts, passwd, websiteTitle, websiteUrl, lastLogin, birthdate, ICQ, realName, notifyOnce, lngfile, emailAddress, AIM, personalText, hideEmail, memberIP, memberIP2, YIM, gender, MSN, signature, location, timeOffset, avatar, usertitle, pm_email_notify, karmaBad, karmaGood, notifyAnnouncements, secretQuestion, secretAnswer, ID_GROUP, buddy_list, pm_ignore_list, messageLabels, validation_code, additionalGroups, smileySet, passwordSalt)
VALUES

Then all my users data.....

Caused the error:
Unknown column 'memberName' in 'field list'

sorry, but you used the wrong SMF version. the converter is for SMF 1.1.x (1.1.8) only. Converters for SMF 2.0 RC are still in developement.

Doh!
ok thanks, I feel even dumber now! :)

Aef to smf 2 converter:

I get this error:

Converting members... Unsuccessful!
This query:

    SELECT
    id AS id_member, SUBSTRING(username, 1, 80) AS member_name,
    r_time AS date_registered, posts, SUBSTRING(password, 1, 64) AS passwd,
    SUBSTRING(www, 1, 255) AS website_title,
    SUBSTRING(www, 1, 255) AS website_url, last_login AS last_login,
    birth_date AS birthdate, SUBSTRING(icq, 1, 255) AS icq,
    SUBSTRING(IFNULL(realname, username), 1, 255) AS real_name,
    SUBSTRING(email, 1, 255) AS email_address, language AS lngfile,
    SUBSTRING(aim, 1, 16) AS aim, SUBSTRING(users_text, 1, 255) AS personal_text,
    hideemail AS hide_email, SUBSTRING(r_ip, 1, 255) AS member_ip,
    SUBSTRING(r_ip, 1, 255) AS member_ip2,
    SUBSTRING(yim, 1, 32) AS yim, gender,
    SUBSTRING(msn, 1, 255) AS msn,
    SUBSTRING(REPLACE(sig, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(location, 1, 255) AS location, timezone AS time_offset,
    SUBSTRING(avatar, 1, 255) AS avatar,
    SUBSTRING(users_text, 1, 255) AS usertitle,
    pm_email_notify AS pm_email_notify, '' AS karma_bad, '' AS karma_good,
    adminemail AS notify_announcements,
    '' AS secret_question,
    '' AS secret_answer,
    IF(u_member_group = 1, 1, IF(u_member_group = -3, 9, u_member_group + 10)) AS id_group, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS message_labels, '' AS validation_code, '' AS additional_groups,
    '' AS smiley_set, salt AS password_salt
    FROM `aeftest`.aef_users
    LIMIT 0, 500;

Caused the error:

    Unknown column 'last_login' in 'field list'



Te converter only break the login no more :(

aritmos, is there a column "last_login" on the table "aef_users"? can you check this with phpMyAdmin please: What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)