Advertisement:

Author Topic: [SMF Converter] AEF 1.0.x  (Read 28182 times)

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,951
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
[SMF Converter] AEF 1.0.x
« on: May 04, 2008, 01:35:42 AM »
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 with the .sql file attached in this topic.
« Last Edit: July 18, 2009, 02:38:14 PM by TE »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline mcblaber

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 11,189
  • Gender: Male
    • mcblaber on LinkedIn
    • @mcblaber on Twitter
    • AvatarPrime
Re: [SMF Converter] AEF 1.0.x
« Reply #1 on: May 06, 2008, 04:34:29 PM »
Great Work Sleepy!
M. Colin Blaber
Formally known as shadow82x
SMF Support Specialist

SMF2.1 Alpha Playground

Offline jazz1

  • Semi-Newbie
  • *
  • Posts: 49
Re: [SMF Converter] AEF 1.0.x
« Reply #2 on: June 19, 2008, 07:01:08 AM »
Hello

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

Ive got the files but what sould i do now? 

ThorstenE

  • Guest
Re: [SMF Converter] AEF 1.0.x
« Reply #3 on: June 19, 2008, 09:10:42 AM »

Offline jazz1

  • Semi-Newbie
  • *
  • Posts: 49
Re: [SMF Converter] AEF 1.0.x
« Reply #4 on: June 19, 2008, 05:43:31 PM »
Thanks, ThorstenE, worked for me!
 
Unbelievable! Great work!!   

Offline kab012345

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] AEF 1.0.x
« Reply #5 on: July 09, 2008, 04:17:12 PM »
  • I am having a little trouble converting my board to SMF. :-\ My install of AEF is located at hxxp:www.vfkboard.com/index.php? [nonactive] and my SMF convert install is located at hxxp:www.vfkboard.com/smf/ [nonactive]
    I have not deleted the .sql file or the hxxp:www.vfkboard.com/smf/convert.php [nonactive] 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
    Quote
    Converting...
    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..

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,951
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] AEF 1.0.x
« Reply #6 on: July 09, 2008, 07:33:53 PM »
Open the .sql file

Find:
Code: [Select]
---* {$to_prefix}log_notify

Replace:
Code: [Select]
---* {$to_prefix}log_notify
---{
$ignore = true;
---}

This will tell it to ignore duplicate entry errors for that log.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline kab012345

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] AEF 1.0.x
« Reply #7 on: July 09, 2008, 09:34:02 PM »
Thanks! Now I will redo the whole install and install.

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

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,951
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] AEF 1.0.x
« Reply #8 on: July 09, 2008, 09:36:38 PM »
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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline kab012345

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] AEF 1.0.x
« Reply #9 on: July 09, 2008, 09:41:20 PM »
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?

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,951
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] AEF 1.0.x
« Reply #10 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
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline kab012345

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] AEF 1.0.x
« Reply #11 on: July 15, 2008, 11:46:41 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.

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,951
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] AEF 1.0.x
« Reply #12 on: July 15, 2008, 01:09:32 PM »
Yes that will work :)
I won't get to my email until this afternoon or tonight after work though. Depends on college homework.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline kab012345

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] AEF 1.0.x
« Reply #13 on: July 15, 2008, 05:01:53 PM »
Great, thanks for the willingness.

Hamst3r

  • Guest
Re: [SMF Converter] AEF 1.0.x
« Reply #14 on: August 05, 2008, 10:47:30 PM »
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!
« Last Edit: August 05, 2008, 10:56:49 PM by Hamst3r »

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,951
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] AEF 1.0.x
« Reply #15 on: August 06, 2008, 12:38:44 AM »
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 :) )
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Hamst3r

  • Guest
Re: [SMF Converter] AEF 1.0.x
« Reply #16 on: August 06, 2008, 01:17:49 AM »
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 :) )
« Last Edit: August 06, 2008, 01:27:46 AM by Hamst3r »

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,951
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] AEF 1.0.x
« Reply #17 on: August 06, 2008, 01:28:19 AM »
I think thats a bug in the polls :P

Open the .sql up
Find:
Code: [Select]
    poo_poid AS ID_POLL, pooid AS ID_CHOICE, SUBSTRING(poo_option, 2, 255) AS label, poo_votes AS votes
Replace:
Code: [Select]
    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 :(
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Hamst3r

  • Guest
Re: [SMF Converter] AEF 1.0.x
« Reply #18 on: August 06, 2008, 01:37:36 AM »
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. :)

-

Offline kab012345

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] AEF 1.0.x
« Reply #19 on: August 18, 2008, 09:34:56 AM »
Hello,


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