English Chess Forum

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!

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

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.

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.

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

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.

Thanks. It's o.k. now.

Until the next time it isn't.