Page 1 of 1

Problem adding a mysql database

Posted: Mon 18. Oct 2021, 00:48
by Victor
Hello,

I am having trouble on server, Debian 11, KeyHelp 21.2 (Build 2305) when I try to create a database from a normal user account (which has permission set to create databases).
Whenever I try to create a new database (there already is one created, but I need another one) - I get the following error :

Database error: SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared

This is the URL I try to execute upon creation

Code: Select all

https://server/index.php?page=user_databases&action=add
Any idea why I'm getting this error and how can I fix it ?

From the logs I only got this ->

Code: Select all

Oct 18 01:43:24 master mariadbd[1345258]: 2021-10-18  1:43:24 804489 [Warning] Aborted connection 804489 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
However I'm not sure it's related, seems more like a bruteforce error from the smtp server, there is nothing else in the mysql logs.

Thank you!

Re: Problem adding a mysql database  [SOLVED]

Posted: Mon 18. Oct 2021, 07:15
by nikko

Re: Problem adding a mysql database

Posted: Mon 18. Oct 2021, 10:35
by Victor
Setting table_definitiion_cache to 10000 in mysql worked, thank you!