* SQL Error

Please only post suggestions and requests for help on using this web site here.

For help with FAMILY HISTORIAN itself please post in the Using Family Historian - General Usage Forum above.
Post Reply
User avatar
BillH
Megastar
Posts: 1431
Joined: 31 May 2010 03:40
Family Historian: V6.2
Location: Washington State, USA

SQL Error

Post by BillH » 27 Mar 2017 16:04

This morning I have been getting the following error off and on while trying to access the site.

General Error
SQL ERROR [ mysqli ]
Too many connections [1040]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


Wasn't sure if this was something that you should be aware of or not.

User avatar
Jane
Site Admin
Posts: 7867
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: SQL Error

Post by Jane » 28 Mar 2017 10:19

If it happens again, please can you let me know what part of the site you were accessing (the URL would be ideal) along with the exact time you received the error, so I can pass the issue on to my ISP.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

User avatar
tatewise
Megastar
Posts: 17321
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: SQL Error

Post by tatewise » 28 Mar 2017 10:42

I occasionally get that too, so will provide similar feedback.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
LornaCraig
Megastar
Posts: 1611
Joined: 11 Jan 2005 17:36
Family Historian: V6.2
Location: Oxfordshire, UK

Re: SQL Error

Post by LornaCraig » 28 Mar 2017 11:44

I am writing this on my Android tablet, on which all is normal. However on my PC (which normally remembers my login) I am unable to login at all. After entering username and password and clicking Login nothing happens. Not even an error message. At the foot of the Forums page I am listed as being online (perhaps because I am online on the tablet) but at the top right it says Login where normally it shows my name, and I am clearly not logged in on the PC. There has also been an intermittent display problem with Jane's picture icon which shows a black bar down each side!
Lorna

User avatar
tatewise
Megastar
Posts: 17321
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: SQL Error

Post by tatewise » 28 Mar 2017 11:52

Jane has updated the FHUG URL to use https instead of http.
So you need to change your FHUG Forum bookmark to get Login to work.
I discovered the same problem earlier.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
Jane
Site Admin
Posts: 7867
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: SQL Error

Post by Jane » 28 Mar 2017 13:04

With regard to the SQL error, my ISP tells me this was a database server error at their end and should be resolved so if anyone sees the problem again please let me know.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

User avatar
BillH
Megastar
Posts: 1431
Joined: 31 May 2010 03:40
Family Historian: V6.2
Location: Washington State, USA

Re: SQL Error

Post by BillH » 28 Mar 2017 15:37

Jane,

I was just trying to access the main forum page. It hasn't happened again since yesterday morning. I will post the time and URL if it happens again.

avatar
Gowermick
Megastar
Posts: 727
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: SQL Error

Post by Gowermick » 28 Mar 2017 17:08

tatewise wrote:Jane has updated the FHUG URL to use https instead of http.
So you need to change your FHUG Forum bookmark to get Login to work.
I discovered the same problem earlier.
Thanks Mike, I was getting a bit annoyed with my iPad.
It was made worse because not being able to login, I couldn't report the problem.

Note to Jane,
I know you have been changing servers etc, but could you please warn us first if you need to play around with the URL. It was made worse on an iPad, because Safari doesn't normally show either the http or https part of the URL!
It was only because my PC worked, that I was able to login and post this comment.
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
Jane
Site Admin
Posts: 7867
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: SQL Error

Post by Jane » 28 Mar 2017 17:10

I have already posted a notice to this forum warning people to change their bookmarks.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

avatar
Gowermick
Megastar
Posts: 727
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: SQL Error

Post by Gowermick » 28 Mar 2017 17:25

Thank you Jane, but that message was posted after the problem had already occured.
As we couldn't login, we were not aware that you had posted a new message! :roll:

After giving us plenty of warning about the server change, I was a little disappointed you forgot to warn us in advance about the URL change.
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
PeterR
Megastar
Posts: 1059
Joined: 10 Jul 2006 16:55
Family Historian: V6.2
Location: Northumberland, UK

Re: SQL Error

Post by PeterR » 28 Mar 2017 18:24

Gowermick wrote: As we couldn't login, we were not aware that you had posted a new message!
But messages can be read without logging in, although the only clue that it's a new message is the timestamp. ;)
Peter Richmond (researching Richmond, Bulman, Martin, Driscoll, Baxter, Hall, Dales, Tyrer)

avatar
Gowermick
Megastar
Posts: 727
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: SQL Error

Post by Gowermick » 28 Mar 2017 18:46

Peter,
That only works if you are in that part of the forum. If the sub-forum title itself is not highlighted, to indicate it contains a new post, I won't bother looking in it! :D
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
tatewise
Megastar
Posts: 17321
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: SQL Error

Post by tatewise » 28 Mar 2017 19:15

In Jane's defence, we are all human, and sometimes make mistakes. I have made some real booboos. :oops:
I suspect it was not obvious beforehand that just changing the http: to https: would inhibit Logins via http:.
Remember we all do this voluntarily and are not paid professionally to run this site.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

Post Reply