[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: add user in 1.3.43rc1



ouch.  patch applied.  

I wonder if I accidently reverted a patch or why the Travis CI tests (which do test db load btw) didn't fail. 

On Thu, Sep 11, 2014 at 2:03 PM, Pongrácz István <..hidden..> wrote:

I guess this is a brand new DB.

Check this patch:

diff -u Employee.sql Employee.sql-fixed
--- Employee.sql        2014-09-05 15:13:49.009844457 +0200
+++ Employee.sql-fixed  2014-09-11 22:58:12.264103592 +0200
@@ -9,7 +9,8 @@
 DROP FUNCTION IF EXISTS employee__save
 (in_entity_id int, in_start_date date, in_end_date date, in_dob date,
        in_role text, in_ssn text, in_sales bool, in_manager_id int,
- in_employee_number text)
+ in_employee_number text);
+
 CREATE OR REPLACE FUNCTION employee__save
 (in_entity_id int, in_start_date date, in_end_date date, in_dob date,
        in_role text, in_ssn text, in_sales bool, in_manager_id int,




The problem I guess is about there is a missing ';' at the end of the sql statement in the sql/modules/Employee.sql file.

Bye,
István





----------------eredeti üzenet-----------------
Feladó: "Michael Richardson" ..hidden..
Címzett: "Development discussion for LedgerSMB" ..hidden..
Dátum: Thu, 11 Sep 2014 13:18:14 -0400
-------------------------------------------------


>
> The setup.pl, "Add User" function results in:
>
> Error!
> No such function: employee__save
>
> --
> ] Never tell me the odds! | ipv6 mesh networks [
> ] Michael Richardson, Sandelman Software Works | network architect [
> ] ..hidden.. http://www.sandelman.ca/ | ruby on rails [
>
>
>
>
> --------------------------------------------------------------------
> ----------
> Want excitement?
> Manually upgrade your production database.
> When you want reliability, choose Perforce
> Perforce version control. Predictably reliable.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ost
> g.clktrk
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>



------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel