sql error

Discuss technical problems and features here
User avatar
Tristano
Green Belt
Posts: 320
Joined: Mon Jul 20, 2015 7:11 am
Location: The Netherlands
Languages: Italian (N), English (C1), Dutch (B2), French (B2--), Spanish (B1?), Hebrew (A0++ illiterate), Russian (on hold)
Language Log: viewtopic.php?f=15&t=5141
x 418

sql error

Postby Tristano » Mon Nov 28, 2016 1:39 pm

Hi guys,
I'm getting this error often today:
Attachments
fout.png
fout.png (11.37 KiB) Viewed 709 times
1 x

User avatar
jeff_lindqvist
Blue Belt
Posts: 843
Joined: Sun Aug 16, 2015 9:52 pm
Languages: sv, en
de, es
ga, eo
---
fi, yue, ro, tp, cy, kw, pt, sk
Language Log: viewtopic.php?f=15&t=2773
x 1307

Re: sql error

Postby jeff_lindqvist » Mon Nov 28, 2016 4:19 pm

It happened to me once or twice during the weekend but I just reloaded the page again, and then it worked fine.
0 x
Leabhair/Greannáin léite as Gaeilge: 9 / 18
Ar an seastán oíche: Oileán an Órchiste
Duolingo - finished trees: sp/ga/de/fr/pt/it
Finnish with extra pain : 100 / 100

User avatar
Tristano
Green Belt
Posts: 320
Joined: Mon Jul 20, 2015 7:11 am
Location: The Netherlands
Languages: Italian (N), English (C1), Dutch (B2), French (B2--), Spanish (B1?), Hebrew (A0++ illiterate), Russian (on hold)
Language Log: viewtopic.php?f=15&t=5141
x 418

Re: sql error

Postby Tristano » Wed Nov 30, 2016 11:24 am

Yes of course. Yesterday I had 5 minutes where I couldn't log in at all. Now I had it once again but I could login immediately after.
My suggestion is that these kind of issues are not overlooked as they are a turn off and in the extreme case becomes like the old HTLAL.
0 x

User avatar
rdearman
Site Admin
Posts: 2314
Joined: Thu May 14, 2015 4:18 pm
Location: United Kingdom
Languages: English (N)
French (studies), Italian (studies), Mandarin (studies),
Esperanto TAC (Only god knows why), Finnish (only in it for the cookies)
Language Log: viewtopic.php?f=15&t=1836
x 4634
Contact:

Re: sql error

Postby rdearman » Wed Nov 30, 2016 1:38 pm

Tristano wrote:Yes of course. Yesterday I had 5 minutes where I couldn't log in at all. Now I had it once again but I could login immediately after.
My suggestion is that these kind of issues are not overlooked as they are a turn off and in the extreme case becomes like the old HTLAL.

The problem is this is shared hosting and in order to eliminate the problem I would have to get a dedicated server. This would mean I couldn't continue to fund the site out of my own pocket, so then we'd have to have some donation drive, or charging model, or advertising. So it is a bit of a trade off between keeping it free (to you) and getting more robust service. I will chase up the hosting company, and I will start looking again at alternatives for DB hosting. There isn't a quick fix for this, but I take your point.
6 x

User avatar
smallwhite
Brown Belt
Posts: 1018
Joined: Mon Jul 06, 2015 6:55 am
Location: Αυστραλία
Languages: Cantonese (n) > Mandarin > Eng > Spa > Fra (C1) > Ita > Deu > Swe.
.
Studying: Nederlands > Ελληνικά.
·
x 1621
Contact:

Re: sql error

Postby smallwhite » Wed Nov 30, 2016 2:50 pm

But the error that OP posted was a "No such file" and not a "Too many connections".

And even with the latter, I've read that sometimes it's actually the result of suboptimal code rather than there being too many visitors.
2 x
Dutch
6906 words on flashcards
Greek
2208 words on flashcards
0236 words on scrap paper

User avatar
Tristano
Green Belt
Posts: 320
Joined: Mon Jul 20, 2015 7:11 am
Location: The Netherlands
Languages: Italian (N), English (C1), Dutch (B2), French (B2--), Spanish (B1?), Hebrew (A0++ illiterate), Russian (on hold)
Language Log: viewtopic.php?f=15&t=5141
x 418

Re: sql error

Postby Tristano » Thu Dec 01, 2016 9:49 am

