Error message on website

http://lonksmc.epizy.com/bans/index.php?i=1

Error Message

Database error: SQLSTATE[42000]: Syntax error or access violation: 1461 Can’t create more than max_prepared_stmt_count statements (current value: 16382)

Other Information

This was working fine to display my banned players through the mysql database. It randomly stopped working. Why is this, and how do I fix it?

That error means that the database server itself has hit the limit of the number of prepared statements. As this limit is shared across all the websites using it, the database server is just overloaded. This is probably not something you can fix yourself.

This could have been a once-off issue, and we have safeguards set to shut down sites which are overloading the database.

Do you still experience this issue right now?

2 Likes

Hello,

This issue has been happening for about 3-5 days now and is still continuing this morning.
How to resolve?

It sounds like it’s really an InfinityFree side problem.

As this is an InfinityFree side problem, please could you fix this for me?

Yes, that definitely doesn’t seem intentional. I’ll look into it and let you know as soon as I know more.

EDIT I did some checking and I don’t think this is an InfinityFree issue.

In your database configuration, I see you’re using an IP address from ReliableSite.net/heavynode.net. So I do agree that a database server is malfunctioning, but it seems like it’s not our database server that’s having this issue.

2 Likes

Yes as admin said you are using third party interface in infinity database

yes I am connecting a MySQL database to the site to display the banned list of the users on an interface.
I do not think that it is the database server malfunctioning as the banned players are still banned.

Also, why am I getting redirected to http://suspendeddomain.org/i/ when I connect to my site?

Well, you came here asking for help with an error message you saw. And as far as I can tell, this error message is caused by a problem on the remote database server. If you say the database server is working fine, then I don’t know what’s causing the problem.

And specifically, it seems that this database server has too many prepared statements open. If the thing writing the bans doesn’t use prepared statements, then it might not be affected by this issue. But your website interacting with this database does.

I don’t see anything like that. The URL in your original post, http://lonksmc.epizy.com/bans/index.php?i=1 , just shows the same database connection error.

This has been fixed. Please could we delete this thread / remove the urls to my website?

A topic can’t be deleted under any circumstances, but urls can be rm by Mods