Big Mike 

Problem seems to be occurring still. Will keep looking, but first need more coffee Mike

OK, I think I've got it now. Tested a dozen threads. First click on 'new' took me several pages behind the last page. Second click on 'new' took me to the following page. And so forth. Working as designed for me now.

Let me know guys.

Mike

Now, the last thing I need to work on today is getting multiple errors resolved with our memcache.

Technically speaking, vbulletin 3.8 was designed to use php-memcahe, which is actually quite different than php-memcached (notice the d) which relies on the memcached server.

Unfortunately, our new server on GCP doesn't support the old php-memcache. So I am having to convert a lot of code to use memcached instead. I thought I had it worked out prior to the migration, but turns out no.

So the server is currently running with no datastore cache at the vbulletin level.

The good news is, once I get this fixed we should see a performance increase.

Mike

Big Mike 

OK, I think I've got it now. Tested a dozen threads. First click on 'new' took me several pages behind the last page. Second click on 'new' took me to the following page. And so forth. Working as designed for me now. Let me know guys. Mike

Not yet working for me.

Clicked on New and went to this post, the last post on a page, which I had seen yesterday:

Want your NinjaTrader indicator created, free? Guys: I have been trying to creat alot of different templates experiementing on how to set up my charts with all the different indciators -- and in trying to set up the parameters and the colors etc... I have to constantly create and recreate TEMPLATES. But …

Going to the following page, I scrolled past the next 2 posts, which I had also seen, and then found the first new post here:

Want your NinjaTrader indicator created, free? OpalDragon, Pretty sure this cannot be accomplished. The template name is simply an HTML file name imported once into the chart. After the import there is no actual connection back to that template. The chart closes with the workspace performs a save …

This is what I was getting before, but again, not for every time. Will try more and see if I can see anything else.

Also, "Thanks" is not working again. It doesn't appear on the thanked post until the page is manually refreshed.

Bob.

bobwest 

Not yet working for me. Clicked on New and went to this post, the last post on a page, which I had seen yesterday: Want your NinjaTrader indicator created, free? Guys: I have been trying to creat alot of different templates experiementing on how to set up my charts with all the different indciators -- and in trying to set up the parameters and the colors etc... I have to constantly create and recreate TEMPLATES. But … Going to the following page, I scrolled past the next 2 posts, which I had also seen, and then found the first new post here: Want your NinjaTrader indicator created, free? OpalDragon, Pretty sure this cannot be accomplished. The template name is simply an HTML file name imported once into the chart. After the import there is no actual connection back to that template. The chart closes with the workspace performs a save … This is what I was getting before, but again, not for every time. Will try more and see if I can see anything else. Also, "Thanks" is not working again. It doesn't appear on the thanked post until the page is manually refreshed. Bob.

OK, give me a second. The thanks being broken means I formatted the JSON incorrectly in the reverse SQL proxy rules file, it gives me a clue where something went wrong...

Mike

bobwest 

Not yet working for me.

I think I found the problem, examining the HTTP headers. I am working on the fix now, give me a moment.

Mike

Big Mike 

I think I found the problem, examining the HTTP headers. I am working on the fix now, give me a moment. Mike

@bobwest, try again now please.

What I did was yesterday I discovered that one of the major redirects for the forum (happens on nearly every click to a thread) wasn't being cached by our frontend nginx server. This caused an extra delay, and query to vbulletin (PHP) which then queries the database, etc.

It was a simple request, basically like so:

My challenge of being a consistent trader Im sitting infront of my screen and see here a good trade location...and there...and here again... So why the f*ck am I down again?!...

or

Introduce yourself here! Hi everyone! Like most day traders, I blew up my account a couple times and lost enough money to make most grown men weep. After I regrouped I started trading with common sense and with control of my emotions. Later, I decided I wanted a forum to share …

Those requests are static and don't change for anyone, whether they are guests or logged in. But the thing is, I had an exclusion for signed-in members (with cookies on, I'm looking at you @xplorer lol) because we can't have signed-in member content cached (for example, it would cache MY version of this thread page, which has stuff on it that normal people don't have access too -- moderator/admin stuff, it would say MY name on the top right, etc).

So, I said hey this isn't necessary in this case, it's safe to cache even for logged in members. And that remains true, because it's just a simple HTTP 302 temporary redirect to the right SEO URL as provided by our SEO plug-in.

Now, here is where the problem is... I hadn't realized that the New Post feature made a call to this URL. So, now that I know this, I extended the regex check so that the new post 302 redirect is excluded from caching, because that redirect is dynamic and changes for everyone every time it is clicked.

So, assuming this fixed your issue, then this actually was not at all related to the site migration or reverse SQL proxy.

First, I want to wait for you and at least one or two other people to tell me New Posts is now working correctly.

Once that is verified, I am going to undo the last SQL query cache exclusions I added, which I don't think are necessary now to solve the problem. So please, I need feedback from some other members to confirm the problem is solved for now before I make further changes.

Now, if you reply and tell me even now it still doesn't work, then I will need to brew another full pot of coffee! But I do have some personal errands this afternoon that will take me out of the office in about 10 minutes, and I won't return for three hours or so.

So let me know....

Mike

bobwest 

Also, "Thanks" is not working again.

Fixed.

Mike

Big Mike 

@bobwest, try again now please. ... Now, if you reply and tell me even now it still doesn't work, then I will need to brew another full pot of coffee! But I do have some personal errands this afternoon that will take me out of the office in about 10 minutes, and I won't return for three hours or so. So let me know.... Mike

OK, I did all the "New" items I had, which included several threads that I had viewed other posts in recently, and they all put me at the correct new post, no problems. I would say it's fixed.

Also, Thanks is fixed.

I'll be out of the office too, but I think we're good.

Bob.

bobwest 

OK, I did all the "New" items I had, which included several threads that I had viewed other posts in recently, and they all put me at the correct new post, no problems. I would say it's fixed. Also, Thanks is fixed. I'll be out of the office too, but I think we're good. Bob.

I'm leaving now.

But please, I need at least one more user to confirm that 'New' is working correctly, so I can undo the sql query exclusions I did to increase performance.

Mike

Big Mike 

I'm leaving now. But please, I need at least one more user to confirm that 'New' is working correctly, so I can undo the sql query exclusions I did to increase performance. Mike

Seems fixed with the couple of posts I checked - I'll be able to tell tomorrow with more 'new' posts.