rdearman wrote:The problem is this is shared hosting and in order to eliminate the problem I would have to get a dedicated server. This would mean I couldn't continue to fund the site out of my own pocket, so then we'd have to have some donation drive, or charging model, or advertising. So it is a bit of a trade off between keeping it free (to you) and getting more robust service. I will chase up the hosting company, and I will start looking again at alternatives for DB hosting. There isn't a quick fix for this, but I take your point.


I also take your point. I'm one of the users who won't mind to pay a subscription fee, but I can imagine that for many users isn't the same and it would result in a loss of users - of course an undesired situation.
For the remark over the poor quality software: probably it's a bug that affects this version where the error message doesn't match the actual event. That can possibly be solved with a new version of the platform. My report is anyway meant to notify an existing issue, as I didn't find other notifications.
1 x

User avatar
Teango
Green Belt
Posts: 336
Joined: Mon Jul 06, 2015 4:55 am
Location: Honolulu, USA
Languages: Adv: English (N), German.
Int: Russian, Hawaiian, New Zealand Sign Language (NZSL), French, Hawaiian Pidgin English, Spanish.
Beg: Japanese, Irish, Swedish, Latin, Ancient Egyptian, Toki Pona.
Language Log: https://teango.wordpress.com/
x 866
Contact:

Re: sql error

Postby Teango » Fri Dec 02, 2016 12:26 am

I've also experienced several sql and "unable to connect to server" errors over the last few days. The last time I was unable to access the server was about 15 minutes ago (00:10 UTC/GMT, 14:10 my local time).

Do we have a Twitter feed or something similar just in case things go south for longer periods of time? I think it would be useful to have an emergency/downtime link posted somewhere on the forum to keep everyone informed and up to date in case of sudden technical issues or difficulties (apologies if this is already posted somewhere and I simply missed it).
0 x
  • Language: NZSL | Goal: Complete "Thumbs Up!" course, units: 17 / 20
  • Language: NZSL | Goal: Complete "Learn NZSL" course, units: 4 / 9

User avatar
Serpent
Black Belt - 2nd Dan
Posts: 2326
Joined: Sat Jul 18, 2015 10:54 am
Location: Moskova
Languages: heritage
Russian (native); Belarusian, Polish

fluent or close: Finnish+ (certified C1), English; Portuguese, Spanish, German+, Italian+
learning: Croatian+, Ukrainian, Czech; Romanian+, Galician; Danish, Swedish
exploring: Latin, Karelian, Catalan, Dutch, Chaucer's English
+ means exploring the dialects/variants
x 2966
Contact:

Re: sql error

Postby Serpent » Fri Dec 02, 2016 12:40 am

We have a Facebook group and wikia. There's also a twitter and mailing list but I'm less confident about those.
1 x
: 2 / 40 Budva na pjenu od mora: 3rd season (Croatian/Montenegrin)
LyricsTraining now offers Catalan, Turkish and Japanese romaji

User avatar
tomgosse
Brown Belt
Posts: 1023
Joined: Tue Aug 25, 2015 11:29 am
Location: Massachusetts, USA
Languages: English (Native)
French (A1)
Language Log: viewtopic.php?f=15&t=1185
x 1858
Contact:

Re: sql error

Postby tomgosse » Tue Dec 06, 2016 12:16 pm

Just an FYI: I'm getting numerous sql errors and timeouts this morning (7a.m. EST). This has been going on for about two hours. And while it is very frustrating, I still want to thank rdearman for hosting this forum.
5 x
Rejoignez notre groupe français ! Les Voyageurs

William Camden
Green Belt
Posts: 310
Joined: Sat Nov 14, 2015 2:47 am
Location: Greenwich Mean Time zone
Languages: English (N), German (fluent), Turkish (fluent), Russian (fluent), French (semi-fluent), Spanish (semi-fluent), am studying Polish, have some knowledge of it, also studying modern Greek, basic knowledge of Arabic (mostly MSA, some exposure to colloquial dialects), basic knowledge of Latin and Italian, beginner in Scottish Gaelic.
x 335

Re: sql error

Postby William Camden » Wed Dec 07, 2016 3:58 pm

I couldn't get into it yesterday and only tried again five minutes ago. If I had still not been able to get in, I would have sought a technical solution, like sacrificing a goat.
4 x
: 9 / 25Greek FSI Part 1
: 3826 / 3826Greek Memrise


Return to “Technical Support and Feature Requests”

Who is online

Users browsing this forum: No registered users and 1 guest