Error creating the database

guido

Verified User
Joined
Mar 20, 2004
Messages
23
I get the following error from DA

"Error creating the database -> Unable to add user visionspac"

I have a user account named "visionspac"

What I'm trying to to is create a database with the name "francine_1", so it should become "visionspac_francine_1"

Ok I'm sending the following info:

PHP:
$this->httpSocket->set_method('GET');
$this->httpSocket->query('/CMD_API_DATABASES', array(
'action' => 'create',
'name' => "francine_1",
'user' => "francine",
'passwd' => "xxxx",
'passwd2' => "xxxx"));
$result = $this->httpSocket->fetch_parsed_body();

ANd I'm logged in as user visionspace.

After sending this command I get the error!

Can someone help me in what Im doing wrong?

Thenx in advance
 
I believe it's because the complete name, visionspac_francine_1, is too long.

Jeff
 
You're right!

Your right -> but why the "hell" is de maxlength of a DB name 16 characters?

OR is there a way to change de Name of an account without deleting all the data? Because now I'm using "visionspac" as name, but that already takes up 11 characters in the database name (with a limit of 16) -> so than I want to change this into "vs" -> a lot easier.

Or just an extra feature, if it's possible, that a db name can have more characters (same with the username, with a max length of 10? why is that?)
 
Last edited:
Hello,

It's not the database name.. that's limited to 64 characters (assuming you have a newer version of da). It's the username that is limited to 16 characters, as specified by the mysql database:
Code:
mysql> describe db;
+-----------------------+-----------------+------+-----+---------+-------+
| Field                 | Type            | Null | Key | Default | Extra |
+-----------------------+-----------------+------+-----+---------+-------+
| Host                  | char(60) binary |      | PRI |         |       |
| Db                    | char(64) binary |      | PRI |         |       |
| User                  | [b]char(16)[/b] binary |      | PRI |         |       |
John
 
Aha logical!

But is there a way to change then account name "visionspac" in "vs"? Or must the user be deleted an recreated?
 
Fwiw, we always create usernames no more than eight characters, and we recommend our resellers do the same.

Gives us the most flexibility, and also gives us usernames we can easily read in a "long" directory listing.

Jeff
 
Back
Top