Multiple Issues

[C_P]

In my » Quick Moderation module on my home page www.cpfools.com, I see
Threads (0)
Posts (2) <---------
Events (0)
Attachments (0)
Users (0)

But, whn I click on that, it takes me to adminCP and it says:
Threads Awaiting Moderation
No Threads awaiting moderation

Posts Awaiting Moderation
No Posts awaiting moderation

Also, when I click on my profile on same home page under » Active Users module, I get a page not found
http://www.cpfools.com/member.php?u=1
I do not know why it shows me as that but could be not insync with database?
I also am needing a step by step walk through on adding links to a module, adding a module, and a couple other issues.
If someone has the time to help me, please pm me or IM me when I'm on.
Thank you!

[C_P]

*Update
I realized it should be calling this profile from forum dir and it is not as this url works:
http://www.cpfools.com/forum/member.php?u=1
Still not sure how to fix it though

[Brian]

For the moderation issue, if you have the quick stats enabled in your admin cp, please see if it also shows that some posts are awaiting moderation. If not, please run this query and let me know what it returns:

SELECT * FROM moderation WHERE type = 'post'

As for the online user's problem, I believe the bug posted in this thread is most likely what's causing the problem.

[C_P]

In quick stats > Moderated Posts 2 [View]
But same results when I click on view
Threads Awaiting Moderation
No Threads awaiting moderation
Posts Awaiting Moderation
No Posts awaiting moderation

* I ran query and it states:

Query
SELECT * FROM moderation WHERE type = 'post'
Results: 0, Page 1 of 0

~~~~~~~~~~~~~~~~~~~~~~
For the online user's problem:

You the man! Worked perfectly!
Now, when are ya gonna come see the first SMF converted site to vb?

[Brian]

Originally Posted by C_P

In quick stats > Moderated Posts 2 [View]
But same results when I click on view
Threads Awaiting Moderation
No Threads awaiting moderation
Posts Awaiting Moderation
No Posts awaiting moderation

That's actually more of a problem with vBulletin then (maybe because you imported from another forum?). If you'll run this query though it should remove those:

DELETE FROM moderation WHERE type = 'reply';

[C_P]

All my issues have been taken care of !
Except the noobie personal walk through of creating a module that I have tried to do 15 times but no luck getting it.
Anyway, I understand and thank you VERY much for the help resolving the others!