Advertisement:

Author Topic: Eblah 9.71B conversion to SMF issues  (Read 11061 times)

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71B conversion to SMF issues
« Reply #20 on: July 23, 2008, 12:46:05 PM »
The message ids changed? Are they a similar change such as a certain number incremented or what?

I may have misused the terminology. 

1)The private messages, while in the MySql database, do not show up in the users PM mailboxes.

2) as for the message ids, here I was referring to messages posted to the forum, e.g., On the old forum, the message id for "Good news. Script sold" is:
http://www.simplyscripts.net/cgi-bin/Blah/Blah.pl?m-1216741106/ [nofollow]

on the SMF forum, the message id is:
http://simplyscripts.net/forum/index.php?topic=7164.0 [nofollow]

It would have been nice to have the old message ids retained so I could do a search and replace on message urls to point users to the new threads.

Don
No matter where you go, there you are.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,781
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Eblah 9.71B conversion to SMF issues
« Reply #21 on: July 23, 2008, 02:05:56 PM »
They show in both of the pm tables?
It just may be the label is not correct. In which just doing this sql command should fix it:
Code: [Select]
UPDATE smf_pm_recipients
SET labels = '-1';

That is a topic id, not a message id.
Was that a time stamp used there to reference the message id or do you know?
If it was a time stamp and it was retained during the conversion, some custom code can be used to correctly direct them.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71B conversion to SMF issues
« Reply #22 on: July 23, 2008, 02:55:14 PM »
They show in both of the pm tables?
It just may be the label is not correct. In which just doing this sql command should fix it:
Code: [Select]
UPDATE smf_pm_recipients
SET labels = '-1';
The above didn't fix anything.  After looking at pm_recipients and personal_messages, I see that personal_messages has about 11825 rows, however, pm_recipients has only about 90 rows.  Looks like pm_recipients didn't get converted completely


That is a topic id, not a message id.
Was that a time stamp used there to reference the message id or do you know?
If it was a time stamp and it was retained during the conversion, some custom code can be used to correctly direct them.

Yes, the column "posterTime" (which I believe is a time stamp) corresponds to the first message in a topic .  If there is something that can be done to redirect users using that, I'd like to investigate that.

Don
No matter where you go, there you are.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,781
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Eblah 9.71B conversion to SMF issues
« Reply #23 on: July 23, 2008, 03:01:36 PM »
The missing information in the pm_recipients table would explain that.
Without that info as well, the pm data would be lost if you tried to fix it.


I am not as good at perl. But you could do a redirect to a php script, that would connect to the database and find the message that had the time stamp that was in the url and then redirect them to the topic.

Currently I am in the middle of oscon (I am typing from the show room floor right now), so I don't got time at the moment to program something up that might work.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub