Can't modify report

[addady2]

Hi,

I can't modify my reports, it hang on step "5 Calculation" in red. attach screen shot.
Even if I create new very simple report after saving I can't modify it for the same reason.
Why?

[joebordes]

Hi

we tried but can't reproduce. you are probably getting a javascript error that could give us some clue. If you can open the inspector and share the error with us.

if you can reproduce it in the online demo, we can have a look there too

[addady2]

(08-10-2022, 08:00 PM)joebordes Wrote: Hi

we tried but can't reproduce. you are probably getting a javascript error that could give us some clue. If you can open the inspector and share the error with us.

if you can reproduce it in the online demo, we can have a look there too

I can't reproduce it in the demo.
On my installation js console error is:

> we got 500 internal server error

On the server log file

>PHP Fatal error:  Call to a member function RecordCount() on array in ....../include/database/PearDatabase.php on line 648

Look to me like some DB problem?
I activate the CRM debug and the last like is:

> select vtiger_reportdatefilter.* from vtiger_reportdatefilter inner join vtiger_report on vtiger_report.reportid = vtiger_reportdatefilter.datefilterid where vtiger_report.reportid=27

When I run the query on the DB the result look valid, attach screenshot

What can it be?

Thanks

[joebordes]

This is the error we are interested in

>PHP Fatal error: Call to a member function RecordCount() on array in ....../include/database/PearDatabase.php on line 648

that log file should have a list of more calls that were made to get to that point, we are probably looking for the previous or two before the one you shared. If you can copy/paste the whole stack here I can point you around a little more.

[addady2]

...
2022-08-21T11:07:48+00:00 DEBUG index > return_module_language en_us,ProductComponent

2022-08-21T11:07:48+00:00 DEBUG index < return_module_language
2022-08-21T11:07:48+00:00 DEBUG index > return_module_language en_us,ProductComponent
2022-08-21T11:07:48+00:00 DEBUG index < return_module_language
2022-08-21T11:07:48+00:00 DEBUG index > is_admin admin
2022-08-21T11:07:48+00:00 DEBUG index < is_admin
2022-08-21T11:07:48+00:00 DEBUG index > getAllUserGroups 1
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_users2group where userid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [1]
2022-08-21T11:07:48+00:00 DEBUG index > fetchUserRole 1
2022-08-21T11:07:48+00:00 DEBUG index > pquery select roleid from vtiger_user2role where userid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [1]
2022-08-21T11:07:48+00:00 DEBUG index < fetchUserRole
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2role where roleid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H2]
2022-08-21T11:07:48+00:00 DEBUG index > getParentRole H2
2022-08-21T11:07:48+00:00 DEBUG index > getRoleInformation H2
2022-08-21T11:07:48+00:00 DEBUG index > pquery select * from vtiger_role where roleid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H2]
2022-08-21T11:07:48+00:00 DEBUG index < getRoleInformation
2022-08-21T11:07:48+00:00 DEBUG index < getParentRole
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2rs where roleandsubid in (?,?)
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H1,H2]
2022-08-21T11:07:48+00:00 DEBUG index > getAllParentGroups 3
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2grouprel where containsgroupid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [3]
2022-08-21T11:07:48+00:00 DEBUG index < getAllParentGroups
2022-08-21T11:07:48+00:00 DEBUG index < getAllUserGroups
2022-08-21T11:07:48+00:00 DEBUG index > pquery select userid
                    from vtiger_user2role
                    inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid
                    inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid
                    where vtiger_role.parentrole like '::%'
2022-08-21T11:07:48+00:00 DEBUG index > pquery select vtiger_reportmodules.*,vtiger_report.*
                    from vtiger_report
                    inner join vtiger_reportmodules on vtiger_report.reportid = vtiger_reportmodules.reportmodulesid
                    where vtiger_report.reportid = ?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [27]
2022-08-21T11:07:48+00:00 DEBUG index > pquery select vtiger_reportdatefilter.*
            from vtiger_reportdatefilter
            inner join vtiger_report on vtiger_report.reportid = vtiger_reportdatefilter.datefilterid
            where vtiger_report.reportid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [27]

[joebordes]

sorry, that is the wrong log file

the `PHP Fatal error` is in the apache error.log file along with the stack of calls that lead to that line, we need that log, that call stack, not the coreBOS log

[addady2]

(08-24-2022, 12:47 PM)joebordes Wrote: sorry, that is the wrong log file

the `PHP Fatal error` is in the apache error.log file along with the stack of calls that lead to that line, we need that log, that call stack, not the coreBOS log

...
[23-Aug-2022 10:06:22 UTC] PHP Notice:  Undefined index: <div class="componentName">No Data Found</div> in /mnt/2bck/crm/primetech/Smarty/templates_c/dffac47be66d1bb411668e35e67254eba4b1e6d0_0.file.HomeBlock.tpl.php on line 304


[24-Aug-2022 13:16:08 UTC] PHP Fatal error:  Call to a member function RecordCount() on array in /..../include/database/PearDatabase.php on line 648
...

The is no stack of call in my server error.log
Probably some httpd.conf or php.ini definition. Do you have a clue where can I set is on?

[joebordes]

try changing error_reporting and display_errors in your config.inc.php file

around the top you will see them

PHP Code:

error_reporting(-1);
ini_set('display_errors', 1); 


[addady2]

(08-24-2022, 01:43 PM)joebordes Wrote: try changing error_reporting and display_errors in your config.inc.php file

around the top you will see them

PHP Code:

error_reporting(-1);
ini_set('display_errors', 1); 


Not much progress, I got the same error,, to the browser:

<br />

<b>Fatal error</b>:  Call to a member function RecordCount() on array in <b>.../include/database/PearDatabase.php</b> on line <b>648</b><br />

[joebordes]

not much we can do without knowing what the query is.


I suppose it is this line:  https://github.com/tsolucio/corebos/blob/master/include/database/PearDatabase.php#L588

if so you can try dumping $result

PHP Code:

public function getRowCount(&$result) {
  if (isset($result) && !empty($result)) {
    var_dump($result);
    $rows = $result->RecordCount();
  } else {
    $rows = 0;
  }
  return $rows;
}