When you try to install any app that requires an SQL database, and let Installatron handle the Database Details (creation of dbase and user within), it appears to be trying to create a name that's too long (maybe), and the install fails with a rather unhelpful error message:
Code: Select all
Unable to create a database. Check that your hosting account has at least one database available. If it does, please contact your host.
Technical Error: `' ,
(To immediately dispel that notion: I can create all the databases I want to. And a database WAS created by the install, but it failed. See below.)
I tested it with several users, which had progressively more or fewer characters in the name, and every time I tried, Installatron used a progressively longer database name. i.e.
That's right up against the 16-character limit for database name (including account prefix).
The odd part is that it DID CREATE the database, just as it appears above.
Is Installatron trying to create a database name of fixed length, instead of subtracting the account name length and the "_", before deciding on the length of an appended datbase/user name??
Or is that something misconfigured on the server or within DirectAdmin??
If I choose to handle the database creation details myself, and choose a database I already created (16-character limit, including account name and "_") then it works perfectly.
Thanks in advance.