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

Re: A little trouble installing 1.4.



Hi Chris,

Nobody was working on it, so I took the liberty to commit a fix. Could you tell me if it works now?

Bye,

Erik.


On Fri, May 17, 2013 at 8:31 PM, Chris Calef <..hidden..> wrote:
Hi, not sure if people are still in the middle of working on this, but I saw there were updates so I tried it again.  Results: not _quite_ there, but only one error this time!

The offending statement is this:


psql:sql/modules/Transaction_Templates.sql:161: ERROR:  return type mismatch in function declared to return recurring
DETAIL:  Function's final statement must be SELECT or INSERT/UPDATE/DELETE RETURNING.
CONTEXT:  SQL function "journal__save_recurring"


Cheers,
Chris C






On Fri, May 17, 2013 at 5:32 AM, Chris Travers <..hidden..> wrote:
Just letting folks know:

With svn 5815 I was able to create a new fresh db.  It took a bit longer because the new Roles.sql format doesn't get processed as quickly as the old format (however, it is now transactional and does a bunch of sanity checks which make it better for working with addons, etc).

I still ran into one significant setup bug but it has a fairly simple workaround.  I expect to get it fixed soon.  The bug report is at https://sourceforge.net/p/ledger-smb/bugs/826/ for anyone who wants to follow, and the workaround is listed there.

Best Wishes,.
Chris Travers


On Fri, May 17, 2013 at 3:52 AM, Chris Travers <..hidden..> wrote:
Just letting everyone know, I am working on the Roles.sql, entirely rewriting it so that it runs repeatably and transactionally.

I expect to have it committed shortly.

Best Wishes,
Chris Travers




On Thu, May 16, 2013 at 11:46 PM, Erik Huelsmann <..hidden..> wrote:
Hi Chris,

Still got quite a few errors, although you fixed several with that round... 

There was one more report_id vs adjust_id problem in Inventory_Report.sql, line 53, fixed that myself but you'll want to do it in the repo:

psql:sql/modules/Inventory_Report.sql:58: ERROR:  column l.report_id does not exist

LINE 8:      JOIN inventory_report_line l ON l.report_id = r.id


Fixed this one and found another one (just by inspecting the code).
 

Then, Transaction_Templates.sql had this now:

psql:sql/modules/Transaction_Templates.sql:134: ERROR:  missing "LOOP" at end of SQL _expression_
LINE 22:                           j.transaction_date);


Found a spurious semicolon. Removed. That should fix it.
 

Goods.sql is fixed now.

Still having trouble with some more of those menu_node ids.  I'll just summarize them here with the bad node id, they are all in my lsmb_roles.sql:

DETAIL:  Key (node_id)=(28) is not present in table "menu_node".
DETAIL:  Key (node_id)=(29) is not present in table "menu_node".
DETAIL:  Key (node_id)=(17) is not present in table "menu_node".
DETAIL:  Key (node_id)=(18) is not present in table "menu_node".
DETAIL:  Key (node_id)=(87) is not present in table "menu_node".
DETAIL:  Key (node_id)=(88) is not present in table "menu_node".
DETAIL:  Key (node_id)=(89) is not present in table "menu_node".
DETAIL:  Key (node_id)=(90) is not present in table "menu_node".
DETAIL:  Key (node_id)=(93) is not present in table "menu_node".
DETAIL:  Key (node_id)=(94) is not present in table "menu_node".
DETAIL:  Key (node_id)=(220) is not present in table "menu_node".
DETAIL:  Key (node_id)=(221) is not present in table "menu_node".


I'll do these in the course of the day: I want to be sure to remove the right bits in that table.

Bye,

Erik.

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel




------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel



------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel