We are using vBulletin 5.4.2 and we've been having issues with moderating posts in the message center for a while, even with previous versions of vb5.
When a moderator or admin attempts to see the posts pending moderation within the Message Center Moderation option, the site immediately redirects to the forum home after trying to load the url of the pending posts: forum.com/privatemessage/pendingposts/5211/1
This happens independently of the browser at use.
The server is running Ubuntu 16.04.4 LTS with the following configuration:
I've tried reinstalling all the forum files, even launching a new server instance with the forum from scratch.
With a clean installation and no vb database backup loadad (strictly from scratch), there are no redirection issues when trying to moderate pending posts the same way.
However, when I restored a backup from our running prod server (containing the posts pending moderation) the redirection issue came back exactly the same.
I also tried to restore an older backup that had no posts pending moderation, and the issue did not reappear, giving me the understanding that the root cause is coming from data within those pending posts.
A moderator also confirmed that when he left posts with no moderation, as the queue increased, he was able to access the first page of the pending posts: /privatemessage/pendingposts/5211/1 but when changing to the next page /privatemessage/pendingposts/5211/2 he was immediately redirected back to the forum home page.
I did not found other users with this similar issue. Tried many maintenance options from the admincp like Clear System Cache or running Repair / Optimize Tables with no help.
So the only way the moderators can moderate the posts is by viewing all the latest topics and looking manually (which is horrible). However there always are 6 posts that can't be found from there, meaning that in the Message Center the Moderation number only decreases to 6 and we have no way of knowing what are those posts because of the redirection.
I would love to delve into the database to find and remove the 6 pending posts since clearly something there must be corrupted but I had no luck reaching such data since I couldn't figure which tables are involved.
If anyone could hint me as to where to look in the database or give me any helpful query to view such data I could investigate further.
Of course, I'm assuming the culprit is database data from what I've tested but if there are any other tips or things I could try I would gladly appreciate.
Let me know about any additional info I could provide for help.
Thanks!
When a moderator or admin attempts to see the posts pending moderation within the Message Center Moderation option, the site immediately redirects to the forum home after trying to load the url of the pending posts: forum.com/privatemessage/pendingposts/5211/1
This happens independently of the browser at use.
The server is running Ubuntu 16.04.4 LTS with the following configuration:
- Apache v2.4.18
- PHP 7.0.30-0ubuntu0.16.04.1
- MariaDB: 10.0.34-MariaDB-0ubuntu0.16.04.1
I've tried reinstalling all the forum files, even launching a new server instance with the forum from scratch.
With a clean installation and no vb database backup loadad (strictly from scratch), there are no redirection issues when trying to moderate pending posts the same way.
However, when I restored a backup from our running prod server (containing the posts pending moderation) the redirection issue came back exactly the same.
I also tried to restore an older backup that had no posts pending moderation, and the issue did not reappear, giving me the understanding that the root cause is coming from data within those pending posts.
A moderator also confirmed that when he left posts with no moderation, as the queue increased, he was able to access the first page of the pending posts: /privatemessage/pendingposts/5211/1 but when changing to the next page /privatemessage/pendingposts/5211/2 he was immediately redirected back to the forum home page.
I did not found other users with this similar issue. Tried many maintenance options from the admincp like Clear System Cache or running Repair / Optimize Tables with no help.
So the only way the moderators can moderate the posts is by viewing all the latest topics and looking manually (which is horrible). However there always are 6 posts that can't be found from there, meaning that in the Message Center the Moderation number only decreases to 6 and we have no way of knowing what are those posts because of the redirection.
I would love to delve into the database to find and remove the 6 pending posts since clearly something there must be corrupted but I had no luck reaching such data since I couldn't figure which tables are involved.
If anyone could hint me as to where to look in the database or give me any helpful query to view such data I could investigate further.
Of course, I'm assuming the culprit is database data from what I've tested but if there are any other tips or things I could try I would gladly appreciate.
Let me know about any additional info I could provide for help.
Thanks!
Comment