Problem adding a mysql database  [SOLVED]

Locked
User avatar
Victor
Posts: 17
Joined: Sun 21. Jun 2020, 20:23

Problem adding a mysql database

Post 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!
Something something, dark side.
nikko
Posts: 914
Joined: Fri 15. Apr 2016, 16:11

Re: Problem adding a mysql database  [SOLVED]

Post by nikko »

The software said: Requires Win Vista®, 7®, 8® or better. And so I installed Linux.
User avatar
Victor
Posts: 17
Joined: Sun 21. Jun 2020, 20:23

Re: Problem adding a mysql database

Post by Victor »

Setting table_definitiion_cache to 10000 in mysql worked, thank you!
Something something, dark side.
Locked