Search found 1201 matches
- Tue Nov 27, 2018 5:31 pm
- Forum: General Discussion
- Topic: I want to be a moderator
- Replies: 10
- Views: 267
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.
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...
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...
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 ...
- Sun Nov 25, 2018 2:54 am
- Forum: v2 Deployment
- Topic: V2 really slow to browse - add old option?
- Replies: 7
- Views: 922
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...
- Fri Sep 14, 2018 7:08 pm
- Forum: Policy Inquiries
- Topic: Lost mod/admin rights without notice
- Replies: 1
- Views: 278
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.
- Fri Jun 01, 2018 3:59 pm
- Forum: v2 Deployment
- Topic: Search issues with the new site
- Replies: 25
- Views: 1851
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...