omfgppc - 2008-08-18

jfurc wrote: From the database log window after trying the actions described in the original post;

[code:1:d8b74780fe]
di aug 19 00:18:55 2008 ERROR:  expected just one rule action
CONTEXT:  SQL function \"usercancreateusers\" during startup
QPSQL: Unable to create query
SELECT script_source, script_order  FROM script WHERE((script_name=''errorLog'')   AND (script_enabled)) ORDER BY script_order;
di aug 19 00:18:55 2008 ERROR:  expected just one rule action
CONTEXT:  SQL function \"usercancreateusers\" during startup
QPSQL: Unable to create query
SELECT script_source, script_order  FROM script WHERE((script_name=''errorLog'')   AND (script_enabled)) ORDER BY script_order;
di aug 19 00:19:18 2008 ERROR:  expected just one rule action
CONTEXT:  SQL function \"usercancreateusers\" during startup
QPSQL: Unable to create query
SELECT script_source, script_order  FROM script WHERE((script_name=''errorLog'')   AND (script_enabled)) ORDER BY script_order;
di aug 19 00:19:18 2008 ERROR:  expected just one rule action
CONTEXT:  SQL function \"usercancreateusers\" during startup
QPSQL: Unable to create query
SELECT script_source, script_order  FROM script WHERE((script_name=''errorLog'')   AND (script_enabled)) ORDER BY script_order;
di aug 19 00:19:22 2008 ERROR:  expected just one rule action
CONTEXT:  SQL function \"usercancreateusers\" during startup
QPSQL: Unable to create query
SELECT *, userCanCreateUsers(usr_username) AS createusers,       userCanCreateUsers(CURRENT_USER) AS enablecreateusers,       emp_id FROM usr LEFT OUTER JOIN emp ON (usr_id=emp_usr_id) WHERE (usr_username=''admin'');
di aug 19 00:19:22 2008 ERROR:  expected just one rule action
CONTEXT:  SQL function \"usercancreateusers\" during startup
QPSQL: Unable to create query
SELECT *, userCanCreateUsers(usr_username) AS createusers,       userCanCreateUsers(CURRENT_USER) AS enablecreateusers,       emp_id FROM usr LEFT OUTER JOIN emp ON (usr_id=emp_usr_id) WHERE (usr_username=''admin'');
di aug 19 00:19:34 2008 ERROR:  role \"with\" does not exist
QPSQL: Unable to create query
ALTER USER  WITH PASSWORD ''newpasswd'';
di aug 19 00:19:34 2008 ERROR:  role \"with\" does not exist
QPSQL: Unable to create query
ALTER USER  WITH PASSWORD ''newpasswd'';
[/code:1:d8b74780fe]

The ''expected just one rule action'' seems to be a recurring theme? The second problem (role error) comes from the incorrect SQL statement; the user is not defined in the ALTER USER statement, which can probably be explained by the empty username field in the ''User Information'' dialog.

A bug in the client? -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=2644