DB User cannot be created - Unknown column 'database_user_prefix'
Hi,
I don't know when you changed this behaviour but I guess since there is not 1:1 relation between DB user and DB I am not able to create a DB user. When I try I get the following error in the Browser:
#0 db->query(INSERT INTO web_database_user
(server_id
, database_user
, database_user_prefix
, database_password
, sys_userid
, sys_groupid
, sys_perm_user
, sys_perm_group
, sys_perm_other
) VALUES ('1', 'c1MYSTRING', 'c1', '*11E9912BD83597CF97126CADBCEDAC96A0202191', '2', '2', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:244] #1 (closed) tform_actions->onInsertSave(INSERT INTO web_database_user
(server_id
, database_user
, database_user_prefix
, database_password
, sys_userid
, sys_groupid
, sys_perm_user
, sys_perm_group
, sys_perm_other
) VALUES ('1', 'c1MYSTRING', 'c1', '*11E9912BD83597CF97126CADBCEDAC96A0202191', '2', '2', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:188] #2 (closed) tform_actions->onInsert() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:87] #3 (closed) tform_actions->onSubmit() called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:117] #4 (closed) page_action->onSubmit() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:68] #5 (closed) tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/sites/database_user_edit.php:228] Unknown column 'database_user_prefix' in 'field list'
There is actually no such column. There's only database_user. When I create a new DB with an existing user... This specific user effectively has no rights to access this specific DB.
See also this thread: http://www.howtoforge.com/forums/showthread.php?t=61579