Grading web site issue

General discussions about ratings.
Post Reply
User avatar
John Upham
Posts: 7152
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Grading web site issue

Post by John Upham » Thu Oct 31, 2013 2:04 pm

Am seeing a new error on the grading web site:
Warning: extract() [function.extract]: First argument should be an array in /data03/andreww/public_html/ecfgrading.org.uk/new/player.php on line 24
This was the servers response to

http://www.englishchess.org.uk/ecfgradi ... ef=295300G

or say

http://www.englishchess.org.uk/ecfgradi ... ef=294990J

suggesting the commonality is the applications way of dealing with a player who has been issued with a grading code but that this grading code is not in the db export shipped to the grading web site.

Nice error handling!
British Chess News : britishchessnews.com
Twitter: @BritishChess
Facebook: facebook.com/groups/britishchess :D

Richard Haddrell

Re: Grading web site issue

Post by Richard Haddrell » Thu Oct 31, 2013 5:27 pm

John Upham wrote:Am seeing a new error on the grading web site…
The grading web site has a perfectly serviceable contact address. Have you considered writing to it, John?

Richard Haddrell
Grading Administrator, ECF

User avatar
John Upham
Posts: 7152
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Re: Grading web site issue

Post by John Upham » Thu Oct 31, 2013 6:12 pm

Richard Haddrell wrote:
John Upham wrote:Am seeing a new error on the grading web site…
The grading web site has a perfectly serviceable contact address. Have you considered writing to it, John?

Richard Haddrell
Grading Administrator, ECF
I know.
No,
this is based on a recent experience of making contact.
British Chess News : britishchessnews.com
Twitter: @BritishChess
Facebook: facebook.com/groups/britishchess :D

Richard Haddrell

Re: Grading web site issue

Post by Richard Haddrell » Thu Oct 31, 2013 7:07 pm

John Upham wrote:this is based on a recent experience of making contact.
You intrigue me. But it wasn’t with me, and I don’t think this Forum is a sensible way of contacting the ECF grading department. Write to me and I will answer you.

Barry Sandercock
Posts: 1356
Joined: Tue Sep 11, 2012 10:52 am

Re: Grading web site issue

Post by Barry Sandercock » Wed Apr 30, 2014 10:20 am

The ecf database seems to be down as I can't get into it.

User avatar
John Upham
Posts: 7152
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Re: Grading web site issue

Post by John Upham » Wed Apr 30, 2014 10:39 am

Warning: mysqli_connect(): (42000/1203): User andreww_jonscode already has more than 'max_user_connections' active connections in /data03/andreww/public_html/ecfgrading.org.uk/new/procs.php on line 6
Suggests that the code is either not clearing down used connections correctly or it is simply creating too many new ones and hitting the limit imposed by the MySQL configuration.

As an aside I would not allow Warning level messages to be visible to the end user. I filter these for my own sites on an IP address level so that only I see them.

They can reveal details that should not be revealed such as user ID information.

The grading database should be using its own ring fenced PHP/MySQL server instance. All that is needed is to purchase another Bronze level CPanel from Zen Internet and migrate to that. Right now the grading database shares resources with other ECF resources such as the main web site which uses WordPress/PHP/MySQL.

Sharing sites on the same MySQL instance is a big mistake since poor code on one site could take down the other.
British Chess News : britishchessnews.com
Twitter: @BritishChess
Facebook: facebook.com/groups/britishchess :D

Barry Sandercock
Posts: 1356
Joined: Tue Sep 11, 2012 10:52 am

Re: Grading web site issue

Post by Barry Sandercock » Wed Apr 30, 2014 11:19 am

Thanks. It's o.k. now.

User avatar
John Upham
Posts: 7152
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Re: Grading web site issue

Post by John Upham » Wed Apr 30, 2014 12:00 pm

Until the next time it isn't.
British Chess News : britishchessnews.com
Twitter: @BritishChess
Facebook: facebook.com/groups/britishchess :D

Post Reply