Error in pending moderation topics

[EgyptPrime]

Hello
I have error i have a lot of threads pending moderation i found them in the forumdisplay but i can find them in admincp how i can fix this problem to make them appear on admincp to moderate them all ?

[EgyptPrime]

There is no one can know the reason of this error ?

[Zachery]

You should user the Settings, link, and moderate though the frontend. On the lefthand side there is an area where it will show you all moderated posts/topics.

[EgyptPrime]

yes i know it was appear for me before my last upgrade for vbulletin 4.2.2 PL4 i have download the patched files and replace them with my old ones now the pending posts value 0 and when i click on it i cant see any of pending posts or topics and when i view my forums i found some threads and posts is pending approve

[Zachery]

Are you saying its not showing all of the posts / threads that require moderation?

[EgyptPrime]

yes also i see another problem now when i try to edit any current post i got the forum error that is this post dosnt exist please contact the forum administrators i have reupload all vbulletin files again and the problem still exist .

[EgyptPrime]

i have try to disable all plugins also and the same error exist "this post dosnt exist" and the other problem of not showing posts / threads that require moderation .

[EgyptPrime]

there is any one know how to fix this problem ? its caused by upgrading to the latest version of vbulletin 4.2.2 pl4

[Zachery]

Why do you believe that not all posts are showing up there?

[EgyptPrime]

in alot of forumdisplay i see a pending topics waiting moderation like this photo.



and in my admincp its shown 0 posts or topics to moderate like next photo :




also another error i have discover when i try to edit any post content from any thread its give me an error that is current post link dosnt exist

[Zachery]

I suspect the AdminCP is not checking the correct code/areas to show moderated items correctly. However the frontend area should show those items. Messages > Moderation

[EgyptPrime]

Hello Zachery can you view this ticket ? Ticketid: 1334973

the problem from mysql database tables i found alot of databases tables have value 0

[EgyptPrime]

The problem need a fix by some script to redo the post id so any one can help me for this code ?

[EgyptPrime]

any one can do a script to redo the post id counts i can pay for develop such script the problem cant be fixed by vbulletin so if any one interested i can pay for his time for developing such script .