Welcome to Geeklog, Anonymous Tuesday, July 16 2024 @ 08:33 am EDT

Geeklog Forums

Comments from deleted users


Matt Simpson

Anonymous
I recently upgraded from 1.3.7 to 1.3.9

Before the upgrade, I had some comments from users who got deleted after then entered the comments (coincidence .. not because the comments were evil). With 1.3.7, the comments would display, with no user name (it didn't say anonymous, there was nothing at all in the name field). With 1.3.9, the comments don't show up at all, but they're counted in the number of comments for the article. Does anybody have any advice on how to make them appear (preferable), or go away completely to avoid confusing numbers?
 Quote

Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
mmmm you could do a
Join statement with the user table and delete an comment that return null for uid in the users table... I'd post the sql string for this but my data line is down at my Corporate office
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Matt Simpson: With 1.3.9, the comments don't show up at all, but they're counted in the number of comments for the article. Does anybody have any advice on how to make them appear (preferable), or go away completely to avoid confusing numbers?

I assume we're talking about comments from users that have been deleted while the site was running an earlier version of Geeklog? 1.3.9 should handle posts from (freshly) deleted users correctly, i.e. display them as anonymous posts.

The problem is that the old uid is still stored in the comments. Due to changes in the comment engine in 1.3.9 (and stricter checking) it's possible that Geeklog refuses to display these posts now - but they are still there.

So the obvious thing would be to correct the uid, i.e. for all comments check if the uid exists and set it to 1 (= anonymous) if it doesn't. That should then make the posts show up again (and the comment counter should be correct again, too).

It looks like mthomas has already volunteered to write such a script

bye, Dirk
 Quote

Matt Simpson

Anonymous
Quote by Dirk:
I assume we're talking about comments from users that have been deleted while the site was running an earlier version of Geeklog?
The problem is that the old uid is still stored in the comments. Due to changes in the comment engine in 1.3.9 (and stricter checking) it's possible that Geeklog refuses to display these posts now - but they are still there.



That is exactly what happened The users were deleted (because the email updates started bouncing) when the site was running 1.3.7. The old uid stayed in the comments. 1.3.7 would display them with a null name; 1.3.9 wouldn't display them at all.

Since it's a fairly small site with only a few users, I thought trying to write a script would probably take longer than doing it the "hard" way. It was pretty easy to find the two deleted uids that had comments and change the uid in those comments to 1.
 Quote

All times are EDT. The time is now 08:33 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content