Search found 1201 matches

by szsori
Tue Nov 27, 2018 5:31 pm
Forum: General Discussion
Topic: I want to be a moderator
Replies: 10
Views: 267

Re: I want to be a moderator

v2 of the site has series-specific moderators, which get full moderator access but only to specific series. I believe we should also look at some form of translator role that can modify the translations on any records without touching the rest of the information.
by szsori
Tue Nov 27, 2018 5:29 pm
Forum: General Discussion
Topic: Site slowness
Replies: 90
Views: 3528

Re: Site slowness

I'll test late tonight, which will be evening in Europe. I should be able to see the queries or processes that are causing the issue.
by szsori
Mon Nov 26, 2018 1:56 am
Forum: General Discussion
Topic: Site slowness
Replies: 90
Views: 3528

Re: Site slowness

I'm keeping an eye on it and right now it seems fast. Nothing that looks out of order in the queries either. I'll continue to monitor. We're on v1.5, which has mostly the same appearance as v2 but is still running off the old database. It's a stopgap to address some critical security issues and allo...
by szsori
Sun Nov 25, 2018 2:08 pm
Forum: General Discussion
Topic: Site slowness
Replies: 90
Views: 3528

Re: Site slowness

Oh, and with regard to this: Maybe it would be possible to seperate db server, the web api and the web site used to enter / update data or at least reserve bandwith for the web site part or something. We have multiple DB servers, including a read-only one used for the API, as well as multiple load b...
by szsori
Sun Nov 25, 2018 2:04 pm
Forum: General Discussion
Topic: Site slowness
Replies: 90
Views: 3528

Re: Site slowness

The site had a bug that was causing issues with speed, but I resolved that earlier this weekend. Before it happened I was getting 10-15 second page loads, 503 errors, and some other issues. But once I fixed the bug the site load times went to 2-3 seconds, which is well within the target range. I've ...
by szsori
Sun Nov 25, 2018 2:54 am
Forum: v2 Deployment
Topic: V2 really slow to browse - add old option?
Replies: 7
Views: 922

Re: V2 really slow to browse - add old option?

Version 2 of the site isn't even live. We're currently on the 1.5 version of the site. I'm working on things, but I have to prioritize a certain way based on limited time available. No matter what we won't be bringing the old version live, though. It was full of massive security holes and required c...
by szsori
Fri Nov 23, 2018 1:33 am
Forum: v2 Deployment
Topic: Can't update translations (Invalid episode)
Replies: 9
Views: 642

Re: Can't update translations (Invalid episode)

Sorry, this is fixed now. I over-patched a security hole. Now it's *just* secure enough.
by szsori
Fri Sep 14, 2018 7:08 pm
Forum: Policy Inquiries
Topic: Lost mod/admin rights without notice
Replies: 1
Views: 278

Re: Lost mod/admin rights without notice

Send me an email with your contact info: [email protected]. I think I have the correct information, but I'm validating each moderator account individually on the new site. Sorry for the oversight.
by szsori
Fri Aug 31, 2018 9:36 pm
Forum: General Discussion
Topic: Episode editing throwing fatal errors
Replies: 6
Views: 170

Re: Episode editing throwing fatal errors

Should be done tonight sometime. Sorry folks.
by szsori
Fri Jun 01, 2018 3:59 pm
Forum: v2 Deployment
Topic: Search issues with the new site
Replies: 25
Views: 1851

Re: Search issues with the new site

That query provided would work great if we were doing substring matches. We're not: SELECT tvseries.*, (SELECT name FROM languages WHERE id=translation_seriesname.languageid LIMIT 1) AS translation_language, translation_seriesname.translation, (SELECT MIN(FirstAired) FROM tvepisodes WHERE seriesid=t...