View New Content and Sphinx problem

[RomulusM]

As I understood, my View New Content erratic behavior will be resolved in 3.2. However my board is virtually unusable, by this problem and I started to lose patience. When should I expect such an important feature to be solved? It is simply unacceptable to wait over 1 month a fix for such an important problem.

Basically, my members relies on View New Content feature, which is now simply not useable.

[RomulusM]

Of all the features we receive feedback on, view new content receives the most. To many this is their primary browsing page and it's vital that it works accurately. We've had database level topic tracking for many years. It was introduced in 2.0 and has gone through many refinements for efficiency and accuracy.

And I agree with Matt fully.

However, mine is not working at all for over a month, and when asked when it will be fixed, it was told to me that in 3.2. However now I am desperate for a fix. What should I do?

I am really desperate. Invision, please do something to fix this!

[RomulusM]

By not working at all, I mean the way it's working renders it simply unusable. It's not accomplishing the function it is design to achieve.

[Matt]

Submit a ticket for me, I'll see what I can do.

[Volvospeed]

A patch for this would be great. Even if all it did was give the option to turn off sphinx for VNC and Todays Active Content. Well I guess thats no good for people running innodb but screw them. :lol:

[.Ian]

I am sure I was told in a ticket that VNC does not use Sphinx (apologies if I am mistaken, but could have sworn someone said that)

[Volvospeed]

I am sure I was told in a ticket that VNC does not use Sphinx (apologies if I am mistaken, but could have sworn someone said that)

Empirical yes but..... with sphinx on I have deltas in my VNC and Todays Active Topics. Order is also jacked and duplicates. If I break the path to sphinx neither service works. If I go back to mysql search everything is fine. So with that, I am going to ASSUME that both do indeed use sphinx. That and I looked at the code and they do ;)

[RomulusM]

Submit a ticket for me, I'll see what I can do.

I did! Before posting here!

[InvisionHQ]

Please inform us about this ticket, I'm in the same hell...

[Volvospeed]

Per Jason H

In /admin/applications/forums/extensions/search/engines/sphinx.php

Change

				$this->sphinxClient->SetGroupBy( 'last_post_group', SPH_GROUPBY_ATTR, '@group ' . $sort_order );

To

						$this->sphinxClient->SetGroupDistinct ( "tid" );

				$this->sphinxClient->SetGroupBy( 'tid', SPH_GROUPBY_ATTR, 'last_post ' . $sort_order );