Locks up after copying to clipboard

[TinaWilde]

After selecting the character names from the local chat and pressing ctrl C PySpy says resolving character names to IDs and goes no further.

https://prnt.sc/xhTcmlwM6iT8

Not sure what has changed, worked fine the night before but does not seem to want to now.

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

System Environment:

• OS: [e.g. macOS, Windows]
• OS Version: [e.g. High Sierra, 10]
• PySpy Version [e.g. 0.1]

Additional context
Add any other context about the problem here.

[bobcate]

I experienced this the first time I tried this tool about a week ago. I guess it's truly dead then.

[bkmvlgit]

Yeah i have the same issue, running in Windows 10, Dual Xeon 128 gig ram, 250mbit fibre connection, PySpy version is v0.5.2.
Seems it stopped working after the last EVE patch, was fine before that and i use it on a daily basis.

[harveymw]

I too have seen this and it has been working.

[harveymw]

I pulled it down. going to see if I can figure out why

[harveymw]

Well that was a quick excursion. Its failing because it is attempting to contact its backend db.
from the src :
Query PySpy's proprietary kill database for the character ids provided as a list or tuple of integers. Returns a JSON containing one line per character id.

This db was hosted here: http://pyspy.pythonanywhere.com
and that page is gone. so the owner has either ran out of funds to host it or is not interested in doing it anymore.

[harveymw]

from looking at the project it is abandoned. There is no project members.

[bkmvlgit]

Well that is not great, gotten so used to this tool guess pirates little helper might still work, copy and pasting info manually from local to zkill is a fair bit of tedium, guess you could set up your own database but not sure what he was using i am mostly a DB2 guy myself.

[harveymw]

Well he has another project that is the pyspy backend. its what was hosted. would appear that he uses sqlite and mongo for kill mail storing. This can all be setup local. I will likely attempt to do that.

[leonahess]

Hey y'all,

yeah this project is unmaintained. Both me and the other maintainer don't have the time to work on it anymore. I was providing daily Database updates until now but will also stop doing that now.

[bkmvlgit]

Well thanks for keeping it going i noticed Pirates little helper is also not updated anymore, not sure how hard it is to set this up on your own but not a python programmer to begin with.

[FreeSide88]

I did some work and managed to bring pyspy to life.

From what I did:

• redesigned backend(moved mysql to postgresql, and some improvements with sqlite, mongodb; improved data collector)
• collected the base over the past three months, nothing prevents expanding
• reworked some of the pyspy requests from get to post

anyone interested in pyspy?
If there is feedback, I'm willing to share the code and support it to the best of my ability.

[harveymw]

I liked using it. If you could share code that would be cool. I too took a look at how it was put together with the notion of just running local.

[FreeSide88]

I made a similar server http://pyspy.pythonanywhere.com
Wondering how best to share the code? the pull request is unlikely to be accepted or to make a fork?

[bkmvlgit]

Would love to use it again if possible.

[harveymw]

I think it best to make a fork.

[FreeSide88]

however, at the moment I'm running the client through python3, not through exe. It may not be convenient for many. I will work through the issue with launching through the .exe file, as it was before.

[bkmvlgit]

Well a bat file would be a quick way to do that

[harveymw]

or pyinstaller

[FreeSide88]

I successfully forked, uploaded the code and made a working exe. you can see it in my profile. and I also expanded the database for the whole year.

[bkmvlgit]

Thanks, besides AVG going crazy with the file it seems to run alright, and the lookup seems to work to.
Did you update the about part with link to your version?

[FreeSide88]

Yes, iam updated about information.

[bkmvlgit]

Well the about window points to the original download link, which i guess is fine.

[FreeSide88]

i fix it