Advertisement:

Author Topic: YaBB2.1 -> SMF - Personal Messages Problem  (Read 44607 times)

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #20 on: August 13, 2008, 04:41:38 PM »
Ok try this.

Find:
Code: [Select]
                    'fromName' => substr(htmlspecialchars($userData[$i][0]), 0, 255),
Replace:
Code: [Select]
                    'fromName' => $is_sent ? htmlspecialchars(substr($entry, 0, -4)) : substr(htmlspecialchars($userData[$i][0]), 0, 255),
Find (Should only be a couple lines down from the first one):
Code: [Select]
                    'temp_toName' => htmlspecialchars(substr($entry, 0, -4)),
Replace:
Code: [Select]
                    'temp_toName' => $is_sent ? substr(htmlspecialchars($userData[$i][0]), 0, 255) : htmlspecialchars(substr($entry, 0, -4)),
That should fix it.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #21 on: August 13, 2008, 05:28:22 PM »
Tried that. No messages in the outbox at all...  :o

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #22 on: August 13, 2008, 05:34:02 PM »
Find:
Code: [Select]
                WHERE mem.memberName = pm.temp_toName
                    AND pm.temp_toName != ''
                    AND pm.deletedBySender != 0");

Replace:
Code: [Select]
                WHERE mem.memberName = pm.temp_toName
                    AND pm.temp_toName != ''");

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #23 on: August 13, 2008, 05:45:11 PM »
OK, still no messages in Outbox and I've got some duplicates in Inbox.

For example a message from a member named Futile and next to it the same message from a member called Futile.ou, who is marked as a guest.
« Last Edit: August 13, 2008, 05:50:16 PM by JMB »

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #24 on: August 21, 2008, 04:44:33 AM »
Any progress on this problem SleePy?

It's the final hurdle for me to be able to convert to SMF.  :)

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #25 on: August 21, 2008, 12:47:20 PM »
No I haven't had time to look into getting this done right.
I plan on it in the up coming days since finals are almost over.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #26 on: August 21, 2008, 02:19:47 PM »
No worries. Good luck with the finals!  :D

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #27 on: September 18, 2008, 06:08:35 AM »
Any luck with figuring this one out SleePy?  ;)

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #28 on: September 19, 2008, 02:08:47 AM »
I have had people say pms are converting correctly for the yabb 2.2 converter now after I did some work to it. I was able to get both the inbox and outbox to convert data.

I plan on posting that as a beta script by the end of the week most likely. Just need to hear back from 1 more person.
I could most likely back port some of the changes. Which would basically be just where the information was in the array. I should be able to pick that up off the yabb 2.1 converter.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline stealth8080

  • Newbie
  • *
  • Posts: 2
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #29 on: October 15, 2008, 08:20:28 PM »
so any news with outbox pm problem?

I just converted yabb 2.2.3 forums to smf 1.1.6 and users didn't have outbox messages.

how to fix it, thanks.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #30 on: October 19, 2008, 09:23:23 PM »
Did you use the converter file attached to the Yabb 2.2 beta topic that is a sticky in this board?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline stealth8080

  • Newbie
  • *
  • Posts: 2
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #31 on: October 23, 2008, 06:17:29 PM »
Did you use the converter file attached to the Yabb 2.2 beta topic that is a sticky in this board?

yea, I used it a the messages weren't converted.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #32 on: October 23, 2008, 10:59:38 PM »
Is there any data in the smf_personal_messages and smf_pm_recipients tables?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #33 on: October 26, 2008, 09:55:09 AM »
As you seem to have managed to get this working on the 2.2 converter, I made a copy of my board and upgraded to 2.2.3.

I ran the latest SMF converter and it stops right at the start with this error:

Quote
Converting membergroups... Unsuccessful!
This query:

REPLACE INTO `porcupin_ptfsmf`.smf_membergroups
(id_group, group_name, online_color, min_posts, stars)
VALUES (2, SUBSTRING('Global Moderator', 1, 80), SUBSTRING('blue', 1, 20), '-1', SUBSTRING('5#stargmod.gif', 1, 255)),
(1, SUBSTRING('PTF Administrator', 1, 80), SUBSTRING('red', 1, 20), '-1', SUBSTRING('5#staradmin.gif', 1, 255)),
(3, SUBSTRING('PTF Moderator', 1, 80), SUBSTRING('green', 1, 20), '-1', SUBSTRING('5#starmod.gif', 1, 255));

Caused the error:

Unknown column 'group_name' in 'field list'

Any ideas?

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #34 on: October 28, 2008, 05:16:07 PM »
Which file did you get?
Those columns it is trying to use, are SMF 2.0 columns.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #35 on: October 28, 2008, 05:45:15 PM »
Which file did you get?
Those columns it is trying to use, are SMF 2.0 columns.

I used the file for 2.2 in the sticky post.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #36 on: October 31, 2008, 06:11:24 PM »
Oh sorry, I reattached the file. I accidentally attached the version for 2.0 :P
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #37 on: October 31, 2008, 07:13:23 PM »
Lol! ;D

I'll try it again then!

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #38 on: November 17, 2008, 10:13:27 AM »
I finally found some time to try this again. Converter ran really fast!! Converted the whole forum in under 8 minutes, compared to over 3 hours using the 2.1 converter! Well done on that!  ;D

Most things worked fine, but still problems with PM's.

All PM's in the inbox have a date of either January 01, 1970, 12:00:00 AM or January 01, 1970, 12:00:02 AM.

All PM's in inbox have the IP address for the subject and the subject for the name of the sender.

Message text is OK.

The are no PM's in the outbox.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,412
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: YaBB2.1 -> SMF - Personal Messages Problem
« Reply #39 on: November 17, 2008, 12:46:49 PM »
Alright.

This one any better?
I was off on a couple indexes.

If after this we can't get the pms to convert the outboxes, I will use the dummy function I have there to do this I guess.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub