[BETA] SMF 1.0.x Converter

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky » Wed Feb 15, 2006 3:41 pm

idburns wrote: I can't browse the phpbb_words table in phpMyAdmin...I'm guessing because it's empty.

Check the phpbb_banlist table. Is there anything there?
Have you hugged someone today?

idburns
Registered User
Posts: 140
Joined: Sat Apr 20, 2002 4:50 pm
Location: Fairfax, VA
Contact:

Post by idburns » Wed Feb 15, 2006 4:12 pm

I have the following:

Code: Select all

  ban_id  ban_userid  ban_ip  ban_email  
      1 0   richie.cahill@gmail.com 
      2 0   smyth_kev@hotmail.com 
      3 13   NULL 
      4 110   NULL 
      5 0 ff06b04b NULL 
      6 0 ff0722c3 NULL 
      7 0 ffc69781 NULL 
I'm thinking I should just nuke those records, even if they aren't part of my problem, because they seem incomplete.
]

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky » Wed Feb 15, 2006 4:50 pm

Delete #3 and #4 and try to register.
Have you hugged someone today?

idburns
Registered User
Posts: 140
Joined: Sat Apr 20, 2002 4:50 pm
Location: Fairfax, VA
Contact:

Post by idburns » Wed Feb 15, 2006 5:37 pm

I deleted the two records and still can't register.
]

SlapShot434
Registered User
Posts: 364
Joined: Wed May 12, 2004 2:43 am

Post by SlapShot434 » Wed Feb 15, 2006 11:14 pm

check phpbb_disallow
PLEASE NOTE: I have left the coding community and no longer provide support for any coding I may have contributed to in the past. I apologize for the inconvenience and fully welcome anyone perfecting my code for the betterment of this community.

idburns
Registered User
Posts: 140
Joined: Sat Apr 20, 2002 4:50 pm
Location: Fairfax, VA
Contact:

Post by idburns » Thu Feb 16, 2006 2:35 am

SlapShot434 wrote: check phpbb_disallow


Hmm, disallow_id 1 is empty...this might be the culprit. Deleting that record now.
]

idburns
Registered User
Posts: 140
Joined: Sat Apr 20, 2002 4:50 pm
Location: Fairfax, VA
Contact:

Post by idburns » Thu Feb 16, 2006 2:37 am

idburns wrote:
SlapShot434 wrote:check phpbb_disallow


Hmm, disallow_id 1 is empty...this might be the culprit. Deleting that record now.


That did it!

Excellent work gents.

Also, slash I really want to tell you that you did a fantastic job on this converter. It did a great job with the avatars, sigs, ranks, etc. Top notch work!
]

SlapShot434
Registered User
Posts: 364
Joined: Wed May 12, 2004 2:43 am

Post by SlapShot434 » Thu Feb 16, 2006 4:52 am

thank you very much, you dont know how excited I am to hear that it worked! Now i guess i have to figure out how to stop the blank disallow field.
PLEASE NOTE: I have left the coding community and no longer provide support for any coding I may have contributed to in the past. I apologize for the inconvenience and fully welcome anyone perfecting my code for the betterment of this community.

idburns
Registered User
Posts: 140
Joined: Sat Apr 20, 2002 4:50 pm
Location: Fairfax, VA
Contact:

Post by idburns » Fri Feb 17, 2006 3:15 pm

Let me add, that a bunch of my quotes didn't migrate correctly. I just chalked this up to the different way that SMF handles the tagging for it.

I personally don't care, but I'm sure there will be some picky people out there that will need it to be done correctly.

While writing this post I've tried to find some examples...but it appears to be random. I found a bunch that didn't migrate properly that had this opening tag:

Code: Select all

[quote="Username"]
But I've also found plenty that had the same opening tag that did migrate properly...I'm confused.

When I edit the post and just save it, without making any changes, the quote box then appears correctly.

I don't think this has anything to do with your converter...just a quirk that I thought folks should know about.
]

SlapShot434
Registered User
Posts: 364
Joined: Wed May 12, 2004 2:43 am

Post by SlapShot434 » Fri Feb 24, 2006 12:33 am

Hey guys, just an update: Theres still a few bugs left, thought these are minor compared to some of the past bugs I've encountered. The laptop I usually use for programming and coding was recently damaged beyond repair (the logistics board literally set itself on fire!), so I really have not had much time to put effort into completing the converter. However, I am buying a new laptop in a few days, and will be able to set up a enw temporary server to test out different debugging senerios.

As I've said before, the only way i can truely test out the forum is with an actual database from an actual SMF Forum. Therefore, if anyone would be willing to donate a copy of their database to me, I'd certainly appreciate it. Let me assure you all data will be kept safe and confidential, and the copy will be permanantly erased following successful conversion. Please get back to me as soon as possible if you are willing to help.

Thanks guys, and happy coding,
Matt
PLEASE NOTE: I have left the coding community and no longer provide support for any coding I may have contributed to in the past. I apologize for the inconvenience and fully welcome anyone perfecting my code for the betterment of this community.

Pablasso
Registered User
Posts: 123
Joined: Sat Nov 09, 2002 8:45 pm
Location: Guadalajara, Mexico

Post by Pablasso » Tue Mar 07, 2006 5:14 am

i got this error this time, any suggestions? :?

Code: Select all

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 4

SELECT messages.ID_MSG, messages.ID_TOPIC, messages.ID_BOARD, messages.ID_MEMBER, messages.posterName, messages.posterTime, messages.posterIP, messages.smileysEnabled, messages.modifiedTime, messages.modifiedName FROM smf_messages messages LEFT JOIN smf_topics AS topics USING (ID_TOPIC) LIMIT 33220, -1

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky » Tue Mar 07, 2006 1:39 pm

Pablasso wrote: i got this error this time, any suggestions? :?

Code: Select all

<----snip---->

You have run this convertor before and not gotten this error?

What MySQL version do you have? Did you recently upgrade? I think this is a problem with MySQL 4.1.x, but I am not sure how to fix it yet.
Have you hugged someone today?

Pablasso
Registered User
Posts: 123
Joined: Sat Nov 09, 2002 8:45 pm
Location: Guadalajara, Mexico

Post by Pablasso » Tue Mar 07, 2006 4:43 pm

im using mysql-4.1.14 and i got this error everytime i use it, the problem could be that i converted my db from phpBB to smf first and im trying to get it back to phpBB again

fcarentz
Registered User
Posts: 4
Joined: Wed Mar 15, 2006 7:25 pm
Location: New York

Post by fcarentz » Thu Mar 16, 2006 2:05 am

Hey guys, the link here for the smf convertor seems to be dead. I get a Cannot Find Page when clicking the link in the first post. Does anyone have a working link to the zip file for this?

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky » Thu Mar 16, 2006 2:41 am

fcarentz wrote: Hey guys, the link here for the smf convertor seems to be dead. I get a Cannot Find Page when clicking the link in the first post. Does anyone have a working link to the zip file for this?


smf 1.0.x convertor

Sourceforge is having some page loading problems at the present time, so keep trying. The file is definitely there.
Have you hugged someone today?

Locked

Return to “[2.0.x] Convertors”