Advertisement:

Author Topic: "Started by" shows only member numbers, not names  (Read 10494 times)

Offline edsager

  • Semi-Newbie
  • *
  • Posts: 11
"Started by" shows only member numbers, not names
« on: October 12, 2008, 06:11:47 PM »
Hello All,

I think the conversion went fine, though it seemed to stall at the very end and rendered Firefox frozen, but the number of members and posts are all correct and so is the list of members.

However, when I look at the Board index or anything which shows the members (except for the memberlist), I get numbers and not names. 

In YaBB 2.2.3, the individual posts listed the names correctly, though elsewhere, the members were listed by number (except for the memberlist).  I got rid of the mention of the members in YaBB everywhere except for the posts, which had the names correct.

Is there a way to change the numbers to names in SMF, especially in the posts?

Thank you,
edsager

Offline edsager

  • Semi-Newbie
  • *
  • Posts: 11
Re: "Started by" shows only member numbers, not names
« Reply #1 on: October 13, 2008, 12:01:31 AM »
Update:

Numbers are shown for members in many of the posts and topics, though not all. 

Topics with ID_MEMBER_STARTED = 0 total about 2373 out of 37,898.
Messages with ID_MEMBER = 0 total about 61,230 out of 95,021.

This is a closed BB which will be distributed on CD with Server2Go portable server, so having "anonymous" is better than "11250" as a name for the poster.

Is there any way to code a sieve which returns the word "anonymous" when ID_MEMBER_STARTED & ID_MEMBER are listed as equal to 0?

Thanks,
edsager

ThorstenE

  • Guest
Re: "Started by" shows only member numbers, not names
« Reply #2 on: October 13, 2008, 02:28:43 AM »
untested, but this should help (please make a Backup from your database before!!)

open phpMyAdmin and execute the following query
Code: [Select]
UPDATE smf_messages SET posterName = 'anonymous', '' AS posterEmail  WHERE ID_MEMBER = 0
replace smf_ with your table prefix..
this will replace the posterName to 'anonymous' and delete the posterEmail for all unassigned messages

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: "Started by" shows only member numbers, not names
« Reply #3 on: October 13, 2008, 03:04:45 PM »
If you are getting "11250" as the name for the poster. Yabb changed over to use member ids. So I would assume 11250 is the member id that didn't get linked up correctly during the conversion.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline edsager

  • Semi-Newbie
  • *
  • Posts: 11
Re: "Started by" shows only member numbers, not names
« Reply #4 on: October 14, 2008, 01:20:50 AM »
SleePy,

I thought about that, but the highest ID_MEMBER in the smf_members table is 9266 and none of the members in this table have a value of 0.  Examples of Nos. I get instead of the members' names are:  18084, staff19135, 22273, 7919, 9278, etc.  Is there something I can change with the conversion process which would help this?

TE,

Thank you.  If I cannot get the actual names for the posters, I will use your bit of code.

Thank  you both,
edsager


Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: "Started by" shows only member numbers, not names
« Reply #5 on: October 14, 2008, 03:03:09 PM »
Go to your yabb members directory. Is there members with that for their id? Which would be the name of the file with a few different extensions.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub