Bug Posts Not Showing Up

[highlander]

Since we migrated to the current version last Tuesday, a lot of people are complaining that posts aren't showing up. Here are some examples of comments. It only seems to happen with people that are set up for 10 posts per page.

No, it says that member X posted a new reply at X time, but when I click the thread, the latest post is an earlier one I've already read by member Y. I don't see a thread page I can't access.

But now that you mention it, it seems to happen everytime someone writes a post that creates a new page in the thread. I.e., if there are 10 responses in the thread and someone posts another reply, I can't read that one. But it doesn't create a new page I don't have access to, like it does for you.

Sometimes the new page becomes visible if I post in the thread myself, but sometimes my own post is unavailable even to me, like in this thread.

Screen shots of the two threads I was speaking about in my above post:

Screen shots taken at:

My subscribed threads notices showing last poster and time at the far right:

What I get when I go to last post in Accurately typed thread:

What I get when I go to last post in Line of Lyrics thread:

Again, I'm using Default skin.


ETA: (9:50 a.m. est) I tried posting in the Accurately Typed thread, left the thread, then went back to it, and the missing post showed up. I deleted my test post so as not to leave a junk post in the thread. The forum is still running like molasses for me.

 

[highlander]

Here is another example.

This same thing is now happening to me in the Just Neckbeard Things thread. I got a notification that someone had replied to my post there but it keeps taking me to page 1 of the thread (there are 2 pages, since I have my PPP set to 100).

My post was the last one on page 1, and the post (or posts, if there are any more than the one that quoted me) I can't see are the first ones on page 2.

So I guess it's not just happening with people who are 10posts per page.

 

[Fillip H.]

This mod does not cache threads, nor does it modify the posts per page in any way. After DBSEO resolves the URL back to its original vB URL, it hands the reins over to vBulletin.

Please try disabling all other modifications, and also check the "Time is now" timestamp in the footer to make sure there's no full page caching going on here.

 

[highlander]

I just isolated a thread where this is happening and close it. I turned off every single mod one by one and none of them result in the most recent post showing up. It is the Drop and Give Me 20 Thread. You'll notice here:

Exercise Challenge

The last post was by EJCC Today (6/30), 10:07 AM

However if you go into the thread, you can't get that post to show up. It only lets you get to the third page. There is a fourth page which isn't visible as noted in the upper right hand corner. When you click on it, it keeps taking you to page 3.

Drop And Give Me 20! - Page 3

Are you sure this isn't somehow related to DBSEO? The reason I ask is the only situation where we've had links that don't work relates to the DBSEO implementation and it's the link to that page 4 which isn't functioning.

 

[Fillip H.]

If DBSEO has been turned off, then it can't be DBSEO that's causing it

 

[highlander]

If DBSEO has been turned off, then it can't be DBSEO that's causing it

I wasn't quite sure if DBSEO was the cause of the issue we've been having. I have been turning the mods off one at a time, eliminating each one from consideration to see if they were causing the problem. DBSEO is the last one and it seems to be the very likely culprit. It's turned off now. Coincidentally, I just received the following message from level 3 support at my hosting provider:

"We noticed 452189 queries performed without valid indexes and we see many queries running for 100+ seconds (many queries should complete in just a second or less.) These offending queries are examining over 36572726 records each tim they run. They are related to the tagcloud settings in vBulletin.

Please reply back and let us know if we may login to your admincp and we can have a look at the tag cloud settings. At no time should a MySQL query run that analyzes over 36 million rows. While this is happening its possible table-locking is occurring slowing your site down and causing errors. "

 

[highlander]

I just realized hat I turned on thread tagging around when this all started happening.

 

[highlander]

Summary of issues we have been encountering:

1. Frequent iss: Warning: mysqli::mysqli() [mysqli.mysqli]: (08004/1040): Too many
connections in /home/typology/public_html/forums/dbtech/dbseo/includes/class_db.php
on line 96
Connect Error (1040) Too many connections

(connections is currently set at 250, which hosting provider is recommending not to increase)

2. Users complaining they click on a thread or try to make a post and the wheel spins and spins, sometimes never coming back, sometimes ending up in a double post, sometimes asking if they want to go to another page. Some queries or posting attempts are taking several minutes. Other times it's completely fine.

3. Missing post issue described above. I have more examples of the scenario with the screenshots tonight. All situations occurred with SBSEO was on.

Example 1: Can't get to last page of posts in thread (or to last post). Last post in index doesn't match last one in thread.







Example 2: Can't get to last page of posts in thread (or last post). Last post in index doesn't match last post in thread.

 

[Fillip H.]

1. Frequent iss: Warning: mysqli::mysqli() [mysqli.mysqli]: (08004/1040): Too many
connections in /home/typology/public_html/forums/dbtech/dbseo/includes/class_db.php
on line 96
Connect Error (1040) Too many connections

(connections is currently set at 250, which hosting provider is recommending not to increase)

Your hosting provider is wrong. You need to increase the amount of connections, I recommend at least 800. What they are basically saying is that they do not want you to have more than 250 concurrent visitors, which is ridiculous.

2. Users complaining they click on a thread or try to make a post and the wheel spins and spins, sometimes never coming back, sometimes ending up in a double post, sometimes asking if they want to go to another page. Some queries or posting attempts are taking several minutes. Other times it's completely fine.

That is most likely due to the connection issue your host is giving you malicious advice on. MySQL will attempt to submit the query for X amount of time before giving up (leading to the another page popup), and sometimes vB's error correction means a doublepost is submitted if a subsequent query fails.

3. Missing post issue described above.

I had this issue when the post table was InnoDB. Switching it to MyISAM fixed the issue for me.

 

[highlander]

I temporarily turned the DBSEO mod off last night and we haven't had any missing posts since but it might be a little early to tell definitively.

I've done a pretty good job of keeping up with the new releases and deployed thread tagging as soon as you rolled it out including the option to tag all of our threads. It does coincide with when I started having problems.

The hosting provider said they thought dialing back tagcloud settings could address the issue. They said the offending queries were examining over 36572726 records each time they run. Should we adjust tagcloud settings when we implement thread tagging? If so, do you have any recommendations on what to put them at? Here is how mine are set.

Maximum Tags per Thread - 25
Maximum Tags Applied by Thread Starter - 25
Maximum Tags Applied by Other Users - 2
Force Tags to be Lower Case - Yes
Tag Cloud: Number of Tags - 70
Tag Cloud: Number of Level - 5
Tag Cloud: Cache Time - 30
Tag Cloud: Usage History (Days) - 365
Tag Cloud: Build Usergroup - Registered Users
Enable Search Tag Cloud - Yes
Search Tag Cloud: History (Days) - 30

 

[Fillip H.]

You may wish to limit your tag cloud, or turn it off entirely, though it won't affect the issues from my previous post.

 

[highlander]

I turned DBSEO back on, turned off thread tagging entirely and in manage content tags, I reset tags (removing all of the thread tags on my forum). Then I changed the tag cloud from 70 words to 10. Performance problems have been eliminated. No more duplicate or missing posts.

It was indeed the thread tagging and tag cloud that had been clobbering my forum.

I honestly think there could be some tuning of this whole thread tagging option because the tags it automatically generated were not particularly useful from an SEO perspective anyway. They just looked like a lot of random words attached to the threads. It seems if there was a way to customize it more - looking for specific keywords, number of instances of keywords, or things like that, perhaps it would be more useful. If nothing else, it might allow easier searching for particular types of threads.

 

[Fillip H.]

The more keywords you add via the DBSEO CP, the more those keywords will be added to the threads where relevant.

 

[highlander]

The more keywords you add via the DBSEO CP, the more those keywords will be added to the threads where relevant.

Thank you. I did all of that. It didn't seem to do much with respect to thread tagging.

 

[Fillip H.]

It'll only control the priority of the keywords (i.e. their sort order), and it will trim out irrelevant keywords if enough prioritised keywords are found.