Hmm... well, we got rid of all the errors in dblog!
There was one more error after your commit, the same issue but with
"journal__save_recurring_print" instead of "journal__save_recurring"... I
went ahead and did the same RETURN * thing after that and the error went
away.
However, my browser still returns the same message:
Error!
*Error from Function:
ERROR: Cannot grant permissions to a non-existant user. More information
has been reported in the error logs at LedgerSMB.pm line 987. *
dbversion: 1.4.0, company:
(I don't know why my "company" comes up blank, related issue?)
Even though dblog and the other files in there all looked good, my apache
error.log had a lot of intersting information in it:
--------------------------------------------------------------------------------
[Fri May 17 12:11:07 2013] [error] [client 127.0.0.1] DBD::Pg::st execute
failed: ERROR: column "version" does not exist, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:11:07 2013] [error] [client 127.0.0.1] LINE 1: SELECT
version FROM defaults, referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:11:07 2013] [error] [client 127.0.0.1] ^ at
LedgerSMB/Database.pm line 328., referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] Use of uninitialized
value $format in uc at LedgerSMB/PGDate.pm line 161., referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] DBD::Pg::st execute
failed: ERROR: Cannot grant permissions to a non-existant user. at
LedgerSMB.pm line 707., referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] 2013/05/17 12:12:06 -
ERROR - LedgerSMB::dberror LedgerSMB.pm (984) -- Logging SQL State P0001,
error 7, string ERROR: Cannot grant permissions to a non-existant user.,
referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] 2013/05/17 12:12:06 -
ERROR - LedgerSMB::_error LedgerSMB.pm (825) -- Error from Function:,
referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] ERROR: Cannot grant
permissions to a non-existant user., referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] More information has
been reported in the error logs at LedgerSMB.pm line 987., referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] 2013/05/17 12:12:06 -
ERROR - LedgerSMB::_error LedgerSMB.pm (826) -- dbversion: 1.4.0, company:
, referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] Died at LedgerSMB.pm
line 839., referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:06 2013] [error] [client 127.0.0.1] Compilation failed in
require at /var/www/lsmb14/setup.pl line 8., referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:07 2013] [error] [client 127.0.0.1] Directory index
forbidden by Options directive: /var/www/lsmb14/css/, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/firefox.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/opera.js, referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/konqueror.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/iexplore.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/logout/epiphany.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/safari.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/iexplore.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/opera.js, referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/firefox.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/konqueror.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:37 2013] [error] [client 127.0.0.1] File does not exist:
/var/www/lsmb14/UI/setup/safari.js, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:56 2013] [error] [client 127.0.0.1] DBD::Pg::st execute
failed: ERROR: column "version" does not exist, referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:56 2013] [error] [client 127.0.0.1] LINE 1: SELECT
version FROM defaults, referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:12:56 2013] [error] [client 127.0.0.1] ^ at
LedgerSMB/Database.pm line 328., referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] Use of uninitialized
value $format in uc at LedgerSMB/PGDate.pm line 161., referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] DBD::Pg::st execute
failed: ERROR: Cannot grant permissions to a non-existant user. at
LedgerSMB.pm line 707., referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] 2013/05/17 12:13:44 -
ERROR - LedgerSMB::dberror LedgerSMB.pm (984) -- Logging SQL State P0001,
error 7, string ERROR: Cannot grant permissions to a non-existant user.,
referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] 2013/05/17 12:13:44 -
ERROR - LedgerSMB::_error LedgerSMB.pm (825) -- Error from Function:,
referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] ERROR: Cannot grant
permissions to a non-existant user., referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] More information has
been reported in the error logs at LedgerSMB.pm line 987., referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] 2013/05/17 12:13:44 -
ERROR - LedgerSMB::_error LedgerSMB.pm (826) -- dbversion: 1.4.0, company:
, referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] Died at LedgerSMB.pm
line 839., referer: http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] Compilation failed in
require at /var/www/lsmb14/setup.pl line 8., referer:
http://localhost/lsmb14/setup.pl
[Fri May 17 12:13:44 2013] [error] [client 127.0.0.1] Directory index
forbidden by Options directive: /var/www/lsmb14/css/, referer:
http://localhost/lsmb14/setup.pl
On Fri, May 17, 2013 at 11:51 AM, Erik Huelsmann <[email protected]> wrote:
> 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 <[email protected]>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
>> <[email protected]>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
>>> <[email protected]>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 <[email protected]>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
>>>>> [email protected]
>>>>> 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
>>> [email protected]
>>> 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
>> [email protected]
>> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
