Also, the edit or delete buttons in the items list are not fonctionning.

What can I do?

When I click on the store item button, here are the requests that appear in mode saltrailer = 1:

select * from 0_chart_master,0_chart_types,0_chart_class where account_type=id and class_id=cid order by account_code
SELECT attrib FROM xx_reports WHERE typ='funct'
SELECT * FROM xx_reports WHERE typ = 'block'
SELECT  * FROM xx_reports WHERE (typ = 'item' AND id='6')

There is no insert instruction.

The PHP version tested was:

There are 83 files in the standard FA distribution having a tab preceding a gettext function - _("xxx") - usage and this has never been a problem. Only in this case it was an assignment to a variable (an array variable in this instance).

The attached patch addresses a similar "=\t" issue with modules/repgen/repgen_strings.php as well.

Bugs yet to be fixed:
On activating the Reports Generator extension, when we try to edit, delete or copy the first and only report in the default list, we get to see the report iself like pressing the Run button. The Edit, Copy and Delete functionality seems lost.

In the hg 3127, it appears that the hooks.php of the modules are loaded before the translation strings get added and hence the non display. This is so since the section string is available only when install_access() is invoked.
Incidentally, the module/includes/acc_levels.php file does not seem to get used anywhere at all.

As a temporary workaround, I have commented out the define for the SS_REPORT_GENERATOR in the module's hooks.php and altered the install_access() function to be:

        function install_access()
        {

                $security_sections['SS_SPEC'] = _("Special maintenance");

                $security_areas['SA_REPORT_GENERATOR'] = array(SS_SPEC|130, _("Report Generator"));

                return array($security_areas, $security_sections);
        }

and it now shows up under Special maintenance section group.

/Joe

$parms = array(229988, "Report Generator", 116)
$ext = 3
$sec = 130

Fresh install of hg 3127 with only the repgen module installed. Module works when activated and role enabled. Only the group label is not displayed.

Attached are the snapshots of before and after ticking the checkbox.

/Joe

Bad section 38200:
Undefined offset: 229888 in file: /var/www/frontac/admin/security_roles.php at line 219

The security role Report generator is displayed corrrectly but the group name (line preceeding it) "Report Generator:" is not displayed but only ":".

I have just removed my installation of repgen and done a new install/activate exstension, Report Generator.

First I created the instance and secondly I activated it for the Training Co.

Then I imported the /sql/reports.sql manually into phpMyAdmin for the database.

Then, when looking in Setup Tab, the Report Generator is disabled (gray).

Then, go into Access Setup and select the role and at the very bottom you see the report regenerator. Check it and also check the next item.

Logout the company and login again.

Now you should be able to enter the Report Generator. And run the first report.

/Joe

The error may be due to themodules/repgen/includes/acc_levels.php(must the file extension be.inc?) using the old style $security_areas. This file is not used now.

$security_areas['SA_REPORT_GENERATOR'] = array(SS_SPEC|155, _("Report Generator"));

Must the SS_SPEC|155 above be SS_REPORT_GENERATOR|130 ?

Optionally the missing single quote for thedefinein line 23 of modules/repgen/hooks.php:

I can see the Report Generator Menu link greyed out in Setup -> Maintenance on the right side. It gets corrected when we tick the Setup -> Access Setup last ":" role for System Administrator, then the Report Generator checkbox pops up and on ticking and saving, logging out and logging back in, the Report Generator works.

One correction may be needed in the modules/repgen/sql/reports.sql file at line 59, the id should be '6' instead of 'B1' which is for blocks.

Some extra report definitions have been culled out of www.fvr.ro and attached herewith. Since the table xx_reports has no primary key, it seems to be accumulating duplicate records.

The installed_extensions.php file in the webroot uses true/false for the 'active' attribute of the array whereas it is 0/1 in the company/#/installed_extensions.php files. Renumbering the array elements in both files in the same manner maintains status quo.

Can the FA Admins correct it and upload a new PKG?

I tried to access the report generator directly from the URL and got the following error message:
(url: http://mysite.com/frontacc_m/modules/repgen/repgen_select.php)

Undefined index: SA_REPORT_GENERATOR in file: /var/www/html/twenty-test/frontacc_m/includes/current_user.inc at line 155

I can provide access to this fresh install as admin, as I will remove it after problem is solved.

Try the latest FA v2.3.13 Mercurial Build 3127 (it contains a few patches for installing modules)  from scratch - do not try restoring any previous data and do a fresh install of the module and then fix any errors in the module files and try.

I already tried the go_debug = 1 and 2, I applied the fix regarding ereg and preg in the file reporting/includes/Workbook.php, but this still doesn't help.

I also applied the fix in repgen_const.inc:
//$_SESSION['get_text']->add_domain($_SESSION['language']->code, $path_to_root.'/modules/repgen/lang');
$GetText->add_domain($_SESSION['language']->code, $path_to_root.'/modules/repgen/lang');

Still not working.

My PHP version is PHP 5.3.3.

Does someone have repgen working with 2.3.13?

Any suggestion?