Any progress on the resolution of the wrong DB connection that prevent Wikiviewstats from running?

OMG, the code. Hedonil certainly has a unique way of writing code. @Technical13 we may have to rewrite this too when we move it to xTools.

Yep. That's why I killed the webservice for it the other day. It's not something that is going to happen soon based on our current levels of free time. I got midterms in a week, so cramming for that.

I looked and looked, and for the life of me cannot figure out what's causing the problem, or how to even read this. I'd need to open a million files just to even follow along.

Cyberpower678, Technical13 do you see any chance to restore this tool?

Any news?

meanwhile this is not "no db connection" anymore as originally reported but the webservice has been disabled too.

It does still say:

This URI is part of the wikiviewstats tool, maintained by Tools.wikiviewstats2, Cyberpower678, Technical 13, Hedonil, Betacommand, and Tools.xtools.

Is Betacommand active?

From my initial assessment, it appears that wikiviewstats didn't handle the transition to a newer version of php well, as the error log had errors about passing by reference. Modified the relevant code, now there is no error ouptut yet the script is still dying. I'm still exploring.

Does anyone know if WikiViewStats is under vcs somewhere?

Further exploration has revealed the following:

On line 694 of ~/wvs_modules/Core.php, there is a query:

Select shortcut as prefix, title, title_local, infolink, marker from meta where marker > 0 ;

It is run against the meta_p.meta table, which doesn't exist. This leaves the language array empty, which then causes a 500 further down the line.

Proposed solution? Replacing that query with an alternative using the meta_p.wiki table.

In T91320#2443855, @Matthewrbowker wrote:

Further exploration has revealed the following:

On line 694 of ~/wvs_modules/Core.php, there is a query:

Select shortcut as prefix, title, title_local, infolink, marker from meta where marker > 0 ;

It is run against the meta_p.meta table, which doesn't exist. This leaves the language array empty, which then causes a 500 further down the line.

A search reveals rOSOF061e316d5794e79c58cd4d15a5b2f38ef6bf9dce, which looks like a typo?

Would it be possible that the tool is from the toolserver-era and the query is supposed to run against toolserver.meta? In any case, I never had access to toolserver and dunno what data it had. Searches for toolserver.meta reveal nothing useful.

Wait, what? When did "we" decide that?

News to me. Not that I object, but I don't recall discussing this.

It was in the chat thing. You all are in there, but really it was just Matthew and I chatting, to be fair :) Anyway, it's not really resurrectable without considerable effort. The old pageviews dumps it went off of no longer exist, the same reason stats.grok.se went down. The gadget that was using wikiviewstats is working now, by the way, it just isn't showing pageviews data. For that you can just hit the RESTBase API https://wikimedia.org/api/rest_v1/?doc

In T91320#2639024, @MusikAnimal wrote:

It was in the chat thing. You all are in there, but really it was just Matthew and I chatting, to be fair :) Anyway, it's not really resurrectable without considerable effort. The old pageviews dumps it went off of no longer exist, the same reason stats.grok.se went down. The gadget that was using wikiviewstats is working now, by the way, it just isn't showing pageviews data. For that you can just hit the RESTBase API https://wikimedia.org/api/rest_v1/?doc

I never got any notification of any activity going on in that chat room. :O

In T91320#2639026, @Cyberpower678 wrote:

In T91320#2639024, @MusikAnimal wrote:

It was in the chat thing. You all are in there, but really it was just Matthew and I chatting, to be fair :) Anyway, it's not really resurrectable without considerable effort. The old pageviews dumps it went off of no longer exist, the same reason stats.grok.se went down. The gadget that was using wikiviewstats is working now, by the way, it just isn't showing pageviews data. For that you can just hit the RESTBase API https://wikimedia.org/api/rest_v1/?doc

I never got any notification of any activity going on in that chat room. :O

That sounds like a bug o.O

With the amount of work required, I really don't think it's worth the effort, especially since we have an alternative. I spent six hours on WikiViewStats some week back, and actually doubled the number of error messages.

IMHO WikiViewStats is much more complete and userfriendly of any other stats tool (this new one included). Since I'm not able to fix it, I need to accept the community decision, but is really sad to hear this.

I've never actually used it, and looking at the screenshots they are some really nice features! The problem however is the data source is no longer available, so even if you fix all the PHP bugs you're still going to have to figure that out.

Where is the source code? This clearly is not it https://github.com/x-tools/wikiviewstats

In T91320#2640993, @MusikAnimal wrote:

Where is the source code? This clearly is not it https://github.com/x-tools/wikiviewstats

I don't blieve it's under VCSanywhere. The github repo was created by me in order to VCS it... I didn't get around to it though sadly. I will be moving the code there and I'm sure we'll accept patches if someone wants to take on resurrecting the tool.