[SMF Converter] AEF 1.0.x

[SleePy]

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?

[kab012345]

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

[SleePy]

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.

[scimmiotto]

The converter is great, all went ok

[ThorstenE]

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)

[scimmiotto]

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

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

why?

[kab012345]

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.

[scimmiotto]

tnx a lot kab!

[funman1]

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....



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!!!!

[funman1]

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??

[funman1]

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'

[ThorstenE]

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

[funman1]

Doh!
ok thanks, I feel even dumber now!

[aritmos]

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

[ThorstenE]

aritmos, is there a column "last_login" on the table "aef_users"? can you check this with phpMyAdmin please: What is phpMyAdmin?