+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Can't modify report (/showthread.php?tid=2406)
Pages:
1
2
Can't modify report - addady2 - 08-10-2022
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?
RE: Can't modify report - joebordes - 08-10-2022
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
RE: Can't modify report - addady2 - 08-21-2022
(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
RE: Can't modify report - joebordes - 08-21-2022
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.
RE: Can't modify report - addady2 - 08-24-2022
...
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]
RE: Can't modify report - joebordes - 08-24-2022
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
RE: Can't modify report - addady2 - 08-24-2022
(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?
RE: Can't modify report - joebordes - 08-24-2022
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);
RE: Can't modify report - addady2 - 08-25-2022
(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 />
RE: Can't modify report - joebordes - 08-25-2022
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;
}