User Profile

[Kevin Sours]

You're welcome

[Kevin Sours]

It's possible that it could affect other queries. Query tuning is a tricky business and it can be very site/database specific. They querydefs are not cached anywhere. Changing the query will take immediate...

[Kevin Sours]

That's what I was hoping it would look like. Did it fix the problem?

[Kevin Sours]

Okay so I'm not going to guarantee this works, but I don't like the table order in the explain up above (sometimes the optimizer gets confused, sometimes it just looks that way).

But if you...

[Kevin Sours]

That complicates things a bit, but let me check something.

[Kevin Sours]

The query optimizer is doing something very weird here. Unfortunately these problems tend to be very data specific so I'm somewhat limited in what I can test on my end but there are probably a couple...

[Kevin Sours]

This also cleans up a couple of missing classes in the middle that were probably added after you customized the template.
Note I didn't spend a ton of time testing it, but it does appear to work...

[Kevin Sours]

{vb:set postStatus, ''}

<vb:if condition="$conversationtype == 'starter'">
{vb:set optionsArray.showInlineMod, {vb:raw showInlineMod}}
{vb:action enableInlineMod,

...

[Kevin Sours]

Okay so this was a tricky one and there isn't a good solution. Basically using the vB5_Template_NodeText class in the custom API wasn't intended and has some annoying side effects. In particular fetchOneNodeText...

[Kevin Sours]

Okay, all of the broken notifications should be fixed. If they pop back up, please let us know, but all of ones I saw had a lastupdate timestamp right around when we ran the fix the first time so I'm...

[Kevin Sours]

It looks like there is a race condition caused by a cache of the duplicate records where some notifications get updated with the duplicate record id after the script has fixed it. It appears to be a...

[Kevin Sours]

We replaced the original "skip moderation" permission with three new permissions
1) Skip Moderation for Topics -- if no then new topics will be put into moderation
2) Skip Moderation...

[Kevin Sours]

The cache class is vB_Cache_Memcached. The vB_Memcached class is an underlying class used to access the memcache API and isn't intended to be used directly.

[Kevin Sours]

I'm not entirely clear on what you are trying to do. Remote get is only called if the phrase is not cached locally. This is cached in browser storage and that's not always cleared by clearing the browser...

[Kevin Sours]

So what it's objecting to here is that the vBulletin template language uses PHP snippets in places. It's detecting that as a nefarious attempt to inject PHP into your database. Given that the templates...

[Kevin Sours]

FYI: https://tracker.vbulletin.com/vbulle...sues/VBV-19073
It's good catch.
Thank you,
Kevin

[Kevin Sours]

You you fetch the notification request are you sending the session hash cookie to the server? The code you posted looks correct in terms of logging in and setting the cookies, but that doesn't guarentee...

[Kevin Sours]

Which query was it? Would like to investigate.

[Kevin Sours]

I do try to be a trifle more professional than that

More seriously, I *want* customer feedback. As much as I can get. I'd prefer it to be measured and polite, but I'll honestly take...

[Kevin Sours]

The sounds like a PHP bug. Enabling Opcache shouldn't change the behavior of the PHP code.