Question Bug/Issues with my database (not kunena i think)

Now i would have to say i am pretty sure this is a problem with my database and not kunena.

From memory it started occuring when i went from FB1.04 to FB1.05 and still occurs now that i have upgraded to Kunena 1.08

Issue #1:
The latest member it says is not correct. I have 4894 members but for some reason it is stuck saying that MemberX (who is member 4385 is the latest member)

I have tried syncing the joomla users and kunena still doesnt fix this.

Issue #2:
Also another problem which has been around just as long is that my drop down categories dont work at all.

I would really like maybe someone to look at my database and see what the issues are. Am willing to pay.

Issue #3:
Also my userlist in CB says i have 4530 Users, but as i said above my kunena says i have 4894 members. Is it possible to have these sync? the 4894 is im pretty sure the amount of members that are signed up but not confirmed/activated.

is there a way for kunena to show only those members activated? like CB does

Issue #1:
Interesting issue. Try to run queries:

This will show your latest member (this is the query from Kunena):
SELECT id, name, username, email, block, activation, registerDate, lastvisitDate FROM jos_users WHERE block=0 AND activation='' ORDER BY id DESC LIMIT 0,1

This should show you mostly spam registrations, which haven't been activated:
SELECT id, name, username, email, block, activation, registerDate, lastvisitDate FROM jos_users WHERE block=1 AND activation!='' ORDER BY id DESC

This one shows them both:
SELECT id, name, username, email, block, activation, registerDate, lastvisitDate FROM jos_users ORDER BY id DESC

Issue #2:
Drop down categories? What are those? Anything to do with Kunena?

Issue #3:
What does this say:
SELECT COUNT(*) FROM #__users WHERE block=0 AND activation=''

Firstly thankyou very much matias!!

Issue #1:
I ran that query and it came back the user 4384 (the member it seems to be stuck on, who is not the latest member!)

The second query (spam registrations) came back empty result

The third query came back with 4,894 results

Issue #2:
Sorry need to be clearer in my descriptions. I have attached an image. I have 12 categories and these do not show in the drop-down category field. Nothing shows in the drop-down box. See image below so you can see what i mean (this was like this with the install of K1.08, i have just changed a few colours in the css)



Issue #3:
i ran and it came back with an error.

so i tried
and it came back with the result: COUNT(*) 3769

as you can see here the move/delete drop down works but the category one doesnt.

was like this in FB1.05RC2 as well

as you can see here the time drop down box works but the category one doesnt

didnt work in FB1.05RC2 either

I have 12 sections and 77 categories. And as you can see none show up in the drop-down category select field.