2644:7756 --

Mac OS X
omfgppc
2008-08-18
2013-03-08
  • omfgppc
    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