Hi,
Here is another patch that includes a fix for the other error I was getting: --- setup_old.pl 2014-03-23 19:46:28.000000000 +0000 +++ setup_new.pl 2014-03-29 21:09:51.000000000 +0000 @@ -614,6 +614,12 @@ edit => 'employeenumber', table => 'employee'}, + {query => "SELECT * FROM employee WHERE name = ''", + name => $locale->text('No blank employee name'), + cols => ['employeenumber', 'login', 'name'], + edit => 'name', + table => 'employee'}, + {query => 'SELECT * FROM employee WHERE employeenumber IN (SELECT employeenumber FROM employee @@ -650,6 +656,16 @@ } } + # Check to see if there is a heading, otherwise add a default --LH + my ( $count_heading ) = $request->{dbh}->selectrow_array( + "SELECT COUNT(*) FROM chart WHERE charttype = 'H'" + ); + unless ( $count_heading ) { + $request->{dbh}->do( + "INSERT INTO chart (id,accno,description,charttype,category,link,gifi_accno,contra) + VALUES (1, '0000', 'Minimal heading', 'H', '', '', '', false)"); + } + @{$request->{ar_accounts}} = _get_linked_accounts($request, "AR"); @{$request->{ap_accounts}} = _get_linked_accounts($request, "AP"); unshift @{$request->{ar_accounts}}, {}; Lyle On 29/03/2014 12:08, Lyle wrote:
|