+- 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: [solved] Error after update - in Report module (/showthread.php?tid=1059)
[solved] Error after update - in Report module - rslemer - 04-21-2018
After I updated my system, module report not execute any more.
Shows
Fatal error: Call to a member function FetchRow() on boolean in /usr/share/coreBOS/corebos-master/include/database/PearDatabase.php on line 668
Debug
------
2018-04-21T16:18:23+00:00 DEBUG report_list Prepared sql query being executed : 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 'H1::H2::%'
2018-04-21T16:18:23+00:00 DEBUG report_list Prepared sql query being executed : select vtiger_report.*, vtiger_reportmodules.*, vtiger_reportfolder.folderid
from vtiger_report
inner join vtiger_reportfolder on vtiger_reportfolder.folderid = vtiger_report.folderid";
inner join vtiger_reportmodules on vtiger_reportmodules.reportmodulesid = vtiger_report.reportid and ( ( vtiger_report.reportid IN (SELECT reportid from vtiger_reportsharing WHERE (shareid IN (?) AND setype='groups') OR (shareid=? AND setype='users'))) or vtiger_report.sharingtype='Public' or vtiger_report.owner = ? or vtiger_report.owner in (
select vtiger_user2role.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 'H1::H2::%'))
2018-04-21T16:18:23+00:00 DEBUG report_list Prepared sql query parameters : [3,31,31]
2018-04-21T16:18:23+00:00 INFO VT PearDatabase ->ADODB error Query Failed
elect vtiger_report.*, vtiger_reportmodules.*, vtiger_reportfolder.folderidfrom vtiger_report
inner join vtiger_reportfolder on vtiger_reportfolder.folderid = vtiger_report.folderid";
inner join vtiger_reportmodules on vtiger_reportmodules.reportmodulesid = vtiger_report.reportid and ( ( vtiger_report.reportid IN (SELECT reportid from vtiger_reportsharing WHERE (shareid IN (?) AND setype='groups') OR (shareid=? AND setype='users'))) or vtiger_report.sharingtype='Public' or vtiger_report.owner = ? or vtiger_report.owner in (
select vtiger_user2role.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 'H1::H2::%'))::->[1064]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '";
inner join vtiger_reportmodules on vtiger_reportmodules.reportmodulesid = ' at line 3
2018-04-21T16:18:24+00:00 INFO VT PearDatabase ->ADODB disconnect
How I can solve that?
RE: Error after update - in Report module - joebordes - 04-21-2018
Sorry about that. Update again I fixed it.
RE: Error after update - in Report module - rslemer - 04-21-2018
Thanks Joe!