#1310 internal database error at reports->trial balance

[amr]

in 1.4.9

reports->trial balance->Error!

1. reports
2. trial balance (select period from to)
3. Internal Database Error
   More information has been reported in the error logs at LedgerSMB.pm line 776.

dbversion: 1.4.9, company: demo14

[John Locke]

Hi,

I can confirm the same result in my production, with current code.

Error logged:

DBD::Pg::st execute failed: ERROR: function array_upper(integer[]) does not exist

[Louis Moore]

I am also getting this result.

Internal Database Error
More information has been reported in the error logs at LedgerSMB.pm line 776.

dbversion: 1.4.9,

DBI Trace contains several:

QUERY: SELECT t_roll_forward IS NULL
OR array_upper(in_business_units) > 0
CONTEXT: PL/pgSQL function trial_balance__generate(date,date,integer,integer[],text,integer[],integer) line 45 at IF" (err#0)
<- errstr= ( "ERROR: function array_upper(integer[]) does not exist
LINE 2: OR array_upper(in_business_units) > 0
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

type errors

[Anonymous]

Fixed by https://github.com/ledgersmb/LedgerSMB/pull/611

[Chris Travers]

This was reported through another channel and fixed for 1.4.10 first. 1.4.10 has a fix for this issue.