Topic : Unable to create a second database in Webuzo
Posted By: vtolenti89 on April 10, 2020, 7:20 pm
I have current a fully functional database and when I try to add a second database, the following error is shown:
Error: Invalid Database
Any ideas, what might have gone wrong?
Thankns in advance.
Posted By: vtolenti89 on April 10, 2020, 7:42 pm | Post: 1
I tried again with a smaller name, and it worked. It is strange though, because in the MYSQL documentation, it was written somewhere that the database name can be approx. 63 chars long.
Posted By: arish on April 13, 2020, 2:54 pm | Post: 2
Hi vtolenti89,
Sorry for the inconvenience.
Can you please let us know the DB name length so we can replicate this on our site?
Edited by arish : April 13, 2020, 2:55 pm
Posted By: vtolenti89 on April 14, 2020, 8:51 am | Post: 3
Hi arish,
The first database had the following markup
outxxxxxx_gxxx
and the second one (which did not work)
staging_outxxxxxx_gxxx
I had to have the second one renamed to
s_outxxxxxx_gxxx
Posted By: salman on April 22, 2020, 11:15 am | Post: 4
Hi,
Webuzo doesn't allow database name ore than 16 character, and since your database is more than 16 character hence it was not created.
Please do not use database more than 16 character then you will be able to create database.