Posted on: 2009/1/11 4:12
Comments Not Displaying after recreating groups_users_link table
I did an extensive search but couldn't find any posts that address the problem with my site. Hoping someone can assist.
The problem is that comments are no longer displaying on my site, like in xcgal. I checked the dbase and they are all still in there. They just won't display. I can still enter a new comment into the dbase too.
This happened when I was fixing another issue with users not being able to log in. Somehow the groups_users_link table got deleted, so users started setting up new accounts.
I recreated the link table by simply building a list of userids up to the numbers that were in the link table already. This enabled everyone to log in again.
Then I noticed some spammers and deleted a couple of accounts.
Then I noticed the comments stopped displaying. I ran debug but didn't see anything obvious to me.
Could the comments issue be related to me recreating the groups_users_link table? And since I just made a list of numbers 1 - 6519 or so for userids and applied group 2 to these. . is it possible that i input userids that should not exist and these are somehow messing the comments up?
Any thoughts would be greatly appreciated.
the site is hotdogblog.com